Oracle
1Z0-061 · Question #18
You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each employee 2. Employee Name (character data type) that stores the employee name 3. Hire…
The correct answer is D. Option D. CLOB Character data (up to 4 GB) NUMBER [(p, s)] Number having precision p and scale s (Precision is the total number of decimal digits and scale is the number of digits to the right of the decimal point; precision can range from 1 to 38, and scale can range from ?4 to 127.)
Install and Administer Oracle RAC
Question
You need to create a table with the following column specifications: 1. Employee ID (numeric data type) for each employee 2. Employee Name (character data type) that stores the employee name 3. Hire date, which stores the date of joining the organization for each employee 4. Status (character data type), that contains the value 'active1 if no data is entered 5. Resume (character large object [CLOB] data type), which contains the resume submitted by the employee Which is the correct syntax to create this table?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
How the community answered
(55 responses)- A7% (4)
- B13% (7)
- C4% (2)
- D76% (42)
Explanation
CLOB Character data (up to 4 GB) NUMBER [(p, s)] Number having precision p and scale s (Precision is the total number of decimal digits and scale is the number of digits to the right of the decimal point; precision can range from 1 to 38, and scale can range from ?4 to 127.)
Topics
#CREATE TABLE#CLOB data type#DEFAULT values#column constraints
Community Discussion
No community discussion yet for this question.