You are designing the structure of a table in which two columns have the specifications:
C0MP0NENT_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?
A. The EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND datatype.
B. The EXECUTIONDATETIME must be of TIMESTAMP datatype.
C. The EXECUTION_DATETIME must be of DATE datatype.
D. TheCOMPONENT_ID must be of ROWID datatype.
E. TheCOMPONENT_ID must be of VARCHAR2 datatype.
F. The COMPONENT_ID column must be of CHAR data type.
tien sound the most legit to me. BE it is
BE
B:EXECUTION DATETIME –need to “comparisons between components”–so TIMESTAMP allow”fractional seconds”
sufficiently full fill this requirement
E:C0MP0NENT_ID – must be able to contain a maximum of 12 alphanumeric characters –the key word is maximum, so varchar2(12) is the answer for this purpose
BF
DATE and TIMESTAMP have the same size (7 bytes). Those bytes are used to store century, decade, year, month, day, hour, minute and seconds. But TIMESTAMP allows to store additional info such as fractional seconds
for char vs varchar read https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch6.htm
So its BF
CE
CE
CE