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 2277

View the Exhibit and evaluate the structure and data in the CUST_STATUS table.
 
You issue the following SQL statement:
 
Which statement is true regarding the execution of the above query?

Option A

A.    It produces an error because the AMT_SPENT column contains a null value.
 

Option B

B.    It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
 

Option C

C.    It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.
 

Option D

D.    It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.
 

Correct Answer C
Description
Update Date and Time 2016-01-05 15:38:58

Question ID 2278

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

Option A

A.    First normal form
 

Option B

B.    Second normal form
 

Option C

C.    Third normal form

 

Option D

D.    Fourth normal form

Correct Answer B
Description
Update Date and Time 2016-01-05 15:40:01