DBMS Quiz, Notes & Technology Articles

Constraints in SQL Quiz Questions and Answers 21 PDF Download

Learn constraints in sql quiz online, DBMS test 21 for online learning, distance learning courses. Free schema definition, constraints, queries & views quiz, constraints in sql multiple choice questions and answers to learn database management system quiz with answers. Practice tests for educational assessment on constraints in sql test with answers, database system environment, introduction to disk storage, eer model concepts, relational operations, constraints in sql practice test for online database design courses distance learning.

Free online constraints in sql course worksheet has multiple choice quiz question: constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called with options language based constraints, tuple based constraints, scale based constraints and precision based constraints with interesting topics from previous question papers, exam papers and online tutorial questions, study schema definition, constraints, queries & views multiple choice questions based quiz question and answers.

Quiz on Constraints in SQL Worksheet 21 Quiz PDF Download

Constraints in SQL Quiz

MCQ: Constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called

  1. language based constraints
  2. tuple based constraints
  3. scale based constraints
  4. precision based constraints

B

Relational Operations Quiz

MCQ: If matching tuples are not found, kind of OUTER JOIN operation which keeps all tuples of first and second relation is classified as

  1. LEFT OUTER JOIN
  2. FULL OUTER JOIN
  3. HALF OUTER JOIN
  4. DOWNWARD JOIN

B

EER Model Concepts Quiz

MCQ: Kind of class whose entities belongs to some other data class is called

  1. concrete classes
  2. abstract classes
  3. leaf node classes
  4. template classes

A

Introduction to Disk Storage Quiz

MCQ: Storage capacity of computer system is measured in

  1. mega bytes
  2. kilo bytes
  3. tera bytes
  4. all of above

B

Database System Environment Quiz

MCQ: Compiler which pull out commands written in host programming language from application program is classified as

  1. graphic compiler
  2. host compiler
  3. precompiled
  4. interface compiler

C