Database Quiz 4 SQL

SQL is a declarative programming language

• True

• False

The syntax for INSERT INTO statement is:

INSERT INTO table_name (column1, column2, …) (a)   (value1, value2, …)

Which statement involve syntax of SET?

(a)  

The syntax for a SELECT query in SQL is:

• SELECT table_names FROM field_name WHERE condition ORDER BY field_name

• SELECT field_names FROM table_name WHERE condition ORDER BY table_name

• SELECT table_names FROM field_name WHERE condition ORDER BY table_name

• SELECT field_names FROM table_name WHERE condition ORDER BY field_name

The query to print the complete table Student is: SELECT * FROM Student

• True

• False

The syntax for deleting a field using an ALTER TABLE statement is:

ALTER TABLE table_name

(a)   field_name

The ORDER BY clause by default orders in (a)   order.

Operator for Not equal to is:

(a)  

The syntax for modifying the data type of a field using an ALTER TABLE statement is:

ALTER TABLE table_name

(a)  

A (a)   symbol is used for field_names if all columns are to be displayed.