Introduction to SQL MCQ, Database Introduction to SQL Online Test

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

The command to remove rows from a table ‘CUSTOMER’ is:

The SQL WHERE clause:

Which of the following is the original purpose of SQL?

The wildcard in a WHERE clause is useful when?

A view is which of the following?

The command to eliminate a table from a database is:

ON UPDATE CASCADE ensures which of the following?

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

Which of the following is valid SQL for an Index?

The SQL keyword(s) ________ is used with wildcards.

Which of the following is the correct order of keywords for SQL SELECT statements?

A subquery in an SQL SELECT statement is enclosed in:

The result of a SQL SELECT statement is a(n) ________ .

Which of the following are the five built-in functions provided by SQL?

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

The HAVING clause does which of the following?

The SQL -92 wildcards are ____ and ____ .

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

The benefits of a standard relational language include which of the following?

Which of the following do you need to consider when you make a table in SQL?

SQL query and modification commands make up a(n) ________ .

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

The Microsoft Access wildcards are ____ and ____ .

Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = ‘VA’;

Which one of the following sorts rows in SQL?

To sort the results of a query use:

To define what columns should be displayed in an SQL SELECT statement:

SQL can be used to:

The SQL statement that queries or reads data from a table is ________ .