Oracle SQL Test 1

Question 1

Keywords can't be split across lines or truncated.

Accepted Answer

True

Answer

False

Question 2

Which clause limits the query to rows that fulfill a set of criteria?

Accepted Answer

Where

Answer

Order by

Answer

Distinct

Answer

Describe

Question 3

Which of the following statements concerning Column Alias is incorrect?

Accepted Answer

Is Oracle vendor specific

Answer

Is useful with calculations

Answer

Renames a column heading

Answer

Requires double quotation marks if it contains spaces or special characters or if it is case-sensitive

Question 4

Which of the following statements about subquery operators is correct?

Accepted Answer

The <ANY operator means less than the maximum.

Answer

The NOT IN operator is equivalent to IS NULL.

Answer

The IN operator cannot be used in single-row subqueries

Answer

=ANY and =ALL operators have the same functionality.

Question 5

The columns to be shown are identified by_______, while the table containing columns is identified by _______ .

Accepted Answer

From and select

Answer

From and table

Answer

Where and select

Answer

Select from

Question 6

Grant and Revoke commands are _____

Accepted Answer

Data control language (DCL)

Answer

Transaction control

Answer

Data definition language (DDL)

Answer

Data manipulation language (DML)

Question 7

Except for the following priority areas, Oracle Database 11g has a lot of features.

Accepted Answer

High availability

Answer

Search Option

Answer

Manageability

Answer

Security

Question 8

Except for the following, the relational model consists of:

Accepted Answer

Coding java with Oracle easily

Answer

Data integrity for accuracy and consistency

Answer

Set of operators to act on the relations

Answer

Collection of objects or relations

Question 9

A unique identifier for each row of data in a table is:

Accepted Answer

Primary key

Answer

Foreign keys

Answer

Universal key

Answer

Unique key