The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
If you are going to use a combination of three or more AND and OR conditions, it is often easier to use the NOT and NOT IN operators.
The SQL keyword(s) ________ is used with wildcards.
The SQL keyword(s) ________ is used with wildcards.
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.
SQL is a data sublanguage.
SQL is a data sublanguage.
SUM, AVG, MIN, and MAX can only be used with numeric columns.
SUM, AVG, MIN, and MAX can only be used with numeric columns.
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
SQL is a programming language.
SQL is a programming language.
The Microsoft Access wildcards are ____ and ____ .
The Microsoft Access wildcards are ____ and ____ .
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
________ was adopted as a national standard by ANSI in 1992.
________ was adopted as a national standard by ANSI in 1992.
The SQL statement that queries or reads data from a table is ________ .
The SQL statement that queries or reads data from a table is ________ .
Indexes may be created or dropped at any time.
Indexes may be created or dropped at any time.
The SQL -92 wildcards are ____ and ____ .
The SQL -92 wildcards are ____ and ____ .
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Which of the following do you need to consider when you make a table in SQL?
Which of the following do you need to consider when you make a table in SQL?
Which of the following is the original purpose of SQL?
Which of the following is the original purpose of SQL?
SQL query and modification commands make up a(n) ________ .
SQL query and modification commands make up a(n) ________ .
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total.
Most companies keep at least two versions of any database they are using.
Most companies keep at least two versions of any database they are using.
A dynamic view is one whose contents materialize when referenced.
A dynamic view is one whose contents materialize when referenced.
The condition in a WHERE clause can refer to only one value.
The condition in a WHERE clause can refer to only one value.
A view is which of the following?
A view is which of the following?
The result of a SQL SELECT statement is a(n) ________ .
The result of a SQL SELECT statement is a(n) ________ .
SQL data definition commands make up a(n) ________ .
SQL data definition commands make up a(n) ________ .
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column.
The SQL WHERE clause:
The SQL WHERE clause:
The benefits of a standard relational language include which of the following?
The benefits of a standard relational language include which of the following?
The result of every SQL query is a table.
The result of every SQL query is a table.
The wildcard in a WHERE clause is useful when?
The wildcard in a WHERE clause is useful when?
ON UPDATE CASCADE ensures which of the following?
ON UPDATE CASCADE ensures which of the following?
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
SQL can be used to:
SQL can be used to:
To establish a range of values, < and > can be used.
To establish a range of values, < and > can be used.
To sort the results of a query use:
To sort the results of a query use:
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Which of the following is valid SQL for an Index?
Which of the following is valid SQL for an Index?
The command to remove rows from a table 'CUSTOMER' is:
The command to remove rows from a table 'CUSTOMER' is:
The HAVING clause does which of the following?
The HAVING clause does which of the following?
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
There is an equivalent join expression that can be substituted for all subquery expressions.
There is an equivalent join expression that can be substituted for all subquery expressions.
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Which one of the following sorts rows in SQL?
Which one of the following sorts rows in SQL?
The SQL keyword BETWEEN is used:
The SQL keyword BETWEEN is used:
Which of the following are the five built-in functions provided by SQL?
Which of the following are the five built-in functions provided by SQL?
-
-
-
-
Indexes can usually be created for both primary and secondary keys.
Indexes can usually be created for both primary and secondary keys.
The command to eliminate a table from a database is:
The command to eliminate a table from a database is:
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
A subquery in an SQL SELECT statement is enclosed in:
A subquery in an SQL SELECT statement is enclosed in:
To define what columns should be displayed in an SQL SELECT statement:
To define what columns should be displayed in an SQL SELECT statement:
A subquery in an SQL SELECT statement:
A subquery in an SQL SELECT statement:
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
Which of the following is the correct order of keywords for SQL SELECT statements?
Which of the following is the correct order of keywords for SQL SELECT statements?
ORDER BY can be combined with the SELECT statements.
ORDER BY can be combined with the SELECT statements.
You can add a row using SQL in a database with which of the following?
You can add a row using SQL in a database with which of the following?
