Search Header Logo

Pretest

Authored by Palanichamy Palanichamy Naveen

Other

Professional Development

Used 1+ times

Pretest
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

11 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

What is a subquery?

A subquery is a select-from-where expression that is nested within another query

A subquery is any query that is nested within another query

A subquery is a relation that is externally specified which can be used to handle data in queries

A subquery is a condition that excludes all the invalid tuples from the database

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

  1. Before

  1. After

  1. Inside

  1. Outside

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

SELECT

  1. UPDATE

  1. INSERT

  1. All of the above

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

  1. Brackets, Left

  1. Brackets, Right

  1. Parenthesis, Left

  1. Parenthesis, Right

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

GROUP BY

  1. ORDER BY

  1. DELETE

  1. FROM

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

  1. Many Value Operators

  1. Multiple Value Operators

  1. Single Value Operator

  1. Unique Value Operator

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

  1. IN

INTO

BETWEEN

JOIN

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?