READ Free Dumps For Oracle- 1z0-061

Question ID 21002	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	DATE
Option B	NUMBER
Option C	TIMESTAMP
Option D	INTERVAL DAY TO SECOND
Option E	INTERVAL YEAR TO MONTH
Correct Answer	D

Explanation

Question ID 21003	Which three tasks can be performed using SQL functions built into Oracle Database?
Option A	Displaying a date in a nondefault format
Option B	Finding the number of characters in an expression
Option C	Substituting a character string in a text expression with a specified string
Option D	Combining more than two columns or expressions into a single column in the output
Correct Answer	A,B,C

Explanation

Previous-Page 1 2. . . 33 34 35 36 37 38 39. . . 58 59 Next-Page

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