nerdexam
Oracle

1Z0-061 · Question #60

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table?

The correct answer is D. Option D E. Option E. See the full explanation below for the reasoning.

Question

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table?

Exhibit

1Z0-061 question #60 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D
  • EOption E
  • FOption F

How the community answered

(42 responses)
  • A
    2% (1)
  • B
    12% (5)
  • C
    5% (2)
  • D
    79% (33)
  • F
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice