Similar Collections

    No collections found

questions

Title
A Sub query is an SQL expression that is placed ________ another SQL statement

A Sub query is an SQL expression that is placed ________ another SQL statement.

  1. Before
  2. After
  3. Inside
  4. Outside
discuss
With which of the following statement(s) can the SQL sub queries be used?

With which of the following statement(s) can the SQL sub queries be used?

  1. SELECT
  2. UPDATE
  3. INSERT
  4. All of the above
discuss
Whenever a sub query appears in SQL, it is enclosed within ___________ and placed to the _____ of the SQL operators

Whenever a sub query appears in SQL, it is enclosed within ___________ and placed to the _____ of the SQL operators.

  1. Brackets, Left
  2. Brackets, Right
  3. Parenthesis, Left
  4. Parenthesis, Right
discuss
Which of the following clause cannot be used in SQL sub queries?

Which of the following clause cannot be used in SQL sub queries?

  1. GROUP BY
  2. ORDER BY
  3. DELETE
  4. FROM
discuss
In order to prevent multiple records from being returned by the sub query, _______ must be used before the sub query

In order to prevent multiple records from being returned by the sub query, _______ must be used before the sub query.

  1. Many Value Operators
  2. Multiple Value Operators
  3. Single Value Operator
  4. Unique Value Operator
discuss
The _________ operator cannot be used with the sub query, but within it

The _________ operator cannot be used with the sub query, but within it.

  1. IN
  2. INTO
  3. BETWEEN
  4. JOIN
discuss
An SQL ____ is a virtual table, whose contents are based on the SQL statement's results

An SQL ____ is a virtual table, whose contents are based on the SQL statement's results.

  1. Concatenate
  2. Virtual
  3. View
  4. None of the above
discuss
We can create View in SQL using –

We can create View in SQL using –

  1. CREATE statement
  2. CREATE VIEW statement
  3. VIEW CREATE statement
  4. SQL VIEW statement
discuss
What is TRUE about UPDATE in SQL VIEW?

What is TRUE about UPDATE in SQL VIEW?

  1. Views that depend on a single table can be updated.
  2. An update of a view created from more than one table will not be allowed by SQL.
  3. There should be no NULL values in the fields of view.
  4. All of the above
discuss
When SELECT statements used to create Views contain ______________ clauses, the views cannot be updated

When SELECT statements used to create Views contain ______________ clauses, the views cannot be updated.

  1. JOIN
  2. HAVING
  3. GROUP BY
  4. All of the above
discuss
total MCQs: 10

MCQs

10

Views

74

Best Answers

299

Points

5