34) In an SQL query, which SQL keyword is used to specify the table(s) to be used?A) EXISTSB) FROMC) SELECTD) SETE) WHERE

BDiff: 1 Page Ref: 36

35) In an SQL query, which SQL keyword must be used to remove duplicate rows from the result table?A) DELETEB) DISTINCTC) NOT EXISTSD) UNIQUEE) KEY

BDiff: 3 Page Ref: 37

36) In an SQL query, which of the following symbols is used by ANSI SQL to represent all the columns in a single table?A) _ (underscore)B) ? (question mark)C) * (asterisk)D) % (percent)E) # (pound)

CDiff: 2 Page Ref: 38

37) In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?A) EXISTSB) FROMC) SELECTD) SETE) WHERE

EDiff: 1 Page Ref: 36, 38

38) In an SQL query, which SQL keyword is used to join two conditions that both must be true for the rows to be selected?A) ANDB) EXISTSC) HAVINGD) INE) OR

ADiff: 1 Page Ref: 55

39) In an SQL query, which SQL keyword is used to determine if a column value is equal to any one of a set of values?A) ANDB) EXISTSC) HAVINGD) INE) OR

DDiff: 1 Page Ref: 55-56

40) In an SQL query, which of the following symbols is used by ANSI SQL to represent a single unspecified character?A) _ (underscore)B) ? (question mark)C) * (asterisk)D) % (percent)E) # (pound)

ADiff: 3 Page Ref: 57-59

41) In an SQL query, which of the following symbols is used by Microsoft Access to represent a single unspecified character?A) _ (underscore)B) ? (question mark)C) * (asterisk)D) % (percent)E) # (pound)

BDiff: 3 Page Ref: 57-59

42) In an SQL query, which SQL keyword is used to sort the result table by the values in one or more columns?A) GROUP BYB) ORDER BYC) SELECTD) SORT BYE) WHERE

BDiff: 2 Page Ref: 53

43) Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using standard SQL?A) SELECT *FROM EMPLOYEEWHERE Name IN ['S'];B) SELECT EmpNoFROM EMPLOYEEWHERE Name LIKE 'S';C) SELECT *FROM NameWHERE EMPLOYEE LIKE 'S*';D) SELECT *FROM EMPLOYEEWHERE Name LIKE 'S%';E) None of the above.

DDiff: 3 Page Ref: 55-59

44) Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following would find all employees whose name begins with the letter "S" using Microsoft Access?A) SELECT *FROM EMPLOYEEWHERE Name IN ['S'];B) SELECT EmpNoFROM EMPLOYEEWHERE Name LIKE 'S';C) SELECT *FROM NameWHERE EMPLOYEE LIKE 'S*';D) SELECT *FROM EMPLOYEEWHERE Name LIKE 'S%';E) None of the above.

CDiff: 3 Page Ref: 55-59

45) In an SQL query, which built-in function is used to total numeric columns?A) AVGB) COUNTC) MAXD) MEANE) SUM

EDiff: 1 Page Ref: 59-62

46) In an SQL query, which built-in function is used to compute the average value of numeric columns?A) AVGB) MEANC) MAXD) MINE) SUM

ADiff: 2 Page Ref: 59-62

47) In an SQL query, which built-in function is used to obtain the largest value of numeric columns?A) AVGB) COUNTC) MAXD) MINE) SUM

CDiff: 2 Page Ref: 59-62

48) In an SQL query, which built-in function is used to obtain the smallest value of numeric columns?A) AVGB) COUNTC) MAXD) MINE) SUM

DDiff: 2 Page Ref: 59-62

49) In an SQL query, the built-in functions SUM and AVG work with columns containing data of which of the following data types?A) IntegerB) NumericC) CharD) A and BE) A, B and C

DDiff: 3 Page Ref: 59-62

50) In an SQL query, which built-in function is used to compute the number of rows in a table?A) AVGB) COUNTC) MAXD) MINE) MEAN

BDiff: 1 Page Ref: 59-62

51) In an SQL query, the built-in function COUNT works with columns containing data of which of the following data types?A) IntegerB) NumericC) CharD) A and BE) A, B and C

EDiff: 3 Page Ref: 59-62

52) In an SQL query, which SQL keyword is used with built-in functions to group together rows that have the same value in a specified column?A) GROUP BYB) ORDER BYC) SELECTD) SORT BYE) DISTINCT SET

ADiff: 1 Page Ref: 64

53) In an SQL query, which SQL keyword is used with GROUP BY to select groups meeting specified criteria?A) ANDB) EXISTSC) HAVINGD) INE) WHERE

57) In an SQL query, which SQL keyword is used to implement a subquery?A) GROUP BYB) HAVINGC) ORDER BYD) SELECTE) SORT BY

DDiff: 3 Page Ref: 70-73

58) When one SQL query is embedded in the WHERE clause of another SQL query, this is referred to as a ________.A) subsetB) joinC) WHERE QueryD) subqueryE) set query

DDiff: 2 Page Ref: 70-73

59) In an SQL query, which SQL keyword is used to specify the names of tables to be joined?A) FROMB) HAVINGC) JOIND) SELECTE) WHERE

ADiff: 1 Page Ref: 73-76

60) Regarding the interchangeability of subqueries and joins,A) a join can always be used as an alternative to a subquery, and a subquery can always be used as an alternative to a join.B) a join can sometimes be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.C) a join can always be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.D) a join can sometimes be used as an alternative to a subquery, and a subquery can always be used as an alternative to a join.E) a join can never be used as an alternative to a subquery, and a subquery can never be used as an alternative to a join.

BDiff: 3 Page Ref: 76-77

61) SQL stands for ________.

Structured Query LanguageDiff: 1 Page Ref: 32

62) SQL includes a ________ language and a ________ language.

data definition; data manipulationDiff: 2 Page Ref: 36

63) SQL was developed by ________ in the late 1970s.

IBMDiff: 2 Page Ref: 35

64) The ________ maintains the standards for SQL.

American National Standards Institute (ANSI)Diff: 3 Page Ref: 35

65) SQL is not a complete programming language. Rather it is a(n) ________.

data sublanguageDiff: 2 Page Ref: 36

66) The SQL keyword ________ is used to specify the columns to be listed in the query results.

SELECTDiff: 2 Page Ref: 36

67) The SQL keyword ________ is used to specify the table(s) that contain(s) the data to be retrieved.

FROMDiff: 1 Page Ref: 36

68) To remove duplicate rows from the result of a query, specify the SQL qualifier ________.

DISTINCTDiff: 3 Page Ref: 37

69) To obtain all columns, use a(n) ________ instead of listing all the column names.

asterisk (*)Diff: 1 Page Ref: 38

70) The SQL ________ clause contains the condition that specifies which rows are to be selected.

WHEREDiff: 1 Page Ref: 36, 38

71) To sort the rows of the result table, the ________ clause is specified.

ORDER BYDiff: 2 Page Ref: 53

72) Columns can be sorted in descending sequence by using the SQL keyword ________.

DESCDiff: 2 Page Ref: 54

73) When two conditions must both be true for the rows to be selected, the conditions are separated by the SQL keyword ________.

ANDDiff: 1 Page Ref: 55

74) To refer to a set of values needed for a condition, use the SQL operator ________.

INDiff: 3 Page Ref: 55-56

75) To exclude one or more values using a condition, the SQL keyword ________ must be used.

NOT INDiff: 3 Page Ref: 55-56

76) To refer to a set of values in a condition, the values are placed inside ________ and separated by commas.

parenthesis ( )Diff: 3 Page Ref: 55-56

77) The SQL keyword ________ is used in SQL expressions to select on partial values.

LIKEDiff: 2 Page Ref: 57

78) The SQL-92 wildcard ________ indicates a sequence of one or more unspecified characters in an SQL query.

% (percent sign)Diff: 3 Page Ref: 57-59

79) The Microsoft Access-92 wildcard ________ indicates a sequence of one or more unspecified characters in an SQL query.