Additional Basic Operations MCQs Test Online PDF Download

Additional basic operations multiple choice questions (MCQs), additional basic operations test prep to learn online IT degree courses. Learn introduction to sql multiple choice questions (MCQs), additional basic operations quiz questions and answers. Career test prep on set operations, additional basic operations, aggregate functions, nested subqueries aptitude test for online SQL database tools courses distance learning.

Practice introduction to sql aptitude test MCQs: for renaming attributes, as clause can appear in, for free online computer science courses with options select clause, where clause, from clause, both a and c for online computer science degree. Free skills assessment test is for online learning additional basic operations quiz questions with MCQs, exam preparation questions and answers.

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