AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-061





Question ID 21030

You issued the following command:
SQL> DROP TABLE employees;
Which three statements are true?

Option A

All uncommitted transactions are committed.

Option B

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

Option C

Sequences used in the employees table become invalid.

Option D

The space used by the employees table is reclaimed immediately.

Option E

The employees table can be recovered using the rollback command.

Option F

The employees table is moved to the recycle bin.

Correct Answer B,C,F
Explanation Reference: http://www.sqlcourse.com/drop.html


Question ID 21031

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

Disable the primary key in the STORES table.

Option B

Use CASCADE keyword with DELETE statement.

Option C

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

Option D

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

Option E

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

Correct Answer A,C,D
Explanation

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