This quiz consists of the UGC NET questions of paper 2 of Computer Science and Applications conducted on 28 Aug 2016. This quiz is helpful for aspiring candidates of UGC NET and other competitive exams.
Congratulations - you have completed .
You scored %%SCORE%% out of %%TOTAL%%.
Your performance has been rated as %%RATING%%
i= 0, j = 1, k = – 1 x = 0.5, y = 0.0What is the output of given ‘C’ expression?
x * 3 && 3 || j | k
int * f[ ]( ) ;declares :
A function returning a pointer to an array of integers.
Array of functions returning pointers to integers.
A function returning an array of pointers to integers.
An illegal statement.
A function can only be declared a friend by a class itself.
Friend functions are not members of a class, they are associated with it.
Friend functions are members of a class.
It can have access to all members of the class, even private ones.
Virtual functions only
Inheritance, Virtual functions and references
reducing the number of joins required to satisfy a query.
eliminating uncontrolled redundancy of data stored in the database.
eliminating number of anomalies that could otherwise occur with inserts and deletes.
ensuring that functional dependencies are enforced.
(a) NULL values can be used to opt a tuple out of enforcement of a foreign key.
(b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is also in BCNF.
(c) The difference between the project operator \((\prod)\) in relational algebra and the SELECT keyword in SQL is that if the resulting table/set has more than one occurrences of the same tuple, then \(\prod\) will return only one of them, while SQL SELECT will return all.
One can determine that:
(a) and (b) are true.
(a) and (c) are true
(b) and (c) are true.
(a), (b) and (c) are true.
I and II only
I, II and III
SELECT A FROM R;
SELECT A, COUNT(*) FROM R;
SELECT A, COUNT(*) FROM R GROUP BY A;
SELECT A, B, COUNT(*) FROM R GROUP BY A, B;
Part 1 Part 3 Part 4 Part 5