A subquery in an SQL SELECT statement:
A subquery in an SQL SELECT statement:
Which of the following is valid SQL for an Index?
Which of the following is valid SQL for an Index?
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.
SQL is a data sublanguage.
SQL is a data sublanguage.
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.
The SQL WHERE clause:
The SQL WHERE clause:
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.
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 SQL keyword(s) ________ is used with wildcards.
The SQL keyword(s) ________ is used with wildcards.
SQL query and modification commands make up a(n) ________ .
SQL query and modification commands make up a(n) ________ .
A subquery in an SQL SELECT statement is enclosed in:
A subquery in an SQL SELECT statement is enclosed in:
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.
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.
The SQL -92 wildcards are ____ and ____ .
The SQL -92 wildcards are ____ and ____ .
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?
The SQL keyword BETWEEN is used:
The SQL keyword BETWEEN is used:
The benefits of a standard relational language include which of the following?
The benefits of a standard relational language include which of the following?
SUM, AVG, MIN, and MAX can only be used with numeric columns.
SUM, AVG, MIN, and MAX can only be used with numeric columns.
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 result of a SQL SELECT statement is a(n) ________ .
The result of a SQL SELECT statement is a(n) ________ .
Which one of the following sorts rows in SQL?
Which one of the following sorts rows in SQL?
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.
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 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 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?
ORDER BY can be combined with the SELECT statements.
ORDER BY can be combined with the SELECT statements.
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.
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."
The command to eliminate a table from a database is:
The command to eliminate a table from a database is:
The result of every SQL query is a table.
The result of every SQL query is a table.
The Microsoft Access wildcards are ____ and ____ .
The Microsoft Access wildcards are ____ and ____ .
________ was adopted as a national standard by ANSI in 1992.
________ was adopted as a national standard by ANSI in 1992.
Indexes may be created or dropped at any time.
Indexes may be created or dropped at any time.
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?
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.
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 command to remove rows from a table 'CUSTOMER' is:
The command to remove rows from a table 'CUSTOMER' is:
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.
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.
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):
SQL can be used to:
SQL can be used to:
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.
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.
The condition in a WHERE clause can refer to only one value.
The condition in a WHERE clause can refer to only one value.
ON UPDATE CASCADE ensures which of the following?
ON UPDATE CASCADE ensures which of the following?
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.
To establish a range of values, < and > can be used.
To establish a range of values, < and > can be used.
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.
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.
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
To sort the results of a query use:
To sort the results of a query use:
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.
The HAVING clause does which of the following?
The HAVING clause does which of the following?
A view is which of the following?
A view is which of the following?
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.
Which of the following is the original purpose of SQL?
Which of the following is the original purpose of SQL?
The wildcard in a WHERE clause is useful when?
The wildcard in a WHERE clause is useful when?
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.
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.
SQL is a programming language.
SQL is a programming language.
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.
To define what columns should be displayed in an SQL SELECT statement:
To define what columns should be displayed in an SQL SELECT statement:
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.
The SQL statement that queries or reads data from a table is ________ .
The SQL statement that queries or reads data from a table is ________ .
SQL data definition commands make up a(n) ________ .
SQL data definition commands make up a(n) ________ .
A dynamic view is one whose contents materialize when referenced.
A dynamic view is one whose contents materialize when referenced.
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.
