Oracle
1Z0-071 · Question #13
1Z0-071 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
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?
Options
- AThe EXECUTION_DATETIME must be of INTERVAL DAY TO SECOND data type.
- BThe EXECUTION _DATETIME must be of TIMESTAMP data type.
- CThe EXECUTION_DATATIME must be of DATE data type.
- DThe COMPONENT_ID must be of ROWID data type.
- EThe COMPONENT_ID must be of VARCHAR2 data type.
- FThe COMPONENT_ID column must be of CHAR data type.
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.