49) Microsoft Access SQL commands are run within the SQL View of a Query window.
50) Microsoft Access can run QBE queries, but not SQL queries.
51) To open a new Microsoft Access Query window, click the Query Design button on the
Create command tab.
52) Microsoft Access SQL supports and will correctly implement the numeric data type with
(m,n) notation.
53) In Microsoft Access, default values must be set as a field property while the table is in
Design View.
54) 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)
55) 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)
56) Which of the following is not a standard data type used in SQL?
A) Text
B) Char
C) Varchar
D) Integer
E) Numeric
57) 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.
58) 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
59) 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) Define an attribute to be NOT NULL.
E) Defining a name for the constraint.
60) Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL
statements would be used to change the value of the Advisor field to ‘Smith’ for all rows in the
STUDENT table?
A) UPDATE STUDENT SET Advisor = ‘Smith’;
B) MODIFY STUDENT SET Advisor = ‘Smith’;
C) MODIFY Advisor SET STUDENT = ‘Smith’;
D) UPDATE Advisor = ‘Smith’;
E) SET STUDENT Advisor = ‘Smith’;
61) Which of the following standard SQL data types is not supported in Microsoft Access SQL?
A) Integer
B) Char(25)
C) VarChar(35)
D) Numeric(5,3)
E) DateTime
62) In Microsoft Access, standard SQL table creation syntax items not supported by Access SQL
can generally be implemented by ________.
A) setting the Data Types in Access table Design View
B) setting the field properties in Access table Design View
C) setting the relationship properties in the Edit Relationship dialog box
D) setting the referential integrity properties in the Edit Relationship dialog box
E) running an ALTER TABLE query in Access SQL
63) SQL stands for ________.
64) SQL is not a complete programming language, but is rather a(n) ________.
65) SQL was developed by ________ in the late 1970s.
66) The SQL keyword(s) ________ mean(s) that a value must be supplied before a new row can
be created.
67) An SQL data type of ________ would indicate a variable-length character string with
maximum length 75.
68) An SQL data type of ________ means that values consist of seven decimal numbers with
two numbers assumed to the right of the decimal point.
69) Microsoft Access SQL commands are run in the ________ of a Query window.
70) In Microsoft Access, the default method of creating and running a query is ________.
71) In Microsoft Access, tables are added to a QBE Query window by selecting the tables from
the ________ dialog box.
72) Table and relationship properties not supported by Microsoft Access SQL can usually be set
73) Explain why it is important to learn SQL.
74) Explain the essential format of the CREATE TABLE statement.
75) Discuss SQL data types.
76) Distinguish between Char and VarChar data types.
77) Explain two methods for defining a primary key using SQL.
78) Explain how to run an SQL query in Microsoft Access.
79) Values of existing data can be changed using SQL through the CHANGE command.
80) The ON DELETE CASCADE referential integrity constraint does not apply when rows are
deleted using the SQL DELETE command.
81) Which of the following SQL commands would be used to remove only the data from a table
named STUDENT while leaving the table structure intact?
A) DROP TABLE STUDENT;
B) DELETE TABLE STUDENT;
C) REMOVE TABLE STUDENT;
D) SELECT * FROM STUDENT THEN DROP;
E) DELETE FROM STUDENT;
82) The values of existing data can be modified using the SQL ________ command, which can
be used to change several column values at once.
83) The values of existing data can be removed from a table using the SQL ________ command,
which can even be used to remove all the data in the table at one time.
84) Which of the following SQL commands would be used to remove both the data and the table
structure of a table named STUDENT?
A) DROP TABLE STUDENT;
B) DELETE TABLE STUDENT;
C) REMOVE TABLE STUDENT;
D) SELECT * FROM STUDENT THEN DROP;
E) DELETE FROM STUDENT;
85) Existing tables in a database can be structurally modified by using the SQL ________
command.
86) A complete table, including both the table structure and any data in the table, can be removed
from the database by using the SQL ________ command.
87) Microsoft Access SQL allows table structures to be modified by using the standard SQL
________ command.
88) The ________ statement removes all data from a table while leaving the table structure, and
also resets any surrogate primary key values back to the starting point.
89) The basic idea of a join is to combine the contents of two or more relations into a new
relation.
90) Using standard SQL, unmatched rows will not appear in the result of a join.
91) Given the tables
STUDENT(StudentID, StudentName, AdvisorID)
ADVISOR(AdvisorID, AdvisorName, Office, Phone)
which of the following SQL statements would be used to implant a join between the two tables?
A) WHERE STUDENT MATCH ADVISOR
B) WHERE STUDENT.AdvisorID MATCH ADVISOR.AdvisorID
C) WHERE STUDENT = ADVISOR
D) WHERE STUDENT JOIN ADVISOR
E) WHERE STUDENT JOIN ADVISOR ON STUDENT.AdvisorID = ADVISOR.AdvisorID
92) Which type of join, although not included in standard SQL, was created to allow unmatched
rows to appear in the result of a join operation?
A) ODD JOIN
B) OPEN JOIN
C) OUTER JOIN
D) INNER JOIN
E) COMBINE JOIN
93) Using SQL commands, multiple tables can be queried using either subqueries or ________.
94) Using SQL commands, multiple tables can be queried so that all the values from one table
appear in the results, regardless of whether they have one or more corresponding values in the
other table, by using the SQL ________ command.
95) Data from a maximum of three tables can be combined through the use of subqueries in
SQL.
96) A subquery is appropriate only if the final result contains only data from a single table.
97) Compare and contrast subqueries and joins.