DBMS Quiz, Notes & Technology Articles

Constraints in SQL Quiz Questions and Answers Online 69 pdf eBooks Download

Learn constraints in sql quiz questions, online DBMS quiz 69 to practice. Free database management system MCQs questions and answers to learn constraints in sql MCQs with answers. Practice MCQs to test knowledge on constraints in sql, functional dependencies, project operation, specialization in dbms, client server architecture worksheets.

Free constraints in sql worksheet has multiple choice quiz question as clause used in sql for ensuring referential integrity is classified as, answer key with choices as primary key clause, secondary key clause, foreign key clause and interval key clause problem solving to test study skills. For viva learning help and jobs' interview preparation tips, study online schema definition, constraints, queries & views multiple choice questions based quiz question and answers.

Quiz on Constraints in SQL Quiz pdf Download Worksheet 69

Constraints in SQL Quiz

MCQ. Clause used in SQL for ensuring referential integrity is classified as

  1. PRIMARY KEY clause
  2. SECONDARY KEY clause
  3. FOREIGN KEY clause
  4. INTERVAL KEY clause


Functional Dependencies Quiz

MCQ. In functional dependency between two sets of attributes A and B then set of attributes A of database is classified as

  1. top right side
  2. down left side
  3. left hand side
  4. right hand side


PROJECT Operation Quiz

MCQ. In unary relational operations, PROJECT operation is partition of relation usually classified as

  1. horizontal partition
  2. vertical partition
  3. insert partition
  4. delete partition


Specialization in DBMS Quiz

MCQ. Leaf nodes in diagrams of generalization and specialization are considered as

  1. extension classes
  2. leaf classes
  3. inverted classes
  4. diverted classes


Client Server Architecture Quiz

MCQ. In two-tier client ⁄ server architecture, functions of transaction server and query server are controlled by

  1. server side
  2. host side
  3. modulation side
  4. client side