Oracle 1Z0-071 Quiz 8 Topic 10 Questions 36-40

Question: 1

The ORDERS table has a primary key constraint 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 CASCADE.

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

Which three DELETE statements execute successfully?

ADELETE order_id FROM orders WHERE order_total < 1000;

BDELETE FROM orders WHERE order_total < 1000;

CDELETE orders WHERE order_total < 1000;

DDELETE * FROM orders WHERE order_total < 1000;

EDELETE FROM orders;

Show Answer

Question: 2

Which three are true about the CREATE TABLE command? (Choose three.)

AIt can include the CREATE..INDEX statement for creating an index to enforce the primary key constraint

BIt implicitly executes a commit

CA user must have the CREATE ANY TABLE privilege to create tables

DIt implicitly rolls back any pending transactions

EThe owner of the table should have space quota available on the tablespace where the table is defined

FThe owner of the table must have the UNLIMITED TABLESPACE system privilege

Show Answer

Question: 3

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

ARead data from an external table and load it into a table in the database

BCreate a directory object for an external table

CExecute DML statements on an external table

DQuery data from an external table

ERead data from a table in the database and insert it into an external table

FCreate a directory object for a flat file

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

Examine these statements and the result:

CREATE SEQUENCE customer_seq CACHE 10;

SELECT customer_seq. NEXTVAL FROM DUAL; NEXTVAL

1

Now examine this command:

ALTER SEQUENCE customer_soq ;

What must replace missing clause for customer_seq. nfxtvai. to return 11?

Acycle 11

BNOCACHE

CSTART WITH 11

DMINVALUE 11

EINCREMENT BY 10

Show Answer

Oracle 1Z0-071 Quiz:8 Topic:10 Questions:36-40