Additional Basic Operations MCQs Quiz Online PDF Download

Learn additional basic operations MCQs, database management system test for online learning courses, test prep to practice test. Introduction to sql quiz has multiple choice questions (MCQ), additional basic operations quiz questions and answers, set operations, aggregate functions, additional basic operations tutorials for online SQL database tools courses distance learning.

Database management system practice test 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 with online tutorial questions for online entrance exam with old papers' important questions. Free study guide is for online learning additional basic operations quiz with MCQs to practice test questions with answers.

MCQs 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