And queries are displayed and processed using html
Using MIS, 7e (Kroenke)
Chapter 5 Database Processing5.1 True/False Questions
3) A database is a self-describing collection of integrated records.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 26) Special data that describes the structure of a database is called metadata.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 2
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 29) Metadata refers to entities of a database that users want to process.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 312) A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.
14) To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 317) One of the functions of a DBMS is to provide tools to assist in the administration of a database.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 3
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
Course LO: Discuss best practices for using and managing databases Chapter LO: 320) Managing the impact of database structure changes on applications and users is an operational task for a database administrator.
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
Course LO: Discuss best practices for using and managing databases Chapter LO: 423) Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations.
25) Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 428) Locking must be used to coordinate the activities of users in order to prevent the lost-update problem.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 4
5
31) Developers generally construct a logical representation of database data, called a data model, after building a database.
Answer: FALSE
AACSB: Information Technology
Difficulty: Moderate
Course LO: Discuss best practices for using and managing databases Chapter LO: 534) Attributes are used to describe characteristics of entities.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 5
6
39) The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship.
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 542) The small oval on a line in an E-R diagram means that the relationship must have an entity of that type.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 5
Answer: TRUE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 645) The general goal of normalization is to construct tables such that every table has a single topic or theme.
Answer: TRUE
AACSB: Information Technology
Difficulty: Moderate
Course LO: Discuss best practices for using and managing databases Chapter LO: 648) The accuracy of a database design is independent of the corresponding data model.
50) The easiest time to change the database structure is after the data modeling stage.
Answer: FALSE
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 7
9
5.2 Multiple-Choice Questions
3) In a database, ________ are grouped into columns.
A) fields
B) records
C) bytes
D) files
Answer: C
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 2
A) records
B) tables
C) files
D) fields
Answer: A
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 26) The tables that appear in a database are known as ________.
A) group of rows that are formed to identify a unique table or file B) column or group of columns that identifies a unique row in a table C) character or byte that represents fields or columns
D) group of tables or files formed to identify a unique field or row Answer: B
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 2
11
11) Relational databases represent relationships using ________.
A) foreign keys
B) file systems
C) metadata
D) unique identifiers
Answer: A
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 2
A) operating system
B) DBMS
C) information system
D) data mart
Answer: B
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 314) Which of the following is an example of a database management system?
A) It is offered by Oracle.
B) It is license-free for most applications.
17) When you modify or delete data present in a database, you are ________.
A) creating a new database
B) forming a data model
C) simplifying the data structure
D) processing the database
Answer: D
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 320) Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system.
A) development
B) adaptation
C) backup and recovery
D) operation
Answer: A
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 3
A) monitoring backup procedures
B) conducting training for users
C) monitoring database performance
D) managing configuration changes in systems
Answer: D
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 323) A ________ is a collection of forms, reports, queries, and programs that serves as an intermediary between users and database data.
25) A(n) ________ is a request for data from a database.
A) form
B) report
C) query
D) application
Answer: C
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 4B) They use JavaScript for user-side processing.
C) The Internet is used to access the DBMS server computer.
C) They are written in object-oriented languages such as C++ and VisualBasic.
D) They are thin-client applications that need not be pre-installed on the users' computers.
30) Browser applications are thin-client applications that ________.
A) mostly display static content
B) are processed using VisualBasic and C++
C) need not be pre-installed on the users' computers
D) depend on internal networks and not the Internet to transmit data Answer: C
AACSB: Information Technology
Difficulty: Moderate
Course LO: Discuss best practices for using and managing databases Chapter LO: 4
17
33) Browser-based applications ________.
A) data aggregator
B) query model
C) data model
D) data application
Answer: C
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 536) An administrator should create a ________ before developing a database design.
38) In a data model, a(n) ________ is something that a user wants to track.
A) record
B) byte
C) entity
D) primary key
Answer: C
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 5
19
41) Each entity in a database has a unique attribute called a(n) ________.
A) identifiers
B) foreign keys
C) crow's feet
D) entities
Answer: C
AACSB: Information Technology
Difficulty: Easy
Course LO: Discuss best practices for using and managing databases Chapter LO: 544) Which of the following is true of N:M relationships?
Answer: D
AACSB: Information Technology
Difficulty: Moderate
Course LO: Discuss best practices for using and managing databases Chapter LO: 5
20
