web analytics

Update 1Z0-061 Dumps with VCE and PDF for Free (Question 29 – Question 32)

PassLeader now are offering 100% pass ensure 1Z0-061 dumps! All 1Z0-061 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-061 VCE dumps and PDF dumps: http://www.passleader.com/1z0-061.html (322 Q&As)

BTW: Download PassLeader 1Z0-061 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA

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

A.    All uncommitted transactions are committed.
B.    All indexes and constraints defined on the table being dropped are also dropped.
C.    Sequences used in the employees table become invalid.
D.    The space used by the employees table is reclaimed immediately.
E.    The employees table can be recovered using the rollback command.
F.    The employees table is moved to the recycle bin.

Answer: BCF
Explanation:
http://www.sqlcourse.com/drop.html

QUESTION 30
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?

A.    Disable the primary key in the STORES table.
B.    Use CASCADE keyword with DELETE statement.
C.    DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
D.    Disable the FOREIGN KEY in SALES table and then delete the rows.
E.    Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.

Answer: ACD

QUESTION 31
Examine the data in the CUST_NAME column of the customers table.
passleader-1Z0-061-dumps-311
You need to display customers’ second names where the second name starts with “Mc” or “MC”. Which query gives the required output?
passleader-1Z0-061-dumps-312

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: B

QUESTION 32
You want to create a sales table with the following column specifications and data types:
SALESID: Number
STOREID: Number
ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified
PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified
Which statement would create the table?
passleader-1Z0-061-dumps-321

A.    Option A
B.    Option B
C.    Option C
D.    Option D

Answer: D


PassLeader now are offering 100% pass ensure 1Z0-061 dumps! All 1Z0-061 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-061 VCE dumps and PDF dumps: http://www.passleader.com/1z0-061.html (322 Q&As)

BTW: Download PassLeader 1Z0-061 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpZ2pPVDVMSlJ6UjA