Schema Definition, Constraints, Queries and Views Multiple Choice Questions 1 PDF Download

Learn schema definition, constraints, queries and views multiple choice questions (MCQs), DBMS test 1 for online course prep exams. Practice schemas statements in sql MCQs questions and answers on schemas statements in sql, constraints in sql, sql data definition and types for computer technology careers exam prep.

Free schema definition, constraints, queries and views quiz online, study guide has multiple choice question on in standard query language, types of drop commands include with options foreign key command, restrict command, cascade command and both a and c to test online e-learning skills for viva exam prep and job's interview questions with answers key. Study to learn schemas statements in sql quiz questions with online learning MCQs for competitive exam preparation test.

MCQ on Schema Definition, Constraints, Queries and Views Quiz PDF Download Test 1

MCQ. In Standard Query Language, types of DROP commands include

  1. RESTRICT command
  2. FOREIGN key command
  3. CASCADE command
  4. both a and c

D

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

MCQ. In SQL environment, collection of schemas is classified as

  1. value set
  2. catalog
  3. initiator
  4. integration

B

MCQ. Data type which can be fixed length or varying length as CHAR(n) and VARCHAR(n) respectively is classified as

  1. ternary string
  2. binary string
  3. schema string
  4. character-string

D

MCQ. When schema is to be dropped in SQL which has no elements then type of DROP Command used is called

  1. SCALE DROP command
  2. PRECISION DROP command
  3. RESTRICT DROP schema
  4. CASCADE DROP command

C