MCQs > IT & Programming > Oracle 12c Admin > Which 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?

Oracle 12c Admin MCQs

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)


Answer

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

Oracle 12c Admin Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

Oracle 12c Admin Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it