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