additional basic operations

mcqspedia.com has 5 Question/Answers about Topic additional basic operations

SQL expresses patterns by using operator

SQL expresses patterns by using operator
  • A. Like
  • B. AS
  • C. "="
  • D. %
  • Correct Answer: Option A

Asterisk symbol

Asterisk symbol
  • A. Select clause
  • B. Define clause
  • C. From clause
  • D. Where clause
  • Correct Answer: Option A

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

SQL provides a way of renaming attributes of a result relation, taking form
  • A. old-name to new-name
  • B. old-name as new-name
  • C. ALTER old-name to new-name
  • D. ALTER old-name at new-name
  • Correct Answer: Option B

For renaming attributes, as clause can appear in

For renaming attributes, as clause can appear in
  • A. Select clause
  • B. Where clause
  • C. From clause
  • D. Both A and C
  • Correct Answer: Option D

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

An identifier, that is used to rename a relation is referred to as a
  • A. Input variable
  • B. Clone name
  • C. Correlation name
  • D. Table alias
  • Correct Answer: Option C