SQL

0 Minutes

1 Questions

Example Question:

Multiple-Choice

What SQL operator will create table PERSON with primary key, unique person's name, value of sex (male - 'M' or female - 'F') and person's birthday?

Answers

1. CREATE TABLE PERSON ( PERSON_ID INT PRIMARY KEY , PERSON_NAME CHAR(100) UNIQUE , SEX CHAR(1) IN ('M', 'F') , BIRTHDAY DATE )

2. CREATE TABLE PERSON ( PERSON_ID INT PRIMARY KEY , PERSON_NAME CHAR(100) UNIQUE , SEX CHAR(1) CHECK (SEX IN ('M', 'F')) , BIRTHDAY DATE )

3. CREATE TABLE PERSON ( PRIMARY KEY PERSON_ID , UNIQUE PERSON_NAME CHAR(100) , SEX CHAR(1) CHECK (SEX IN ('M', 'F')) , BIRTHDAY DATE )