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-001





Question ID 1548

Evaluate this PL/SQL block:
BEGIN
FOR i IN 1..10 LOOP
IF i = 4 OR i = 6 THEN
null;
ELSE
INSERT INTO test(results)
VALUES (I);
END IF;
COMMIT;
END LOOP;
ROLLBACK;
END;
How many values will be inserted into the TEST table?
 

Option A

A.    4
 

Option B

B.    8
 

Option C

C.    0
 

Option D

D.    10
 

Correct Answer B
Explanation


Question ID 1549

You attempt to create the salary table with this command:

1.CREATE TABLE salary 2.(employee_idNUMBER(9) 3.CONSTRAINT salary_pk PRIMARY KEY, 4.1995_salaryNUMBER(8,2), 5.manager_nameVARCHAR2(25) 6.CONSTRAINT mgr_name_nn NOT NULL, 7.$salary_96NUMBER(8,2));
Which two lines of this statement will return errors? (Choose two.)
 

Option A

A.    4

 

Option B

B.    5
 

Option C

C.    7
 

Option D

D.    3
 

Option E

E.    2

Correct Answer A,C
Explanation

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