Oracle 1Z0-071 Quiz 82 Topic 4 Questions 406-410

Question: 1

View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERS tables.

q1_1Z0-071

You are asked to retrieve the ORDER_ID, product_ID, and total price (UNIT_PRICE multiplied by QUANTITY), where the total price is greater than 50,000.

You executed the following SQL statement:

SELECT prder_id, product_id, unit_price*quantity ''Total Price''

FROM order_items

WHERE unit_price*quantity > 50000

NATURAL JOIN orders;

Which statement is true regarding the execution of the statement?

AThe statement would execute and provide the desired result.

BThe statement would not execute because the ON keyword is missing in the NATURAL JOIN clause.

CThe statement would not execute because the WHERE clause is before the NATURAL JOIN clause.

DThe statement would not execute because the USING keyword is missing in the NATURAL JOIN clause.

Show Answer

Question: 2

Which two commands execute successfully?

*MANAGER is an existing role with no privileges or roles.

*EMP is an existing role containing the CREATE TABLE privilege.

*EMPLOYEES is an existing table in the HR schema.

AGRANT CREATE SEQUENCE TO manager, emp;

BGRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;

CGRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION;

DGRANT CREATE TABLE, emp TP manager;

EGRANT CREATE TABLE, SELECT ON hr.employees TO manager;

Show Answer

Question: 3

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

AThe output is sorted by the UNION ALL operator

BThe names of columns selected in each SELECT statement must be identical

CThe number of columns selected in each SELECT statement must be identical

DDuplicates are eliminated automatically by the UNION ALL operator

ENULLS are not ignored during duplicate checking

Show Answer

Question: 4

Which three privileges can be restricted to a subset of columns in a table? (Choose three.)

AALTER

BDELETE

CUPDATE

DSELECT

EINDEX

FREFERENCES

GINSERT

Show Answer

Question: 5

Which statement is true about Data Manipulation Language (DML)?

ADML automatically disables foreign ley constraints when modifying primary key values in the parent table.

BEach DML statement forms a transaction by default.

CA transaction can consist of one or more DML statements.

DDML disables foreign key constraints when deleting primary key values in the parent table, only when the ON DELETE CASCADE option is set for the foreign key constraint.

Show Answer

Oracle 1Z0-071 Quiz:82 Topic:4 Questions:406-410