SQL Data Definition MCQs & Quiz Online PDF eBook Download

Sql data definition multiple choice questions (MCQs), sql data definition quiz answers to learn databases for online computer science degree programs. Introduction to sql MCQs, sql data definition quiz questions and answers for computer science programs. Learn aggregate functions, basic structure of sql queries, nested subqueries, modification of database, additional basic operations, sql data definition test prep for computer software engineer.

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

MCQs on SQL Data Definition PDF eBook 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