Test Index

Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

© examsnet.com

Question : 26 of 50

Marks: +1, -0

You must create a table for a banking application.

One of the columns in the table has these requirements:

1: A column to store the duration of a short team loan

2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions.

3: The maximum loan period is 30 days.

4: Interest must be calculated based on the number of days for which the loan remains unpaid.

Which data type would you use?

DATE
NUMBER
TIMESTAMP
INTERVAL DAY TO SECOND
INTERVAL YEAR TO MONTH

Go to Question:

Prev Question

Next Question