ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

87 / 120

Question 87:

You execute the SQL statement: 
image
What is the outcome? 

Answer options:

A. It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.
B. It succeeds and CITY can contain only "˜SEATTLE` or null for all rows.
C. It fails because the condition for the CNAMES constraint is not valid.
D. It succeeds and an index is created for CITIZEN_ID.