ESRI EXAM QUESTIONS AND ANSWERS
1) SQL is a data sublanguage, not a complete programming language. - Answer-
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- Answer: FALSE
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- 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- Answer: TRUE
5) For a column to be defined as the primary key using table constraints, the column
must have been given the property NULL. - Answer- Answer: FALSE
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-
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- Answer: TRUE
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- Answer: TRUE
9) Data is added to a table using the SQL INSERT command. - Answer- Answer: TRUE
10) The result for SELECT statements in SQL is a relation unless the result is a single
number. - Answer- Answer: FALSE
11) To force the DBMS to remove duplicate rows from the results of an SQL SELECT
query, the keyword DISTINCT must be used. - Answer- Answer: TRUE
12) In SQL, the WHERE clause is used to specify which columns will be included in the
result. - Answer- Answer: FALSE
13) In SQL, multiple conditions in the WHERE clause can be combined by using the
SQL AND keyword. - Answer- Answer: TRUE
14) In SQL, to refer to a range of values in a WHERE clause, use the WITHIN keyword.
- Answer- Answer: FALSE
,15) In SQL, the NOT keyword can be combined with the IN keyword to form the NOT IN
condition for selecting values. - Answer- Answer: TRUE
16) In SQL, the LIKE keyword can be used to select on partial values. - Answer-
Answer: TRUE
17) In SQL, the LIKE keyword can be combined with the NOT keyword to form the NOT
LIKE condition for selecting values. - Answer- Answer: TRUE
18) In SQL, the IS NULL keyword can be used to select on records containing NULL
values in a particular column. - Answer- Answer: TRUE
19) In SQL, the order of the rows that result from a SELECT statement can be set using
the SORT BY phrase. - Answer- Answer: FALSE
20) The SUM built-in function in SQL is used to total the values in a numeric column. -
Answer- Answer: TRUE
21) The TOP built-in function in SQL is used to find the maximum value in a numeric
column. - Answer- Answer: FALSE
22) Standard SQL does not allow built-in functions to be used in a WHERE clause. -
Answer- Answer: TRUE
23) The SQL GROUP BY keyword can be used to group rows by common values. -
Answer- Answer: TRUE
24) Built-in SQL functions cannot be applied to data combined using the GROUP BY
keyword. - Answer- Answer: FALSE
25) Data from a maximum of three tables can be combined through the use of
subqueries in SQL. - Answer- Answer: FALSE
26) A subquery is appropriate only if the final result contains only data from a single
table. - Answer- Answer: TRUE
27) The basic idea of a join is to combine the contents of two or more relations into a
new relation. - Answer- Answer: TRUE
28) Using standard SQL, unmatched rows will not appear in the result of a join. -
Answer- Answer: TRUE
29) Values of existing data can be changed using SQL through the CHANGE command.
- Answer- Answer: FALSE
,30) The ON DELETE CASCADE referential integrity constraint does not apply when
rows are deleted using the SQL DELETE command. - Answer- Answer: FALSE
31) Microsoft Access SQL commands are run within the SQL View of a Query window. -
Answer- Answer: TRUE
32) Microsoft Access can run QBE queries, but not SQL queries. - Answer- Answer:
FALSE
33) To open a new Microsoft Access Query window, click the Query Design button on
the Create command tab. - Answer- Answer: TRUE
34) Microsoft Access SQL supports and will correctly implement the numeric data type
with (m,n) notation. - Answer- Answer: FALSE
35) In Microsoft Access, default values must be set as a field property while the table is
in Design View. - Answer- 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- Answer: B
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- Answer: C
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- Answer: A
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-
Answer: C
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- Answer: C
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- 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- Answer: B
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- Answer: C
44) Which SQL keyword is used to eliminate duplicate rows in the results of an SQL
SELECT query?
