basic structure of sql queries

mcqspedia.com has 5 Question/Answers about Topic basic structure of sql queries

Basic structure of an SQL query consists of clauses of type

Basic structure of an SQL query consists of clauses of type
  • A. 2 types
  • B. 3 types
  • C. 4 types
  • D. 5 types
  • Correct Answer: Option B

Result relation has all attributes from all relations in the

Result relation has all attributes from all relations in the
  • A. Select clause
  • B. IN clause
  • C. From clause
  • D. Define clause
  • Correct Answer: Option C

Since duplicate retention is default, we shall not use

Since duplicate retention is default, we shall not use
  • A. Distinct
  • B. All
  • C. Describe
  • D. Whole
  • Correct Answer: Option B

Query for finding department names of all instructors, is

Query for finding department names of all instructors, is
  • A. select dept_name about instructor;
  • B. define dept_name from instructor;
  • C. select dept_name from instructor;
  • D. define dept_name about instructor;
  • Correct Answer: Option C

For understanding of operations, clauses must be written in order

For understanding of operations, clauses must be written in order
  • A. Select, where, from
  • B. From, select, where
  • C. Select, from, where
  • D. From, where, select
  • Correct Answer: Option C