Group functions manipulate groups of rows to give ______ result per group of rows.

• A) Three
• B) Four
• C) Two
• D) One

______________ is a Multi Rows/Group function.

• A) INSTR
• B) ROUND
• C) CONCAT
• D) COUNT

What will be displayed after execution of following SQL command?
SELECT ename, job FROM emp;

• A) Whole table
• B) All values of ename and job columns from emp table
• C) Some of the values from ename and job columns of emp table
• D) All the unique values from enmae column of Emp table

________ is a Single Row function.

• A) MAX
• B) AVG
• C) ROUND
• D) MIN

“Where Clause” restricts ____________ returned as a result after execution of select command.

• A) Attributes
• B) Rows
• C) Tables
• D) Columns

_____________ is used to sort the result set in ascending or descending order.

• A) From Clause
• B) Where Clause
• C) Order by Clause
• D) Group by Clause

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