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- 1z1-051





Question ID 4952

Which four are types of functions available in SQL? (Choose 4)
 

Option A

A.    string
 

Option B

B.    character
 

Option C

C.    integer

 

Option D

D.     date

Option E

E.    numeric
 

Option F

F.    conversion

Correct Answer B,D,E,F
Explanation


Question ID 4953

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2(30)
JOB_ID NUMBER\
SAL NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of theDEPARTMENTS table
You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table.
Which two statements regarding the EMP_ID_SEQ sequence are true? (Choose two.)
 

Option A

A.    You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
 

Option B

B.    The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
 

Option C

C.    The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
 

Option D

D.    Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
 

Option E

E.    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
 

Option F

F.    The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
 

Correct Answer C,D
Explanation

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