AIS Test 2 Exam UPDATED QUESTIONS
AND CORRECT ANSWERS
1) Using a file-oriented approach to data and information, data is maintained in
A) a centralized database.
B) many interconnected files.
C) many separate files.
D) a decentralized database. - CORRECT ANSWER C
2) In a well-structured relational database,
A) every table must be related to at least one other table.
B) every table must be related to all other tables.
C) one table must be related to at least one other table.
D) one table must be related to all other tables. - CORRECT ANSWER A
3) File-oriented approaches create problems for organizations because of
A) multiple transaction files.
B) a lack of sophisticated file maintenance software.
C) multiple users.
D) multiple master files. - CORRECT ANSWER D
4) Which statement is true regarding file systems?
A) Transaction files are similar to ledgers in a manual AIS.
B) Multiple master files create problems with data consistency.
C) Transaction files are permanent.
D) Individual records are never deleted in a master file. - CORRECT ANSWER B
5) The ________ acts as an interface between the database and the various application
programs.
,A) data warehouse
B) database administrator
C) database management system
D) database system - CORRECT ANSWER C
6) The combination of the database, the DBMS, and the application programs that access the
database through the DBMS is referred to as the
A) data warehouse.
B) database administrator.
C) database system.
D) database manager. - CORRECT ANSWER C
7) The person responsible for the database is the
A) data coordinator.
B) database administrator.
C) database manager.
D) database master. - CORRECT ANSWER B
8) All of the following are benefits of the database approach except:
A) Data integration and sharing
B) Decentralized management of data
C) Minimal data redundancy
D) Cross-functional analysis and reporting - CORRECT ANSWER B
9) The physical view of a database system refers to
A) how a user or programmer conceptually organizes and understands the data.
B) how the DBMS accesses data for a certain application program.
C) how and where the data are physically arranged and stored.
, D) how master files store data values used by more than one application program. -
CORRECT ANSWER C
10) The ________ handles the link between the way data are physically stored and each
user's logical view of that data.
A) data warehouse
B) data dictionary
C) database management (DBMS) software
D) schema - CORRECT ANSWER C
11) The logical structure of a database is described by the
A) data dictionary.
B) schema.
C) database management system.
D) internal level. - CORRECT ANSWER B
12) The schema that provides an organization-wide view of the entire database is known as
the
A) external-level schema.
B) internal-level schema.
C) conceptual-level schema.
D) logical view of the database - CORRECT ANSWER C
13) A set of individual user views of the database is called the
A) conceptual-level schema.
B) internal-level schema.
C) external-level schema.
D) meta-schema. - CORRECT ANSWER C
AND CORRECT ANSWERS
1) Using a file-oriented approach to data and information, data is maintained in
A) a centralized database.
B) many interconnected files.
C) many separate files.
D) a decentralized database. - CORRECT ANSWER C
2) In a well-structured relational database,
A) every table must be related to at least one other table.
B) every table must be related to all other tables.
C) one table must be related to at least one other table.
D) one table must be related to all other tables. - CORRECT ANSWER A
3) File-oriented approaches create problems for organizations because of
A) multiple transaction files.
B) a lack of sophisticated file maintenance software.
C) multiple users.
D) multiple master files. - CORRECT ANSWER D
4) Which statement is true regarding file systems?
A) Transaction files are similar to ledgers in a manual AIS.
B) Multiple master files create problems with data consistency.
C) Transaction files are permanent.
D) Individual records are never deleted in a master file. - CORRECT ANSWER B
5) The ________ acts as an interface between the database and the various application
programs.
,A) data warehouse
B) database administrator
C) database management system
D) database system - CORRECT ANSWER C
6) The combination of the database, the DBMS, and the application programs that access the
database through the DBMS is referred to as the
A) data warehouse.
B) database administrator.
C) database system.
D) database manager. - CORRECT ANSWER C
7) The person responsible for the database is the
A) data coordinator.
B) database administrator.
C) database manager.
D) database master. - CORRECT ANSWER B
8) All of the following are benefits of the database approach except:
A) Data integration and sharing
B) Decentralized management of data
C) Minimal data redundancy
D) Cross-functional analysis and reporting - CORRECT ANSWER B
9) The physical view of a database system refers to
A) how a user or programmer conceptually organizes and understands the data.
B) how the DBMS accesses data for a certain application program.
C) how and where the data are physically arranged and stored.
, D) how master files store data values used by more than one application program. -
CORRECT ANSWER C
10) The ________ handles the link between the way data are physically stored and each
user's logical view of that data.
A) data warehouse
B) data dictionary
C) database management (DBMS) software
D) schema - CORRECT ANSWER C
11) The logical structure of a database is described by the
A) data dictionary.
B) schema.
C) database management system.
D) internal level. - CORRECT ANSWER B
12) The schema that provides an organization-wide view of the entire database is known as
the
A) external-level schema.
B) internal-level schema.
C) conceptual-level schema.
D) logical view of the database - CORRECT ANSWER C
13) A set of individual user views of the database is called the
A) conceptual-level schema.
B) internal-level schema.
C) external-level schema.
D) meta-schema. - CORRECT ANSWER C
