Oracle 1Z0-071 Quiz 11 Topic 17 Questions 51-55

Question: 1

The ORDERS table a primary key constrain on the ORDER_ID column.

The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing the primary key of the ORDERS table.

The constraint is defined with ON DELETE CASCADS.

There are rows in the ORDERS table with an ORDER_TOTAL of less than 1000.

Which three DELETE statements execute successfully?

ADELETE * FROM orders WHERE order_total < 1000;

BDELETE FROM orders;

CDELETE order_id FROM orders WHERE order_total < 1000;

DDELETE orders WHERE order_total < 1000;

EDELETE FROM orders WHERE order_total < 1000;

Show Answer

Question: 2

View the Exhibits and examine the structure of the costs and promotions tables.

You want to display prod_ids whose promotion cost is less than the highest cost PR0D_ID in a promotion time interval.

Examine this SQL statement:

q2_1Z0-071

What will be the result?

AIt gives an error because the ROUP BY clause is not valid.

BIt executes successfully and gives the required result.

CIt gives an error because the all keyword is not valid.

DIt executes successfully but does not give the required result.

Show Answer

Question: 3

View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks require subqueries?

q3_1Z0-071

ADisplay the number of products whose PROD_LIST_PRlCE is more than the average prod_list_price.

BDisplay the total number of products supplied by supplier 102 which have a product status of obsolete.

CDisplay the minimum prod_list_price for each product status.

DDisplay products whose prod_min_PRICE is more than the average PROD_LIST_PRlCE of all products, and whose status is orderable.

EDisplay suppliers whose PR0D_LIST_PRICE is less than 1000.

Show Answer

Question: 4

Examine the structure of the two tables.

q4_1Z0-071

Which two queries execute successfully? (Choose two.)

q4_1Z0-071

AOption A

BOption B

COption C

DOption D

EOption E

Show Answer

Question: 5

Which three actions can you perform on an existing table containing data? (Choose three.)

AAdd a new NOT NULL column with a DEFAULT value

BChange the default value of a column

CChange a DATE column containing data to a NUMBER data type

DAdd a new column as the table's first column

EDefine a default value that is automatically inserted into a column containing nulls

FIncrease the width of a numeric column

Show Answer

Oracle 1Z0-071 Quiz:11 Topic:17 Questions:51-55