ArcGIS - ESRI, GIS Test one, Geodesy - Week 4 - ESRI Online Course, Geospatial Test 1 and CORRECT Answer

ArcGIS - ESRI, GIS Test one, Geodesy -
Week 4 - ESRI Online Course, Geospatial
Test 1 and CORRECT Answers
1) SQL is a data sublanguage, not a complete programming language. - CORRECT
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. - CORRECT 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. - CORRECT 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. - CORRECT 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. - CORRECT 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. - CORRECT 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. - CORRECT 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. - CORRECT
ANSWER - Answer: TRUE

,9) Data is added to a table using the SQL INSERT command. - CORRECT ANSWER -
Answer: TRUE


10) The result for SELECT statements in SQL is a relation unless the result is a single number. -
CORRECT 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. - CORRECT ANSWER - Answer: TRUE


12) In SQL, the WHERE clause is used to specify which columns will be included in the result. -
CORRECT ANSWER - Answer: FALSE


13) In SQL, multiple conditions in the WHERE clause can be combined by using the SQL AND
keyword. - CORRECT ANSWER - Answer: TRUE


14) In SQL, to refer to a range of values in a WHERE clause, use the WITHIN keyword. -
CORRECT 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. - CORRECT ANSWER - Answer: TRUE


16) In SQL, the LIKE keyword can be used to select on partial values. - CORRECT
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. - CORRECT ANSWER - Answer: TRUE


18) In SQL, the IS NULL keyword can be used to select on records containing NULL values in a
particular column. - CORRECT 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. - CORRECT ANSWER - Answer: FALSE


20) The SUM built-in function in SQL is used to total the values in a numeric column. -
CORRECT ANSWER - Answer: TRUE


21) The TOP built-in function in SQL is used to find the maximum value in a numeric column. -
CORRECT ANSWER - Answer: FALSE


22) Standard SQL does not allow built-in functions to be used in a WHERE clause. - CORRECT
ANSWER - Answer: TRUE


23) The SQL GROUP BY keyword can be used to group rows by common values. - CORRECT
ANSWER - Answer: TRUE


24) Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword. -
CORRECT ANSWER - Answer: FALSE


25) Data from a maximum of three tables can be combined through the use of subqueries in
SQL. - CORRECT ANSWER - Answer: FALSE


26) A subquery is appropriate only if the final result contains only data from a single table. -
CORRECT ANSWER - Answer: TRUE


27) The basic idea of a join is to combine the contents of two or more relations into a new
relation. - CORRECT ANSWER - Answer: TRUE


28) Using standard SQL, unmatched rows will not appear in the result of a join. - CORRECT
ANSWER - Answer: TRUE

, 29) Values of existing data can be changed using SQL through the CHANGE command. -
CORRECT ANSWER - Answer: FALSE


30) The ON DELETE CASCADE referential integrity constraint does not apply when rows are
deleted using the SQL DELETE command. - CORRECT ANSWER - Answer: FALSE


31) Microsoft Access SQL commands are run within the SQL View of a Query window. -
CORRECT ANSWER - Answer: TRUE



32) Microsoft Access can run QBE queries, but not SQL queries. - CORRECT ANSWER -
Answer: FALSE


33) To open a new Microsoft Access Query window, click the Query Design button on the Create
command tab. - CORRECT ANSWER - Answer: TRUE


34) Microsoft Access SQL supports and will correctly implement the numeric data type with
(m,n) notation. - CORRECT ANSWER - Answer: FALSE


35) In Microsoft Access, default values must be set as a field property while the table is in
Design View. - CORRECT 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) - CORRECT ANSWER - Answer: B