DBMS Practice Test

1) The language that requires a user to specify the data to be retrieved without specifying
exactly how to get it is

2) Which of the following relational algebra operations do not require the participating
tables to be union-compatible?

3) Checkpoints are a part of

4) The rule that a value of a foreign key must appear as a value of some specific table is
called a

5) The clause in SQL that specifies that the query result should be sorted in ascending or
descending order based on the values of one or more columns is

6) What is a disjoint less constraint?

7) What is data integrity?

8) What are the desirable properties of a decomposition

9) In an E-R diagram double lines indicate

10) The operation which is not considered a basic operation of relational algebra is

11) Which of the following is not a consequence of concurrent operations?

12) As per equivalence rules for query transformation, selection operation distributes over

13) The metadata is created by the

14) If the closure of an attribute set is the entire relation then the attribute set is a

15) DROP is a ______ statement in SQL.

16) If two relations R and S are joined, then the non matching tuples of both R and S are
ignored in

17) The keyword to eliminate duplicate rows from the query result in SQL is

18) Relational Algebra is

19) Which of the following aggregate functions does not ignore nulls in its results?.

20) Shadow paging has

21) Which one is faster
a. select count(1) from table abc where column1 = ‘123’;
b. select count(*) from table abc where column1 = ‘123’;

22) Which of the below are true about DBMS and RDBMS?

23) Which two files are used during operation of the DBMS?

24) Which normal form is considered adequate for normal relational database design?

25) The part of a database management system which ensures that the data remains in a consistent state is