READ Free Dumps For Oracle- 1z0-061

Question ID 2305	You issued the following command: SQL> DROP TABLE employees; Which three statements are true?
Option A	A.    All uncommitted transactions are committed.
Option B	B.    All indexes and constraints defined on the table being dropped are also dropped.
Option C	C.    Sequences used in the employees table become invalid.
Option D	D.    The space used by the employees table is reclaimed immediately.
Option E	E.    The employees table can be recovered using the rollback command.
Option F	F.    The employees table is moved to the recycle bin.
Correct Answer	B,C,F

Explanation

Question ID 2306	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?
Option A	A.    Disable the primary key in the STORES table.
Option B	B.    Use CASCADE keyword with DELETE statement.
Option C	C.    DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
Option D	D.    Disable the FOREIGN KEY in SALES table and then delete the rows.
Option E	E.    Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.
Correct Answer	A,C,D

Explanation

Previous-Page 1 2. . . 17 18 19 20 21 22 23. . . 58 59 Next-Page

Send email to admin@getfreedumps for new dumps request!!!