nerdexam
Oracle

1Z0-047 · Question #42

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) which stores the employee name 3…

The correct answer is D. CREATE TABLE EMP_1. See the full explanation below for the reasoning.

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) which stores the employee name 3. Hire date, to store the date when the employee joined the organization 4. Status (character data type). It should contain the value if no data is entered. 5. Resume (character large object [CLOB] data type), which would contain the resume submitted by the employee Which is the correct syntax to create this table?

Options

  • ACREATE TABLE EMP_1
  • BCREATE TABLE 1_EMP
  • CCREATE TABLE 1_EMP
  • DCREATE TABLE EMP_1

How the community answered

(32 responses)
  • A
    13% (4)
  • B
    6% (2)
  • C
    3% (1)
  • D
    78% (25)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice