Question

Choose the appropriate answer with respect to the following code snippet.

code snippet.
CREATE TABLE student(
name CHAR(30)
student_id INT,
gender CHAR(1),
PRIMARY KEY (student_id)
);

What is true about the following SQL statement?
SelecT * fROM student;

Options

• Displays contents of table ‘student’

• Displays column names and contents of table ‘student’

• Results in error as improper case has been used

• Displays only the column names of table ‘student’

Answer 1

Displays contents of table ‘student’

Explanation:

SQL keywords are generally case-insensitive, so SelecT * fROM student; is valid and displays all records and columns of the student table.