SQL Basics Quiz

You can add a row using SQL in a database with which of the following?

• ADD

• CREATE

• INSERT

• MAKE

The command to remove rows from a table 'CUSTOMER' is:

• REMOVE FROM CUSTOMER ...

• DROP FROM CUSTOMER ...

• DELETE FROM CUSTOMER WHERE ...

• UPDATE FROM CUSTOMER …

The SQL WHERE clause:

• limits the column data that are returned.

• limits the row data are returned.

• Both A and B are correct.

• Neither A nor B are correct.

Which of the following is the original purpose of SQL?

• To specify the syntax and semantics of SQL data definition language

• To specify the syntax and semantics of SQL manipulation language

• To define the data structures

• All of the above.

The wildcard in a WHERE clause is useful when?

• An exact match is necessary in a SELECT statement.

• An exact match is not possible in a SELECT statement.

• An exact match is necessary in a CREATE statement.

• An exact match is not possible in a CREATE statement.

A view is which of the following?

• A virtual table that can be accessed via SQL commands

• A virtual table that cannot be accessed via SQL commands

• A base table that can be accessed via SQL commands

• A base table that cannot be accessed via SQL commands

The command to eliminate a table from a database is:

• REMOVE TABLE CUSTOMER;

• DROP TABLE CUSTOMER;

• DELETE TABLE CUSTOMER;

• UPDATE TABLE CUSTOMER;

ON UPDATE CASCADE ensures which of the following?

• Normalization

• Data Integrity

• Materialized Views

• All of the above.

SQL data definition commands make up a(n) ________ .

• DDL

• DML

• HTML

• XML

Which of the following is valid SQL for an Index?

• CREATE INDEX ID;

• CHANGE INDEX ID;

• ADD INDEX ID;

• REMOVE INDEX ID;