Which of the given SQL statements will be used to create a table Student having the following attributes, such that the table has a PRIMARY KEY constraint on the column StudentID and also has UNIQUE and NOT NULL constraints on both the columns Phone and City?
StudentlD int
StudentName nvarchar(60
City nvarchar(15)
Region nvarchar(15)
Country nvarchar(15)
Phone nvarchar(20)
Correct Answer:
CREATE TABLE Student (StudentlD int IDENTITY "PRIMARY KEY", StudentName nvarchar(60) NULL. City nvarchar (15) NOT NULL "UNIQUE". Region nvarchar (15) NULL. Country nvarchar (15) NULL.
Phone nvarchar (20) NOT NULL “UNIQUE");
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More Oracle 12c Admin MCQ Questions