SQL Data Definition MCQs Quiz Online PDF Book Download

Sql data definition multiple choice questions (MCQs), sql data definition quiz answers to learn online DBMS, DBA degree courses. Introduction to sql MCQs with answers, sql data definition quiz questions and answers for online schools for computer science degree. Learn aggregate functions, basic structure of sql queries, nested subqueries, modification of database, additional basic operations, sql data definition test prep for big data certification.

Learn introduction to sql test MCQs: command that is used to add attributes to an existing relation, is said to be, with choices alter, modify, tailor, and eliminate for online schools for computer science degree. Practice merit scholarships assessment test, online learning sql data definition quiz questions for competitive assessment in computer science major .

MCQ on SQL Data Definition Quiz Book Download

MCQ: Command that is used to add attributes to an existing relation, is said to be

  1. Alter
  2. Modify
  3. Tailor
  4. Eliminate

A

MCQ: Term that allows specification of not only a set of relations, but also information about each relation, is known as

  1. Data manipulation language
  2. Data Declaration language
  3. Data Declaration language
  4. Data Definition language

D

MCQ: When comparing a char type with a varchar type, one may expect extra spaces to be added to the

  1. char type
  2. varchar type
  3. Both A and B
  4. None of the above

B

MCQ: Any tuple in relation must correspond to values of primary key attributes of some tuple in relation s, is said to be

  1. Unique key attribute
  2. Primary key attribute
  3. Candidate key attribute
  4. Foreign key attribute

D

MCQ: All tuples in relation are assigned null as value for new attribute, in the

  1. Tailor command
  2. Eliminate command
  3. Alter command
  4. Modify command

C