(15 questions)
BEC 12 IT software
Highlight answer in yellow
Email to Acct5890@bergg.etsu.edu (rename file to include your last name)
Name:
[1] XML
A. Is focused on the content of the data.
B. Uses standardized tags.
C. Has become less important as new languages on the Internet are developed.
D. Is useful to display highly unstructured data.
[2] Structured Query Language (SQL) is best defined as a
A. Data manipulation language used in conjunction with a database management system (DBMS).
B. Programming language in which many business applications are written.
C. Report generator used to produce customized business reports.
D. Programming language in which UNIX is written.
[3] Fourth-generation computer programming languages are represented by
A. Procedure-oriented languages, which describe processing procedures.
B. Query languages, which allow direct access to a computer database.
C. Machine languages, which describe processing procedures.
D. Symbolic languages, which allow direct access to a stored database.
[ 4] Computers understand codes that represent letters of the alphabet, numbers, or special characters. These
codes require that data be converted into predefined groups of binary digits. Such chains of digits are referred to
as
A. Bytes.
B. Input.
C. ASCII code.
D. Registers.
1
[5] Based only on the database file excerpt presented below, which one of the fields or combinations of fields is
eligible for use as a key?
A. Column IV and Column V in combination.
B. Column III alone.
C. Column I and Column V in combination.
D. Column I and Column II in combination.
[6] The indexed sequential access method (ISAM) is an approach to file organization
A. In which records are stored sequentially in a direct access file and organized by a primary key stored in
an index record.
B. In which each data record has a pointer field containing the address of the next record in the list.
C. In which an index of record pointers of some of the file attributes are maintained in a list.
D. That uses an algorithm to convert a record key into a storage address to assist with later retrieval.
2
[7]
Jethro's headquarters' matrix described in (3) is primarily intended to provide
A. Access control to computer hardware.
B. Authorization for processing.
C. Authentication of the user.
D. Data integrity control.
[8]
Jethro's new control described in (4) is primarily intended to prevent
A. Transaction processing delay.
B. LAN server overload.
C. Duplicate processing of transactions.
D. Concurrent transaction processing.
[9] In 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
A. Unrecoverable transactions.
B. Inconsistent processing.
C. Deadly embraces.
D. Rollback failures.
3
[10] To 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
A. Database schema.
B. Decision table.
C. Data encryptor.
D. Data dictionary.
[11] An internal auditor is preparing procedures to verify the integrity of data in a database
application. The best source of information for the auditor to determine data field definitions is the
A. Data definition language.
B. Data manipulation language.
C. Data subschemas.
D. Data dictionary.
[12] Enabling users to have different views of the same data is a function of
A. The operating system.
B. A program library management system.
C. The database management system.
D. A utility program.
[13] The least risky strategy for converting from a manual to a computerized accounts receivable system would
be a
A. Pilot conversion.
B. Parallel conversion.
C. Direct conversion.
D. Database conversion.
[1 4] An information system (IS) project manager is currently in the process of adding a systems analyst to the
IS staff. The new systems analyst will be involved with testing the new computerized system. At which stage of
the systems development life-cycle will the analyst be primarily used?
A. Requirements definition.
B. Flowcharting.
C. Implementation.
D. Cost-benefit analysis.
[15] The process of learning how the current system functions, determining the needs of users, and developing
the logical requirements of a proposed system is referred to as
A. Systems design.
B. Systems maintenance.
C. Systems feasibility study.
D. Systems analysis.
4