Examine these statements: Which two are true? (Choose two.)

Question

Exhibit

Options

• ABoth foreign key constraint definitions must be removed from the CREATE TABLE statements,
• BThe MGR column in the DEPT table will not be able to contain NULL values.
• CThe CREATE TABLE EMP statement must precede the CREATE TABLE DEPT statement for all
• DAll three statements execute successfully in the order shown.
• EThe DEPTNO column in the EMP table will be able to contain NULL values.
• FThe DEPT_FKEY constraint definition must be removed from the CREATE TABLE DEPT

• A
  82% (27)
• B
  3% (1)
• C
  9% (3)
• F
  6% (2)

No community discussion yet for this question.