Question 1

After the DBMS is purchased,the ____ has primary responsibility for installation and maintenance.

Accepted Answer

The DBA (Database Administrator) has the primary responsibility for installing and maintaining the DBMS (Database Management System). This includes tasks such as setting up the database infrastructure, configuring the system for optimal performance, monitoring the system for issues, and troubleshooting any problems that arise. Although the IT manager may oversee the DBA and provide support, the DBA is typically the one with the specialized knowledge and expertise needed to manage a complex database system. The CEO and users may have some input into the selection and usage of the DBMS, but they are not directly responsible for its installation and maintenance.

Question 2

By default,Access and other DBMSs create indexes automatically for the ____ keys.

Accepted Answer

By default, Access and other DBMSs create indexes automatically for the primary and foreign keys. The primary key ensures that each record is unique, and the foreign key establishes a relationship between tables. Creating indexes for these keys can improve search and retrieval performance.

Question 3

Changing the database design to improve the performance is called ____ the design.

Accepted Answer

Tuning the design involves making adjustments to improve the performance of the database, such as adding indexes, optimizing queries, or rearranging the schema. Tending, focusing, and modifying do not specifically refer to performance improvements.

Question 4

____________________ is the prevention of unauthorized access,either intentional or accidental,to a database.

Accepted Answer

The answer of ____________________ is the prevention of unauthorized access,either...

Question 5

____ integrity is the constraint that says that the values in foreign keys must match values already in the database.

Accepted Answer

Referential integrity is a constraint that ensures that the values in foreign keys match values already existing in the database's primary key. It helps to maintain consistency and avoid data anomalies in the database.

Question 6

Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time?

Accepted Answer

The question is asking about the limitation of the DBMS in terms of how many files can be opened at the same time. Therefore, it falls under the category of Limitations.

Question 7

____________________ is the rule that the primary key cannot be null.

Accepted Answer

The answer of ____________________ is the rule that the primary...

Question 8

After the database designers complete the information-level design,the DBA does the ____-level design.

Accepted Answer

After the information-level design is completed, the DBA takes over and does the physical-level design, which involves the implementation of the database on specific hardware and software platforms. This includes decisions on file organization, indexing, and storage structures. The logical-level design is the translation of the information-level design into a conceptual model, which can be further refined to create a physical design. The graphical-level design is not a recognized level of database design.

Question 9

The ____________________ Act of 2002 is a federal law that specifies data retention and verification requirements for public companies,requires CEOs and CFOs to certify financial statements,and makes it a crime to tamper with financial records.

Accepted Answer

The answer of The ____________________ Act of 2002 is a...

Question 10

In order to develop new programs,the programmers need access to the information in the DBMS. They are given access to the ____.

Accepted Answer

Programmers typically have access to a test system, which is a separate copy of the production system used for development and testing of new programs without affecting the live system. They may also have access to documentation systems for reference, but this is not necessary for developing new programs. Access to the live system is typically limited to authorized personnel in order to maintain data integrity and security.

Question 11

____ converts a table that is in third normal form to a table no longer in third normal form.

Accepted Answer

Denormalization is the process of intentionally adding redundancy to a database to improve performance or simplify queries. This is typically done by combining tables and fields in a way that violates the rules of normalization, and can result in a table that is no longer in third normal form.

Question 12

To protect against electrical power interruptions and outages,organizations use a(n) ____________________,which is a power source such as battery or fuel cell.

Accepted Answer

The answer of To protect against electrical power interruptions and...

Question 13

The ____ is responsible for providing training in the use of the DBMS.

Accepted Answer

The responsibility of providing training in the use of the DBMS falls under the role of the database administrator (DBA). The DBA is responsible for the maintenance, security, and management of the database system, including ensuring that users are properly trained and knowledgeable in using the system. Programmers and analysts may be responsible for specific programming or analysis tasks within the database system, but they are not typically responsible for providing training to other users. The CEO would not be directly involved in the day-to-day operations of the DBMS or providing training for users.

Question 14

Tables with indexes allow faster searches,but slower performance on ____.

Accepted Answer

Tables with indexes may take longer to update since the indexes also need to be updated, which can slow down performance on updates. The other options (queries, reports, selects) may benefit from the faster searches provided by the indexes.

Question 15

The ____ establishes the naming conventions for tables,fields,and indexes in the data dictionary.

Accepted Answer

The DBA (Database Administrator) is responsible for maintaining the data dictionary, which includes establishing naming conventions for tables, fields, and indexes. The DBMS (Database Management System) provides the software tools to manage the database, but it is the DBA's responsibility to define the database schema and enforce good database design practices. The programmer may contribute to the naming conventions, but ultimately it is up to the DBA to ensure consistency and usability across the database. The user interacts with the database, but typically has no direct involvement in the data dictionary or schema design.

Question 16

Which of the following DBMS evaluation categories does the following question relate to: Does the vendor of the DBMS supply printed or online training manuals and how good are the manuals?

Accepted Answer

The question refers to the vendor's documentation and training, which falls under the DBMS evaluation category of documentation and training.

Question 17

Which of the following DBMS evaluation categories does the following question relate to: On what operating system and hardware is the DBMS supported?

Accepted Answer

The question pertains to the category of limitations or restrictions imposed by the DBMS. It is essential to know the supported operating system and hardware configurations to evaluate whether the DBMS meets the system requirements of the organization. Therefore, this question is related to the limitations of the DBMS.

Question 18

Which of the following DBMS evaluation categories does the following question relate to: Does the DBMS allow partial copies and how does the DBMS handle updates to the same data from two or more replicas?

Accepted Answer

The question relates to the category of Replication and Distributed Databases as it is about how a DBMS handles partial copies and updates to replicas.

Question 19

Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export?

Accepted Answer

The question relates to portability, which refers to the ability of a DBMS to import and export data from/to different file formats and systems. Cost relates to pricing and licensing, future plans refer to the development and growth of the DBMS, and performance relates to the speed and efficiency of the DBMS operations.

Question 20

The DBA uses views and the SQL ____________________ statement as two security mechanisms.

Accepted Answer

The answer of The DBA uses views and the SQL...

Quiz 8: Database Administration