Test Index

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

© examsnet.com

Question : 28

Total: 50

You are designing the structure of a table in which two columns have the specifications:
COMPONENT_ID – must be able to contain a maximum of 12 alphanumeric characters and must uniquely identify the row
EXECUTION_DATETIME – contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisonsbetween components.
Which two options define the data types that satisfy these requirements most efficiently? (Choose two.)

The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type
The EXECUTION_DATETIME must be of TIMESTAMP data type.
The EXECUTION_DATETIME must be of DATE data type.
The COMPONENT_ID must be of ROWID data type
The COMPONENT_ID must be of VARCHAR2 data type
The COMPONENT_ID column must be of CHAR data type.

Go to Question:

Prev Question

Next Question