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.