Oracle 1Z0-071 Quiz 63 Topic 12 Questions 311-315

Question: 1

You issued the following command:

SQL> DROP TABLE employees;

Which three statements are true?

AAll uncommitted transactions are committed.

BAll indexes and constraints defined on the table being dropped are also dropped.

CSequences used in the employees table become invalid.

DThe space used by the employees table is reclaimed immediately.

EThe employees table can be recovered using the rollback command.

FThe employees table is moved to the recycle bin

Show Answer

Question: 2

Examine the create table statements for the stores and sales tables.

SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_address VARCHAR2(20), start_date DATE);

SQL> CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id));

You executed the following statement:

SQL> DELETE from stores

WHERE store_id=900;

The statement fails due to the integrity constraint error:

ORA-02292: integrity constraint (HR.STORE_ID_FK) violated

Which three options ensure that the statement will execute successfully?

ADisable the primary key in the STORES table.

BUse CASCADE keyword with DELETE statement.

CDELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.

DDisable the FOREIGN KEY in SALES table and then delete the rows.

ECreate the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.

Show Answer

Question: 3

n the customers table, the CUST_CITY column contains the value 'Paris' for the

CUST_FIRST_NAME 'Abigail'.

Evaluate the following query:

q3_1Z0-071

What would be the outcome?

AAbigail PA

BAbigail Pa

CAbigail IS

DAn error message

Show Answer

Question: 4

Which two statements are true regarding constraints?

AA table can have only one primary key and one foreign key.

BA table can have only one primary key but multiple foreign keys.

COnly the primary key can be defined at the column and table levels.

DThe foreign key and parent table primary key must have the same name.

EBoth primary key and foreign key constraints can be defined at both column and table levels.

Show Answer

Question: 5

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:

$> sqlldr hr/hr@pdb table=employees

Which two statements are true regarding the command?

AIt succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

BIt fails because no SQL *Loader data file location is specified.

CIt fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

DIt fails because no SQL *Loader control file location is specified.

Show Answer

Oracle 1Z0-071 Quiz:63 Topic:12 Questions:311-315