Section 1
Preview this deck
23) The SQL GROUP BY keyword can be used to group rows by common values.
Front
| 5 | 0 | ||
| 4 | 0 | ||
| 3 | 0 | ||
| 2 | 0 | ||
| 1 | 0 |
Active users
0
All-time users
0
Favorites
0
Last updated
6 years ago
Date created
Mar 1, 2020
Cards (85)
Section 1
(50 cards)
23) The SQL GROUP BY keyword can be used to group rows by common values.
Answer: TRUE
34) Microsoft Access SQL supports and will correctly implement the numeric data type with (m,n) notation.
Answer: FALSE
49) Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspecified characters? A) % (percent sign) B) ! (exclamation mark) C) _ (underscore) D) ? (question mark) E) ; (semi-colon)
Answer: A
48) Which symbol is used in standard SQL as a wildcard to represent a single, unspecified character? A) % (percent sign) B) ! (exclamation mark) C) _ (underscore) D) ? (question mark) E) ; (semi-colon)
Answer: C
8) Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.
Answer: TRUE
41) Which of the following cannot be done using the CONSTRAINT phrase? A) Create a single attribute primary key. B) Define a foreign key. C) Establish a referential integrity constraint. D) All of the above can be done using the CONSTRAINT phrase. E) None of the above can be done using the CONSTRAINT phrase.
Answer: D
42) Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table? A) INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith'; B) INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith'); C) INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith'); D) INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith'; E) INPUT INTO STUDENT (123, 'Jones', 'Smith');
Answer: B
17) In SQL, the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.
Answer: TRUE
24) Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.
Answer: FALSE
4) When using SQL to create a table, specifying a data type of Char(10) indicates a fixed length field of 10 characters.
Answer: TRUE
35) In Microsoft Access, default values must be set as a field property while the table is in Design View.
Answer: TRUE
40) A composite primary key can be defined using the CONSTRAINT phrase in which SQL command? A) MODIFY TABLE B) CHANGE TABLE C) CREATE TABLE D) SET TABLE E) BUILD TABLE
Answer: C
6) If you need to create a primary key that is a composite key using SQL, the key may be defined when the table is created using the CREATE TABLE statement.
Answer: TRUE
1) SQL is a data sublanguage, not a complete programming language.
Answer: TRUE
2) When using SQL to create a table, a column is defined by declaring, in this order: data type, column name, and optional constraints.
Answer: FALSE
16) In SQL, the LIKE keyword can be used to select on partial values.
Answer: TRUE
11) To force the DBMS to remove duplicate rows from the results of an SQL SELECT query, the keyword DISTINCT must be used.
Answer: TRUE
20) The SUM built-in function in SQL is used to total the values in a numeric column.
Answer: TRUE
10) The result for SELECT statements in SQL is a relation unless the result is a single number.
Answer: FALSE
5) For a column to be defined as the primary key using table constraints, the column must have been given the property NULL.
Answer: FALSE
47) Which of the following is the correct SQL clause to restrict the results of a SELECT query to only records that have a value in the range of 10 to 50 in the Hours column? A) WHERE Hours = MIN(10) and MAX(50) B) WHERE Hours IN [10, 50] C) WHERE Hours = 10 and Hours = 50 D) WHERE Hours BETWEEN 10 AND 50 E) WHERE Hours RANGE 10 TO 50
Answer: D
14) In SQL, to refer to a range of values in a WHERE clause, use the WITHIN keyword.
Answer: FALSE
26) A subquery is appropriate only if the final result contains only data from a single table.
Answer: TRUE
44) Which SQL keyword is used to eliminate duplicate rows in the results of an SQL SELECT query? A) UNIQUE B) SORT C) ORDER BY D) DISTINCT E) REDUCE
Answer: D
29) Values of existing data can be changed using SQL through the CHANGE command.
Answer: FALSE
28) Using standard SQL, unmatched rows will not appear in the result of a join.
Answer: TRUE
21) The TOP built-in function in SQL is used to find the maximum value in a numeric column.
Answer: FALSE
43) The order of the columns returned by an SQL SELECT statement is determined by the: A) ORDER BY clause. B) SORT BY clause. C) order they are listed in following SELECT. D) order they are listed in following WHERE. E) order they are listed in following FROM.
Answer: C
32) Microsoft Access can run QBE queries, but not SQL queries.
Answer: FALSE
38) Which of the following is not a standard data type used in SQL? A) Text B) Char C) Varchar D) Integer E) Numeric
Answer: A
18) In SQL, the IS NULL keyword can be used to select on records containing NULL values in a particular column.
Answer: TRUE
9) Data is added to a table using the SQL INSERT command.
Answer: TRUE
22) Standard SQL does not allow built-in functions to be used in a WHERE clause.
Answer: TRUE
7) Referential integrity constraints can be created using the ON DELETE phrase when the table is created using the CREATE TABLE statement.
Answer: TRUE
37) Which of the following data types used in SQL would define a numeric field of the pattern 99.99? A) integer(2,2) B) integer(5,2) C) numeric(2,2) D) numeric(4,2) E) numeric(5,2)
Answer: C
19) In SQL, the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.
Answer: FALSE
13) In SQL, multiple conditions in the WHERE clause can be combined by using the SQL AND keyword.
Answer: TRUE
30) The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.
Answer: FALSE
46) Conditions after the WHERE keyword require single quotes around the values for columns that have which data type? A) Char B) VarChar C) Integer D) Numeric E) Both A and B
Answer: E
3) When using SQL to create a table, specifying the NULL property for a column indicates that only null values may be stored in that column.
Answer: FALSE
12) In SQL, the WHERE clause is used to specify which columns will be included in the result.
Answer: FALSE
45) Which SQL keyword is used to specify a condition that rows must meet to be included in the results of an SQL SELECT query? A) SELECT B) FROM C) WHERE D) ORDER BY E) GROUP BY
Answer: C
33) To open a new Microsoft Access Query window, click the Query Design button on the Create command tab.
Answer: TRUE
36) Which of the following data types used in SQL would define a fixed-length text field of 10 characters? A) text(10) B) char(10) C) varchar(10) D) fixed(10) E) length(10)
Answer: B
25) Data from a maximum of three tables can be combined through the use of subqueries in SQL.
Answer: FALSE
39) Which of the following is not true about primary keys? A) Primary keys cannot be null. B) Primary keys must be unique. C) Primary keys must be a single attribute. D) Primary keys are used to represent relationships. E) Primary keys can be defined using an SQL CONSTRAINT phrase.
Answer: C
27) The basic idea of a join is to combine the contents of two or more relations into a new relation.
Answer: TRUE
15) In SQL, the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.
Answer: TRUE
31) Microsoft Access SQL commands are run within the SQL View of a Query window.
Answer: TRUE
50) Which SQL keyword can be used in conjunction with wildcards to select partial values? A) SELECT B) SEARCH C) FIND D) SUBSTRING E) LIKE
Answer: E
Section 2
(35 cards)