Oracle.1Z0-051.175q(21)

OCP 11g 051题库

View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.

The ORD_NO column is PRIMARY KEY in the ORD table and the ORD_NO and ITEM_NO columns are

composite PRIMARY KEY in the ORD_ITEMS table.

Which two CREATE INDEX statements are valid? (Choose two.)

A. CREATE INDEX ord_idx1

ON ord(ord_no);

B. CREATE INDEX ord_idx2

ON ord_items(ord_no);

C. CREATE INDEX ord_idx3

ON ord_items(item_no);

D. CREATE INDEX ord_idx4

ON ord,ord_items(ord_no, ord_date,qty);

Answer: BC

QUESTION 48

Which two statements are true regarding indexes? (Choose two.)

A. They can be created on tables and clusters.

B. They can be created on tables and simple views.

C. You can create only one index by using the same columns.

D. You can create more than one index by using the same columns if you specify distinctly different combinations of the columns.

Answer: AD

QUESTION 49

The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS

table to the user HR.

Which statement would create a synonym ORD so that HR can execute the following query successfully?

SELECT * FROM ord;

A. CREATE SYNONYM ord FOR orders; This command is issued by OE.

B. CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE.

C. CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator.

D. CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator.