SQL Operations Quiz

TEXT is not a valid data type

TEXT data type cannot take a length parameter

VARCHAR should be used instead of TEXT

200 is too large for TEXT

Incorrect syntax for CHECK constraint

Role is not a valid column name

Parentheses should be square brackets

No error

Semicolon after each column

Comma after the PRIMARY KEY definition

Closing parenthesis

Quotation marks around column names

Missing closing parenthesis

Incorrect date format

Mismatched quotation marks

Duplicate StaffID

FOREIGN KEY REFERENCES TableName(ColumnName)

FOREIGN KEY (ColumnName) REFERENCES TableName(ColumnName)

FOREIGN REFERENCES TableName(ColumnName)

KEY FOREIGN TableName(ColumnName)

MODIFY Student SET ParentsPhone = '09991234567' WHERE StudentID = 'S001';

ALTER TABLE Student SET ParentsPhone = '09991234567' WHERE StudentID = 'S001';

UPDATE Student SET ParentsPhone = '09991234567' WHERE StudentID = 'S001';

CHANGE Student SET ParentsPhone = '09991234567' WHERE StudentID = 'S001';

The database allows it silently

The system automatically merges records

A duplicate key error occurs

Nothing happens

It will delete related receipts

Foreign key violation may occur

The update always succeeds

It updates the Receipt table automatically

They are also deleted automatically

You get a foreign key constraint error

Receipts are archived

System ignores the deletion

UPDATE Course SET CourseDescription = CourseDetails;

ALTER TABLE Course RENAME CourseDescription TO CourseDetails;

ALTER TABLE Course CHANGE CourseDescription CourseDetails TEXT;

MODIFY TABLE Course CourseDescription AS CourseDetails;