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 Quiz Question with Answer


1. _____________ function divides one numeric expression by another and returns theremainder.

  1. POWER
  2. MOD
  3. ROUND
  4. REMAINDER

2. Which of the operations constitute a basic set of operations for manipulating relational data?

  1. Predicate calculus
  2. Relational calculus
  3. Relational algebra
  4. None of the above

3. Key to represent relationship between tables is called

  1. Primary key
  2. Secondary Key
  3. Foreign Key
  4. None of these

4. Relational calculus is a

  1. Procedural language.
  2. Non- Procedural language.
  3. Data definition language.
  4. High level language.

5. Transaction processing is associated with everything below except

  1. producing detail, summary, or exception reports.
  2. recording a business activity.
  3. confirming an action or triggering a response.
  4. maintaining data.

6. Which of the following operation is used if we are interested in only certain columns of atable?

  1. PROJECTION
  2. SELECTION
  3. UNION
  4. JOIN

7. _________ data type can store unstructured data

  1. RAW
  2. CHAR
  3. NUMERIC
  4. VARCHAR

8. In an E-R diagram attributes are represented by

  1. rectangle.
  2. square.
  3. ellipse.
  4. triangle.

9. In an E-R diagram an entity set is represent by a

  1. rectangle.
  2. ellipse.
  3. diamond box.
  4. circle.

10. A file manipulation command that extracts some of the records from a file is called

  1. SELECT
  2. PROJECT
  3. JOIN
  4. PRODUCT

Tags :


Multiple Choice Questions and Answers on DBMS


DBMS Multiple Choice Questions and Answers


DBMS Trivia Quiz


DBMS Question and Answer PDF Online




Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....