Additional Basic Operations MCQs & Quiz Online PDF Book Download

Additional basic operations multiple choice questions (MCQs), additional basic operations quiz answers to learn online CS courses for database management online classes. Introduction to sql MCQs, additional basic operations quiz questions and answers for online computer programming degree. Learn aggregate functions, nested subqueries, sql data definition, additional basic operations test prep for big data certification.

Learn introduction to sql MCQ: an identifier, that is used to rename a relation is referred to as a, with choices input variable, clone name, correlation name, and table alias for online computer programming degree. Practice merit scholarships assessment test, online learning additional basic operations quiz questions for competitive exams in computer science major .

MCQs on Additional Basic Operations PDF Book Download

MCQ: An identifier, that is used to rename a relation is referred to as a

  1. Input variable
  2. Clone name
  3. Correlation name
  4. Table alias

C

MCQ: For renaming attributes, as clause can appear in

  1. Select clause
  2. Where clause
  3. From clause
  4. Both A and C

D

MCQ: SQL provides a way of renaming attributes of a result relation, taking form

  1. old-name to new-name
  2. old-name as new-name
  3. ALTER old-name to new-name
  4. ALTER old-name at new-name

B

MCQ: Asterisk symbol ?*? is used to denote all attributes in a relation, and is used in

  1. Select clause
  2. Define clause
  3. From clause
  4. Where clause

A

MCQ: SQL expresses patterns by using operator

  1. Like
  2. AS
  3. "="
  4. %

A