Questions For All Exams ExamPot


Computer SQL

Which one of the following sorts rows in SQL?

Computer SQL

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

Computer SQL

The Microsoft Access wildcards are ____ and ____ .

Computer SQL

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

Computer SQL

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

Computer SQL

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

Computer SQL

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

Computer SQL

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

Computer SQL

The SQL -92 wildcards are ____ and ____ .

Computer SQL

The HAVING clause does which of the following?

Computer SQL

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

Computer SQL

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

Computer SQL

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

Computer SQL

A subquery in an SQL SELECT statement is enclosed in:

Computer SQL

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

Computer SQL

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

Computer SQL

Which of the following is valid SQL for an Index?

Computer SQL

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

Computer SQL

ON UPDATE CASCADE ensures which of the following?

Computer SQL

The command to eliminate a table from a database is: