Aspire Faculty ID #19030 · Topic: UGC NET Computer Science Dec 2019 (Paper II) · Just now
UGC NET Computer Science Dec 2019 (Paper II)

 Which of the component module of DBMS does rearrangement and possible ordering of operations, eliminate redundancy in query and use efficient algorithms and indexes during the execution of a query?

Solution

In DBMS, the query optimizer is responsible for choosing the most efficient way to execute a query.

It performs tasks like:

Rearranging operations

Choosing proper order of operations

Removing redundant operations

Using efficient algorithms and indexes

So, the required component is:

$query\ optimizer$

Previous 10 Questions — UGC NET Computer Science Dec 2019 (Paper II)

Nearest first
1
If we want to resize a $1024 \times 768$ pixels image to one that is $640$ pixels wide with the same aspect ratio, what…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
2
Which of the following algorithms is not used for line clipping?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
3
A rectangle is bound by the lines $x=0,\ y=0,\ x=5$ and $y=3$. The line segment joining $(-1,0)$ and $(4,5)$, if clippe…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
4
Which tag is used to enclose any number of javascript statements in HTML document?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
5
Let $A$ be the base class in $C++$ and $B$ be the derived class from $A$ with protected inheritance. Which of the follo…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
6
What is the output of following C program?#include <stdio.h>main(){    int i, j, x = 0;    fo…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
7
The following program is stored in the memory unit of the basic computer. Give the content of accumulator register in h…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
8
$(142)b+(112){b-2}=(75)_8$, find base $b$.
Topic: UGC NET Computer Science Dec 2019 (Paper II)
9
A micro instruction format has microoperation field which is divided into $2$ subfields $F1$ and $F2$, each having $15$…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
10
A computer uses a memory unit of $512K$ words of $32$ bits each. A binary instruction code is stored in one word of the…
Topic: UGC NET Computer Science Dec 2019 (Paper II)

Next 10 Questions — UGC NET Computer Science Dec 2019 (Paper II)

Ascending by ID
1
Given two tables $R1(x,y)$ and $R2(y,z)$ with $50$ and $30$ numbers of tuples respectively. Find the maximum number of …
Topic: UGC NET Computer Science Dec 2019 (Paper II)
2
Given two tables $EMPLOYEE(EID,ENAME,DEPTNO)$ and $DEPARTMENT(DEPTNO,DEPTNAME)$. Find the most appropriate statement of…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
3
Find the minimum number of tables required for converting the following entity relationship diagram into a relational d…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
4
A counting semaphore is initialized to $8$. $3$ wait $()$ operations and $4$ signal $()$ operations are applied. Find t…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
5
Which of the following is not needed by an encryption algorithm used in Cryptography?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
6
Which of the following CPU scheduling algorithms is/are supported by LINUX operating system?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
7
Consider a paging system where translation lookaside buffer $($TLB$)$, a special type of associative memory, is used wi…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
8
Suppose a system has $12$ magnetic tape drives and at the time $t_0$, three processes are allotted tape drives out of t…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
9
Which of the following interprocess communication model is used to exchange messages among co-operative processes?
Topic: UGC NET Computer Science Dec 2019 (Paper II)
10
Given a CPU time slice of $2$ ms and the following list of processes. Process Burst time $($ms$)$…
Topic: UGC NET Computer Science Dec 2019 (Paper II)
Ask Your Question or Put Your Review.

loading...