Terms : Hide Images
| 5559949923 | In most cases, access to every table and field in a database is a necessity for every user. | False | 0 | |
| 5559952469 | The CEO of the company determines the database access privileges for all users. | False | 1 | |
| 5559954982 | Damage to a database can occur through a physical incident such as an abnormally terminated program. | True | 2 | |
| 5559958025 | The DBA creates security policies and procedures. | False | 3 | |
| 5559960507 | Management approval is not required before the security policies and procedures can be implemented. | False | 4 | |
| 5559963593 | To implement and enforce security, the DBA uses such features as encryption and views. | True | 5 | |
| 5559967116 | Programmers monitor database usage to detect potential security violations. | False | 6 | |
| 5559969676 | To protect an organization's data against physical damage, the DBA creates a disaster recovery plan. | True | 7 | |
| 5559984410 | The DBA is responsible for DBMS maintenance, data dictionary management, and training. | True | 8 | |
| 5559990081 | When a company decides to purchase a new DBMS, the CEO leads the DBMS evaluation and selection effort. | False | 9 | |
| 5559993449 | SQL is an example of a nonprocedural language. | False | 10 | |
| 5559996476 | QBE is an example of a procedural language. | False | 11 | |
| 5559999924 | A shared lock permits other users to read the data in the database. | True | 12 | |
| 5560003827 | An internal company network that uses software tools typically used on the Internet and World Wide Web is called an extranet. | False | 13 | |
| 5560006420 | Another term for production system is the test system. | False | 14 | |
| 5560014284 | The ____ determines the access privileges for all users and enters the appropriate authorization rules in the DBMS catalog to ensure that users access the database only in ways in which they are entitled to do so. a. CEO b. programmer c. DBA d. IT manager | c. DBA | 15 | |
| 5560020230 | A ____ is a place where a record of certain corporate data is kept. a. depository b. data archive c. storage d. data bank | b. data archive | 16 | |
| 5560025078 | Which of the following DBMS evaluation categories does the following question relate to: Is it a simple catalog or can it contain more content, such as information about programs and the various data items these programs access? a. Backup and recovery b. Data dictionary c. Security d. Integrity | b. Data dictionary | 17 | |
| 5560029712 | Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted? a. Concurrent update b. Data recovery c. Data dictionary d. Security | a. Concurrent update | 18 | |
| 5560033915 | ____ locks forbid any other user from accessing the data in any way. a. Shared b. Exclusive c. Limited d. Concurrent | b. Exclusive | 19 | |
| 5560041858 | 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? a. Backup and recovery b. Security c. Integrity d. Replication and distributed databases | d. Replication and distributed databases | 20 | |
| 5560048107 | Which of the following DBMS evaluation categories does the following question relate to: How many files can you open at the same time? a. Concurrent update b. Security c. Integrity d. Limitations | d. Limitations | 21 | |
| 5560053558 | Which of the following DBMS evaluation categories does the following question relate to: On what operating system and hardware is the DBMS supported? a. Concurrent update b. Security c. Limitations d. Limitations | d. Limitations | 22 | |
| 5560058626 | Which of the following DBMS evaluation categories does the following question relate to: What types of files can you import or export? a. Cost b. Future plans c. Portability d. Performance | c. Portability | 23 | |
| 5560064466 | 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? a. Portability b. Performance c. Cost d. Documentation and training | d. Documentation and training | 24 | |
| 5560069411 | ____ integrity is the constraint that says that the values in foreign keys must match values already in the database. a. Parallel b. Relational c. Conditional d. Referential | d. Referential | 25 | |
| 5560077591 | After the DBMS is purchased, the ____ has primary responsibility for installation and maintenance. a. IT manager b. DBA c. CEO d. user | b. DBA | 26 | |
| 5560083690 | The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary. a. users b. DBMS c. DBA d. programmers | c. DBA | 27 | |
| 5560089093 | The ____ is responsible for providing training in the use of the DBMS. a. programmer b. analyst c. DBA d. CEO | c. DBA | 28 | |
| 5560093725 | After the database designers complete the information-level design, the DBA does the ____-level design. a. physical b. information c. logical d. graphical | a. physical | 29 | |
| 5560099200 | In order to develop new programs, the programmers need access to the information in the DBMS. They are given access to the ____. a. production system b. test system c. live system d. documentation system | b. test system | 30 | |
| 5560104340 | Changing the database design to improve the performance is called ____. a. tending the design b. focusing the design c. tuning the design d. modifying the design | c. tuning the design | 31 | |
| 5560109436 | By default, Access and other DBMSs create indexes automatically for the ____ keys. a. primary and minor b. alternate and foreign c. secondary and alternate d. primary and foreign | d. primary and foreign | 32 | |
| 5560113762 | Tables with indexes allow faster searches, but slow performance on ____. a. insertions b. deletions c. updates d. selects | c. updates | 33 | |
| 5560117461 | ____ converts a table that is in third normal form to a table no longer in third normal form. a. Conversion b. Denormalization c. Normalization d. Replication | b. Denormalization | 34 |
