Question 1 of 25
Hints left: 3
Q1
The wildcard asterisk (*) is the SQL-92 standard for indicating "any sequence of characters."
Q2
The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.
Q3
The keyword LIKE can be used in a WHERE clause to refer to a range of values.
Q4
SQL is a data sublanguage.
Q5
Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.
Q6
SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN.
Q7
Data manipulation language (DML) commands are used to define a database, including creating, altering, and dropping tables and establishing constraints.
Q8
Indexes may be created or dropped at any time.
Q9
The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.
Q10
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Q11
The result of every SQL query is a table.
Q12
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.
Q13
Indexes can usually be created for both primary and secondary keys.
Q14
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
Q15
Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill.
Q16
COUNT(field_name) tallies only those rows that contain a value; it ignores all null values.
Q17
The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.
Q18
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.
Q19
Most companies keep at least two versions of any database they are using.
Q20
ORDER BY can be combined with the SELECT statements.
Q21
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.
Q22
To establish a range of values, < and > can be used.
Q23
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
Q24
SUM, AVG, MIN, and MAX can only be used with numeric columns.
Q25
Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.