Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Using the clause retains only one copy of such identical tuples.
a. null
b. unique
c. not null
d. distinct
Q. The primary key must be
a. unique
b. not null
c. both unique and not null
d. either unique or not null
Q. 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 collection of values & single value
Q. 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
Q. The phrase “greater than at least one” is represented in SQL by
a. < all
b. < some
c. > all
d. > some
Q. SQL applies predicates in the clause after groups have been formed, so aggregate functions may be used.
a. group by
b. with
c. where
d. having
Q. The keyword is used to access attributes of preceding tables or subqueries in the from clause.
a. in
b. lateral
c. having
d. with
Q. The EXISTS keyword will be true if:
a. any row in the subquery meets the condition only
b. all rows in the subquery fail the condition only
c. both of these two conditions are met
d. neither of these two conditions is met
Q. Which one of the following deletes all the entries but keeps the structure of the relation.
a. delete from r where p;
b. delete from instructor where dept name= ’finance’;
c. delete from instructor where salary between 13000 and 15000;
d. delete from instructor;
Q. The problem of ordering the update in multiple updates is avoided using
a. set
b. where
c. case
d. when
Q. The condition allows a general predicate over the relations being joined.
a. on
b. using
c. set
d. where
Q. Which of the join operations do not preserve non matched tuples?
a. left outer join
b. right outer join
c. inner join
d. natural join