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





Question ID 1712

Which two statements are true about constraints? (Choose two.)

Option A

A.    A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
 

Option B

B.    The NOT NULL constraint ensures that null values are not permitted for the column.
 

Option C

C.    The UNIQUE constraint does not permit a null value for the column.

 

Option D

D.    The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

Correct Answer A,B
Explanation


Question ID 1713

Examine the description of the EMPLOYEES table:
EMP_ID NUMBER(4) NOT NULL
LAST_NAME VARCHAR2(30) NOT NULL
FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2)
Which statement produces the number of different departments that have employees with last name Smith?
 

Option A

A.    SELECT COUNT(dept_id) FROM employees
WHERE last_name='Smith';
 

Option B

B.    SELECT COUNT(*) FROM employees
 

Option C

C.    SELECT UNIQUE(dept_id) FROM employees
WHERE last_name='Smith';
 

Option D

D.    SELECT DISTINCT(COUNT(dept_id)) FROM employees
WHERE last_name='Smith';
 

Correct Answer C
Explanation

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