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





Question ID 2271

Examine the structure proposed for the transactions table:
 
 
Which two statements are true regarding the creation and storage of data in the above table structure?

Option A

A.    The CUST_STATUS column would give an error.
 

Option B

B.    The TRANS_VALIDITY column would give an error.
 

Option C

C.    The CUST_STATUS column would store exactly one character.
 

Option D

D.    The CUST_CREDIT_LIMIT column would not be able to store decimal values.

 

Option E

E.    The TRANS VALIDITY column would have a maximum size of one character.

Correct Answer B,C
Explanation


Question ID 2272

You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit period.
 
2)    The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.
3)    The maximum period of the credit provision in the application is 30 days.
4)    The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?
 

Option A

A.    DATE
 

Option B

B.    NUMBER
 

Option C

C.    TIMESTAMP
 

Option D

D.    INTERVAL DAY TO SECOND

 

Option E

E.    INTERVAL YEAR TO MONTH

Correct Answer D
Explanation

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