Online Access Free 1Z0-051 Practice Test

Which is an iSQL*Plus command?

• A.INSERT
• B.DESCRIBE
• C.SELECT
• D.DELETE
• E.RENAME
• F.UPDATE

Which statements are correct regarding indexes? (Choose all that apply.)

• A.A FOREIGN KEY constraint on a column in a table automatically creates a non unique key
• B.When a table is dropped, the corresponding indexes are automatically dropped
• C.A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index.
• D.For each data manipulation language (DML) operation performed, the corresponding indexes are automatically updated.

Which is a valid CREATE TABLE statement?

• A.CREATE TABLE EMP9$# AS (empid number(2));
• B.CREATE TABLE EMP*123 AS (empid number(2));
• C.CREATE TABLE PACKAGE AS (packid number(2));
• D.CREATE TABLE 1EMP_TEST AS (empid number(2));

Evaluate the following SQL statements: Exhibit:

Exhibit:

The above command fails when executed. What could be the reason?

• A.SYSDATE cannot be used with the CHECK constraint
• B.ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY
• C.The BETWEEN clause cannot be used for the CHECK constraint
• D.The CHECK constraint cannot be placed on columns having the DATE data type

Examine the structure of the SHIPMENTS table:

You want to generate a report that displays the PO_ID and the penalty amount to be paid if
the
SHIPMENT_DATE is later than one month from the PO_DATE. The penalty is $20 per day.
Evaluate the following two queries:

Which statement is true regarding the above commands?

• A.Both execute successfully and give correct results.
• B.Only the first query executes successfully and gives the correct result.
• C.Only the second query executes successfully but gives a wrong result.
• D.Only the first query executes successfully but gives a wrong result.
• E.Only the second query executes successfully and gives the correct result.