Oracle 1Z0-071 Quiz 53 Topic 15 Questions 261-265

Question: 1

View the exhibit and examine the ORDERS table.

q1_1Z0-071

The ORDERS table contains data and all orders have been assigned a customer ID. Which statement would add a NOT NULL constraint to the CUSTOMER_ID column?

AALTER TABLE ordersMODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

BALTER TABLE ordersADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

CALTER TABLE ordersMODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);

DALTER TABLE ordersADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;

Show Answer

Question: 2

Examine the structure of the INVOICE table.

q2_1Z0-071

Which two SQL statements would execute successfully? (Choose two.)

ASELECT inv_no,NVL2(inv_date,'Pending','Incomplete')FROM invoice;

BSELECT inv_no,NVL2(inv_amt,inv_date,'Not Available')FROM invoice;

CSELECT inv_no,NVL2(inv_date,sysdate-inv_date,sysdate)FROM invoice;

DSELECT inv_no,NVL2(inv_amt,inv_amt*.25,'Not Available')FROM invoice;

Show Answer

Question: 3

Which three statements are true about the ALTER TABLE....DROP COLUMN.... command? (Choose three.)

AA column can be dropped only if it does not contain any data.

BA column can be dropped only if another column exists in the table.

CA dropped column can be rolled back.

DThe column in a composite PRIMARY KEY with the CASCADE option can be dropped.

EA parent key column in the table cannot be dropped.

Show Answer

Question: 4

View the exhibit and examine the description of the PRODUCT_INFORMATION table.

q4_1Z0-071

Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL?

ASELECT COUNT (DISTINCT list_price)FROM product_informationWHERE list_price is NULL

BSELECT COUNT (NVL(list_price, 0))FROM product_informationWHERE list_price is NULL

CSELECT COUNT (list_price)FROM product_informationWHERE list_price i= NULL

DSELECT COUNT (list_price)FROM product_informationWHERE list_price is NULL

Show Answer

Question: 5

Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

Adisplaying a date in a nondefault format

Bfinding the number of characters in an expression

Csubstituting a character string in a text expression with a specified string

Dcombining more than two columns or expressions into a single column in the output

Show Answer

Oracle 1Z0-071 Quiz:53 Topic:15 Questions:261-265