Question 1 :
The condition in a WHERE clause can refer to only one value.
Question 2 :
The ADD command is used to enter one row of data or to add multiple rows as a result of a query.
Question 3 :
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.
Question 4 :
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.
Question 5 :
A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.
Question 6 :
The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.
Question 7 :
There is an equivalent join expression that can be substituted for all subquery expressions.
Question 8 :
A dynamic view is one whose contents materialize when referenced.
Question 9 :
SQL is a programming language.
Question 10 :
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
Question 11 :
Indexes can usually be created for both primary and secondary keys.
Question 12 :
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
Question 13 :
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Question 14 :
SQL is a data sublanguage.
Question 15 :
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
Question 16 :
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
Question 17 :
The result of every SQL query is a table.
Question 18 :
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
Question 19 :
SUM, AVG, MIN, and MAX can only be used with numeric columns.
Question 20 :
Most companies keep at least two versions of any database they are using.
Question 21 :
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
Question 22 :
Indexes may be created or dropped at any time.
Question 23 :
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.
Question 24 :
ORDER BY can be combined with the SELECT statements.
Question 25 :
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
Question 26 :
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.
Question 27 :
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Question 28 :
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.
Question 29 :
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Question 30 :
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Question 31 :
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
Question 32 :
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
Question 33 :
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
Question 34 :
To establish a range of values, < and > can be used.
Question 35 :
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.