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 uniquely identify the row EXECUTION_DATETIME - contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components. Which two options define the data types that satisfy these requirements most efficiently?

Question

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 uniquely identify the row EXECUTION_DATETIME - contains Century, Year, Month, Day, Hour, Minute, Second to the maximum precision and is used for calculations and comparisons between components. Which two options define the data types that satisfy these requirements most efficiently?

Accepted Answer

C. The EXECUTION_DATATIME must be of DATE data type. E. The COMPONENT_ID must be of VARCHAR2 data type.

Answer

A. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.

Answer

B. The EXECUTION _DATETIME must be of TIMESTAMP data type.

Answer

D. The COMPONENT_ID must be of ROWID data type.

Answer

F. The COMPONENT_ID column must be of CHAR data type.

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 uniquely identify the row…

Question

Options

How the community answered

Community Discussion