MCQ quiz on DBMS multiple choice questions and answers on DBMS MCQ questions quiz on DBMS objectives questions with answer test pdf. Professionals, Teachers, Students and Kids Trivia Quizzes to test your knowledge on the subject.

DBMS MCQ Questions and Answers Quiz

1. A relational database developer refers to a record as

  1. a criteria.
  2. a relation.
  3. a tuple.
  4. an attribute.

2. Which of the following is correct:

  1. a SQL query automatically eliminates duplicates.
  2. SQL permits attribute names to be repeated in the same relation.
  3. a SQL query will not work if there are no indexes on the relations
  4. None of these

3. Cartesian product in relational algebra is

  1. a Unary operator.
  2. a Binary operator.
  3. a Ternary operator.
  4. not defined.

4. The result of the UNION operation between R1 and R2 is a relation that includes

  1. all the tuples of R1
  2. all the tuples of R2
  3. all the tuples of R1 and R2
  4. all the tuples of R1 and R2 which have common columns

5. The statement in SQL which allows to change the definition of a table is

  1. Alter.
  2. Update.
  3. Create.
  4. select.

6. A set of possible data values is called

  1. attribute.
  2. degree.
  3. tuple.
  4. domain.

7. Which of the following database object does not physically exist?

  1. base table
  2. index
  3. view
  4. none of the above

8. The ______ operator is used to compare a value to a list of literals values that have beenspecified.

  1. BETWEEN
  2. ANY
  3. IN
  4. ALL

9. The physical location of a record is determined by a mathematical formula that trAnsformsa file key into a record location is :

  1. B-Tree File
  2. Hashed File
  3. Indexed File
  4. Sequential file.

10. _______ produces the relation that has attributes of R1 and R2

  1. Cartesian product
  2. Difference
  3. Intersection
  4. Product
Tags

MCQ Multiple Choice Questions and Answers on DBMS

DBMS Trivia Questions and Answers PDF

DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....