UGC NET CS 2016 July – III
Last Updated :
Discuss
Comments
Question 1
Implicit return type of a class constructor is:
not of class type itself
class type itself
a destructor of class type
a destructor not of class type
Question 2
Which of the following option with reference to UNIX operating system is not correct?
INT signal is sent by the terminal driver when one types
and it is a request to terminate the current operation. - TERM is a request to terminate execution completely. The receiving process will clean up its state and exit.
- QUIT is similar to TERM, except that it defaults to producing a core dump if not caught.
- KILL is a blockable signal.
Question 4
Suppose that the time to do a null remote procedure call (RPC) (i.e. 0 data bytes) is 1.0 msec, with an additional 1.5 msec for every 1K of data. How long does it take to read 32 K from the file server as 32 1K RPCs ?
- 49 msec
- 80 msec
- 48 msec
- 100 msec
Question 5
Consider a source with symbols A, B, C, D with probabilities 1/2, 1/4, 1/8, 1/8 respectively. What is the average number of bits per symbol for the Huffman code generated from above information ?
- 2 bits per symbol
- 1.75 bits per symbol
- 1.50 bits per symbol
- 1.25 bits per symbol
Question 7
In C++, when one object's reference variable is assigned to another object's reference variable then
a copy of the object is created.
a copy of the reference is created.
a copy of the reference is not created.
it is illegal to assign one object reference variable to another object reference variable.
Question 8
Which of the following statements is TRUE? D1 : The decomposition of the schema R(A, B, C) into R1(A, B) and R2 (A, C) is always lossless. D2 : The decomposition of the schema R(A, B, C, D, E) having AD → B, C → DE, B → AE and AE → C, into R1 (A, B, D) and R2 (A, C, D, E) is lossless.
Both D1 and D2
Neither D1 nor D2
Only D1
Only D2
Question 9
In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify:
- Inheritances
- Fragments
- Locations
- Local formats
Question 10
Consider the following ORACLE relations :
R (A, B, C) = {<1, 2, 3>, <1, 2, 0>, <1, 3, 1>, <6, 2, 3>, <1, 4, 2>, <3, 1, 4> }
S (B, C, D) = {<2, 3, 7>, <1, 4, 5>, <1, 2, 3>, <2, 3, 4>, <3, 1, 4>}.
Consider the following two SQL queries SQ1 and SQ2 :
SQ1 : SELECT R⋅B, AVG (S⋅B)
FROM R, S
WHERE R⋅A = S⋅C AND S⋅D < 7
GROUP BY R⋅B;
SQ2 : SELECT DISTINCT S⋅B, MIN (S⋅C)
FROM S
GROUP BY S⋅B
HAVING COUNT (DISTINCT S⋅D) > 1;
If M is the number of tuples returned by SQ1 and N is the number of tuples returned by SQ2 then
- M = 4, N = 2
- M = 5, N = 3
- M = 2, N = 2
- M = 3, N = 3
Tags:
There are 75 questions to complete.
Take a part in the ongoing discussion
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy