The __________ sign allows for the substitution of zero or more characters in a field.

• A) Underscore (_)
• B) Asterisk (*)
• C) None of them
• D) Percentage (%)

SQL stands for _______________.

• A) Strict Query Language
• B) Struct Query Language
• C) Structured Query Language
• D) Structured Question Language

What does * means in the given SQL statement?
SELECT DISTINCT * ColumnName FROM TableName;

• A) All Columns
• B) One Row
• C) One Column
• D) All Rows

Which of the following clause is used to apply the condition on Selection from a table?

• A) Order By
• B) Select
• C) Group By
• D) Where

The SQL GROUP BY clause is used in collaboration with the _________ statement.

• A) UPDATE
• B) INSERT
• C) SELECT
• D) DELETE

In SQL which operator uses Wildcard characters?

• A) AND
• B) IN
• C) BETWEEN
• D) LIKE

Single row function accepts one or more argument(s) and returns _____________ value(s) for each row returned by the query.

• A) ONE
• B) FOUR
• C) THREE
• D) TWO

_______________ is used to extract unique values of column from the table.

• A) Unique
• B) Distinct
• C) Single
• D) *

Which wildcard character is used in SQL?

• A) #
• B) !
• C) %
• D) $

Having Clause places conditions on _________.

• A) Single Row
• B) Groups created by the GROUP BY clause
• C) Whole/Selected Column
• D) All Rows

The _____________ operator selects values within a specific range and the values could be numbers, text, or dates.

• A) IN
• B) LIKE
• C) ANY
• D) BETWEEN

________________ is used to undo the transactions which have not already been stored in the database.

• A) Commit
• B) Undo
• C) Rollback
• D) Truncate

_______________ clause is used in collaboration with the SELECT statement to arrange identical data into groups.

• A) Having
• B) Order by
• C) Group by
• D) Drop

_______________ is the correct syntax for SELECT statement.

• A) SELECT column_name(s) FROM table_name
• B) FROM table_name SELECT column_name(s)
• C) SELECT FROM table_name column_name(s)
• D) FROM SELECT column_name(s) table_name

Which is not related to SQL?

• A) Data Definition Language
• B) Data Translation Language
• C) Data Control Language
• D) Data Manipulation Language

What does DISTINCT means in the given SQL statement?
SELECT DISTINCT * ColumnName FROM TableName;

• A) Unique Values from Columns
• B) All Values from Columns
• C) Duplicate Values from Columns
• D) One Value from Columns

BETWEEN operator is used in _______________ clause.

• A) SELECT
• B) WHERE
• C) HAVING
• D) GROUP BY

Which logical operator will be used in where clause of SQL statement if you want to display the list of all employee names who are earning more than 2500 but less than 5000?

• A) OR
• B) AND
• C) XOR
• D) NOT

% wildcard means ____________.

• A) Exactly one character
• B) Zero characters
• C) More than zero characters
• D) Zero or more characters

Transaction is a unit of ____________ accomplished in a logical order against a database.

• A) Power
• B) Query
• C) Work
• D) Command