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,


DOWNLOAD & READ Free Dumps For Oracle- 1z0-061



You are reading online questions and answers for Oracle Exam 1z0-061 (Oracle Database 12c SQL Fundamentals ) 100% free... Please share this site which will help this community to grow...

Question ID 2329

Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null?

Option A

A.    Option A
 

Option B

B.    Option B
 

Option C

C.    Option C
 

Option D

D.    Option D
 

Correct Answer A
Description
Update Date and Time 2016-01-06 18:32:36

Question ID 2330

Which two statements are true regarding single row functions?

Option A

A.    MOD: returns the quotient of a division
 

Option B

B.    TRUNC: can be used with number and date values
 

Option C

C.    CONCAT: can be used to combine any number of values
 

Option D

D.    SYSDATE: returns the database server current date and time
 

Option E

E.    INSTR: can be used to find only the first occurrence of a character in a string

 

Option F

F.    TRIM: can be used to remove all the occurrences of a character from a string

Correct Answer B,D
Description
Update Date and Time 2016-01-06 18:33:19