ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

46 / 120

Question 46:

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

Answer options:

A. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.
B. The EXECUTION_DATETIME must be of TIMESTAMP data type.
C. The EXECUTION_DATETIME must be of DATE data type.
D. The COMPONENT_ID must be of ROWID data type.
E. The COMPONENT_ID must be of VARCHAR2 data type.
F. The COMPONENT_ID column must be of CHAR data type.