Additional Basic Operations MCQs & Quiz Online PDF Book Download

Additional basic operations MCQs, additional basic operations quiz answers to learn data analytics courses online. Introduction to sql multiple choice questions (MCQs), additional basic operations quiz questions and answers for online computer science bachelors degree. Aggregate functions, nested subqueries, sql data definition, additional basic operations test prep for big data certification.

Learn introduction to sql test MCQs: 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 science bachelors degree. Practice assessment test for scholarships, online learning additional basic operations quiz questions for competitive assessment in computer science major for big data certification.

MCQ on Additional Basic Operations Quiz 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