Answer: D
Diff: 3 Page Ref: 20
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
42) Microsoft SQL Server is an example of a ________.
A) database
B) database management system
C) data manipulation system
D) table
E) list manager
Answer: B
Diff: 1 Page Ref: 25
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
43) Microsoft Access is a personal database system, and a personal database system is characterized by ________.
A) the DBMS removing the metadata from the database
B) the DBMS product taking the role of the DBMS and the database application generator
C) the database being stored inside the DBMS
D) the DBMS product being limited to a maximum of ten tables in any given database
E) the DBMS not supporting indexes
Answer: B
Diff: 1 Page Ref: 23
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
44) The Microsoft Access application generator is not responsible for ________.
A) creating forms
B) creating reports
C) creating queries
D) creating tables
E) storing queries
Answer: D
Diff: 3 Page Ref: 32
AACSB: Information Technology
Chapter Obj.: Learn the purpose of a database management system (DBMS)
Classification: Concept
45) Today almost every commercial database is based on ________.
A) lists
B) the hierarchical model
C) the linked-list model
D) the relational model
E) the object-oriented model
Answer: D
Diff: 1 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
Classification: Concept
46) A relational database stores data in the form of ________.
A) lists
B) forms
C) columns
D) tables
E) spreadsheets
Answer: D
Diff: 1 Page Ref: 10
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
Classification: Concept
47) SQL stands for ________.
A) Standard Query Language
B) Structural Question Language
C) Structured Query Language
D) Standard Question Language
E) Structured Question Language
Answer: C
Diff: 1 Page Ref: 16
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
Classification: Concept
48) The statement
SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of ________.
A) QBE
B) SQL
C) QLE
D) C++
E) Java
Answer: B
Diff: 2 Page Ref: 17
AACSB: Information Technology
Chapter Obj.: Understand how using related tables helps you avoid the problems of using lists
Classification: Concept
49) Which of the following is a function of the database application in a database system?
A) Process user queries
B) Update database data
C) Maintain database structures
D) Create tables
E) Backup and restore data
Answer: A
Diff: 2 Page Ref: 21
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
50) Which of the following is not a function of the database application in a database system?
A) Execute application logic
B) Control concurrency
C) Create and process forms
D) Process user queries
E) Create and process reports
Answer: B
Diff: 3 Page Ref: 21
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application
Classification: Concept
51) Microsoft Access 2019 database files are stored using the file extension ________.
A) .adb
B) .asp
C) .accdb
D) .mdb
E) .sql
Answer: C
Diff: 2 Page Ref: 34
AACSB: Information Technology
Chapter Obj.: Understand the functions of a database application