adplus-dvertising
1. The SQL database language includes statements for:
a. Database definition.
b. Database manipulation.
c. Database control.
d. All of the above.
Answer: (d).All of the above.
2. A command to remove a relation from an SQL database
a. Delete table table name
b. Drop table table name
c. Erase table table name
d. Alter table table name
Answer: (b).Drop table table name
3. Which SQL Query is use to remove a table and all its data from the database?
a. Create Table
b. Alter Table
c. Drop Table
d. None of these
Answer: (c).Drop Table
4. A type of query that is placed within a WHERE or HAVING clause of another query is called
a. Super query
b. Sub query
c. Master query
d. Multi-query
Answer: (b).Sub query
5. Aggregate functions are functions that take a ___________ as input and return a single value.
a. Collection of values
b. Single value
c. Aggregate value
d. Both a & b
Answer: (a).Collection of values
6. Select __________ from instructor where dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary ?
a. Mean(salary)
b. Avg(salary)
c. Sum(salary)
d. Count(salary)
Answer: (b).Avg(salary)
7. All aggregate functions except _____ ignore null values in their input collection.
a. Count(attribute)
b. Count(*)
c. Avg
d. Sum
Answer: (b).Count(*)
8. A Boolean data type that can take values true, false, and________ .
a. 1
b. 0
c. Null
d. Unknown
Answer: (d).Unknown
9. Select count (____ ID)
from teaches
where semester = ’Spring’ and year = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.
a. Distinct
b. Count
c. Avg
d. Primary key
Answer: (a).Distinct
10. The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.
a. Or, in
b. Not in, in
c. In, not in
d. In, or
Answer: (c).In, not in
Page 1 of 38

GATE CSE Resources

Questions from Previous year GATE question papers

UGC NET Computer science Resources

UGC NET Previous year questions and practice sets

NET General Paper 1

UGC NET Previous year questions and practice sets

GATE CSE Online Test

Attempt a small test to analyze your preparation level. This GATE exam includes questions from previous year GATE papers.

UGC NET practice Test

Practice test for UGC NET Computer Science Paper. The questions asked in this NET practice paper are from various previous year papers.