Quiz
SU 5.1
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (35)
1Of the following, the greatest advantage of a database (server) architecture is
- AA. Data redundancy can be reduced.
- BB. Conversion to a database system is inexpensive and can be accomplished quickly.
- CC. Multiple occurrences of data items are useful for consistency checking.
- DD. Backup and recovery procedures are minimized.
2An inventory clerk, using a computer terminal, views the following on screen: part number, part description, quantity on hand, quantity on order, order quantity, and reorder point for a particular inventory item. Collectively, these data make up a
- AA. Field.
- BB. File.
- CC. Database.
- DD. Record.
3Which of the following is the elementary unit of data storage used to represent individual attributes of an entity?
- AA. Database.
- BB. Data field.
- CC. File.
- DD. Record.
4A file-oriented approach to data storage requires a primary record key for each file. Which of the following is a primary record key?
- AA. The vendor number in an accounts payable master file.
- BB. The vendor number in a closed purchase order transaction file.
- CC. The vendor number in an open purchase order master file.
- DD. All of the answers are correct.
5Auditors making database queries often need to combine several tables to get the information they want. One approach to combining tables is known as
- AA. Extraction.
- BB. Joining.
- CC. Sorting.
- DD. Summarization.
6In a database system, locking of data helps preserve data integrity by permitting transactions to have control of all the data needed to complete the transactions. However, implementing a locking procedure could lead to
- AA. Inconsistent processing.
- BB. Rollback failures.
- CC. Unrecoverable transactions.
- DD. Deadly embraces (retrieval contention).
7One advantage of a database management system (DBMS) is
- AA. That each organizational unit takes responsibility and control for its own data.
- BB. That the cost of the data processing department decreases as users are now responsible for establishing their own data handling techniques.
- CC. A decreased vulnerability as the database management system has numerous security controls to prevent disasters.
- DD. The independence of the data from the application programs, which allows the programs to be developed for the user’s specific needs without concern for data capture problems.
8Which of the following should not be the responsibility of a database administrator?
- AA. Design the content and organization of the database.
- BB. Develop applications to access the database.
- CC. Protect the database and its software.
- DD. Monitor and improve the efficiency of the database.
9To trace data through several application programs, an auditor needs to know what programs use the data, which files contain the data, and which printed reports display the data. If data exist only in a database system, the auditor could probably find all of this information in a
- AA. Data dictionary.
- BB. Database schema.
- CC. Data encryptor.
- DD. Decision table.
10What language interface would a database administrator use to establish the structure of database tables?
- AA. Data definition language.
- BB. Data control language.
- CC. Data manipulation language.
- DD. Data query language.
11Query facilities for a database system would most likely include all of the following except
- AA. Graphical output capability.
- BB. Data dictionary access.
- CC. A data validity checker.
- DD. A query-by-example interface.
12An internal auditor encounters a batch-processed payroll in which each record contains the same type of data elements, in the same order, with each data element needing the same number of storage spaces. Which file structure most appropriately supports this set of records?
- AA. Single flat file structure.
- BB. Hierarchical structure.
- CC. Network structure.
- DD. Relational structure.
13Which of the following database models is considered to be the most versatile?
- AA. The tree model.
- BB. The hierarchical model.
- CC. The network model.
- DD. The relational model.
14Which of the following structures refers to the collection of data for all vendors in a relational database?
- AA. Record.
- BB. Field.
- CC. File.
- DD. Byte.
15What is the correct ascending hierarchy of data in a system?
- AA. Character, record, file, field.
- BB. Field, character, file, record.
- CC. Character, field, record, file.
- DD. Field, record, file, character.
16Which one of the following correctly depicts the hierarchy of storage commonly found in computerized databases, from least complex to most complex?
- AA. Byte, field, file, record.
- BB. Byte, field, record, file.
- CC. Field, byte, record, file.
- DD. Field, byte, file, record.
17In a database, there are often conditions that constrain database records. For example, a sales order cannot exist unless the corresponding customer exists. This kind of constraint is an example of
- AA. Normalization.
- BB. Entity integrity.
- CC. Internal schema.
- DD. Referential integrity.
18The primary purpose of a database system is to have a single storage location for each
- AA. File.
- BB. Record.
- CC. Database.
- DD. Data item.
19A database has three record types: (1) for suppliers, a type that contains a unique supplier number, a supplier name, and a supplier address; (2) for parts, a type that contains a unique part number, a part name, a description, and a location; and (3) for purchases, a type that contains a unique supplier number referencing the supplier number in the supplier record, a part number referencing the part number in the part record, and a quantity. This database has a
- AA. Single flat file structure.
- BB. Hierarchical structure.
- CC. Relational structure.
- DD. Network structure.
20One of the principal objectives of a database system is to
- AA. Reduce the overall complexity of data processing and data storage.
- BB. Provide application programs with their own separate data files.
- CC. Employ physical rather than logical data organization concepts.
- DD. Improve data consistency by reducing data redundancy.
21A database is
- AA. Essential for the storage of large data sets.
- BB. A collection of related files.
- CC. A real-time system.
- DD. A network of computer terminals.
22Which of the following is a primary function of a database management system (DBMS)?
- AA. Report customization.
- BB. Capability to create and modify the database.
- CC. Financial transactions input.
- DD. Database access authorizations.
23In an inventory system on a database management system (DBMS), one stored record contains part number, part name, part color, and part weight. These individual items are called
- AA. Fields.
- BB. Stored files.
- CC. Bytes.
- DD. Occurrences.
24An overall description of a database, including the names of data elements, their characteristics, and their relationship to each other, is defined by using a
- AA. Data definition language.
- BB. Data control language.
- CC. Data manipulation language.
- DD. Data command interpreter language.
25Enabling users to have different views of the same data is a function of
- AA. The operating system.
- BB. A program library management system.
- CC. The database management system.
- DD. A utility program.
26The function of a data dictionary is to
- AA. Mark the boundary between two consecutive transactions.
- BB. Describe and share information about objects and resources.
- CC. Specify systems users.
- DD. Specify privileges and security rules for objects and resources.
27An important function of a database administrator is
- AA. Reviewing database output for errors and omissions.
- BB. Scheduling daily database operations.
- CC. Redefining and restructuring the database.
- DD. Evaluating internal controls for hardware.
28A logical view of an entire database is a
- AA. Hierarchy.
- BB. Network.
- CC. Schema.
- DD. Subschema.
29The increased use of database processing systems makes managing data and information a major information service function. Because the databases of an organization are used for many different applications, they are coordinated and controlled by a database administrator. The functions of a database administrator are
- AA. Data input preparation, database design, and database operations.
- BB. Database design, database operation, and database security.
- CC. Database design, database operation, and equipment operations.
- DD. Database design, software support, and database security.
30DB2, Oracle, SQL Server, and Access are
- AA. Library systems.
- BB. Access control systems.
- CC. Programming languages.
- DD. Database management systems.
31Which of the following is a critical success factor in data mining a large data store?
- AA. Pattern recognition.
- BB. Effective search engines.
- CC. Image processing systems.
- DD. Accurate universal resource locator (URL).
32An entity’s database is modeled after a tree structure, with each record type having any number of lower-level dependent records. This is an example of which type of database model?
- AA. Relational.
- BB. Hierarchical.
- CC. Network.
- DD. Distributed.
33A business is designing its storage for accounts receivable information. What data file concepts should be used to provide the ability to answer customer inquiries as they are received?
- AA. Sequential storage and chains.
- BB. Sequential storage and indexes.
- CC. Record keys, indexes, and pointers.
- DD. Inverted file structure, indexes, and internal labels.
34Information systems (IS) strategy is determined by
- AA. Business needs.
- BB. Individual department needs.
- CC. The technology available.
- DD. Competitors’ strategies.
35Which of the following is (are) a type(s) of business strategy(ies)?
- AA. Corporate-level strategy.
- BB. Business-level strategy.
- CC. Functional-level strategy.
- DD. All are types of strategies.
Information
- Description
- CIA Part 3 SU 5 Quiz on SU 5.1, created by Sadan Dahal on 06/06/2020.
- Author
- Sadan Dahal
- Language
- English
- Views
- 2
- Tags
- Rating
- No ratings yet Rate this quiz