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, …) _____ (value1, value2, …)

Which statement involve syntax of SET?

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

________ field_name

The ORDER BY clause by default orders in _____ order.

Operator for Not equal to is:

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

ALTER TABLE table_name

________________

A ___ symbol is used for field_names if all columns are to be displayed.