When you have finished entering information into a form
A. the template is written to the data file
B. the contents of the form are written to the data file
C. the contents of the form can be printed
D. All of the above
E. None of the above
Select an option to see the answer and solution.
The main idea behind computer files is that it is convenient to
A. arrange them
B. store information together
C. create them
D. access them
E. None of the above
Select an option to see the answer and solution.
A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A. the pin code
B. the last name
C. a compound key consisting of the first name and the last name
D. All of the above
E. None of the above
Select an option to see the answer and solution.
In SQL, which command is used to add new rows to a table?
A. ALTER TABLE
B. ADD ROW
C. INSERT
D. APPEND
E. None of the above
Select an option to see the answer and solution.
A number of related records that are treated as a unit is called
A. file
B. field
C. data
D. batch
E. None of the above
Select an option to see the answer and solution.
If you want to group the records in the abc database, you could use the Jobcode as the _____.
A. Delete
B. Update
C. Sort Key
D. Index
E. None of the above
Select an option to see the answer and solution.
The Management Information system (MIS) structure with one main computer system is called a
A. hierarchical MIS structure
B. distributed MIS structure
C. centralized MIS structure
D. decentralized MIS structure
E. None of the above
Select an option to see the answer and solution.
If a calculation is embedded in a form
A. the result of the calculations are stored with the form
B. the calculations are stored with the form
C. the result of the calculations are printed in report
D. All of the above
E. None of the above
Select an option to see the answer and solution.
Data security threats include
A. hardware failure
B. privacy invasion
C. fraudulent manipulation of data
D. All of the above
E. None of the above
Select an option to see the answer and solution.
An operation that will increase the length of a list is
A. Insert
B. Look-up
C. Modify
D. All of the above
E. None of the above
Select an option to see the answer and solution.
In SQL, which command is used to add a column/integrity constraint to a table
A. ADD COLUMN
B. INSERT COLUMN
C. MODIFY TABLE
D. ALTER TABLE
E. None of the above
Select an option to see the answer and solution.
In SQL, which command(s) is(are) used to enable/disable a database trigger?
A. ALTER TRIGGER
B. ALTER DATABASE
C. ALTER TABLE
D. MODIFY TRIGGER
E. All of the above
Select an option to see the answer and solution.
In a relational schema, each tuple is divided into fields called
A. Relations
B. Domains
C. Queries
D. All of the above
E. None of the above
Select an option to see the answer and solution.
In SQL, which command is used to changes data in a table?
A. UPDATE
B. INSERT
C. BROWSE
D. APPEND
E. None of the above
Select an option to see the answer and solution.
What name is given to the collection of facts, items of information or data which are related in some way?
A. Database
B. Directory information
C. Information tree
D. Information provider
E. None of the above
Select an option to see the answer and solution.
In a large DBMS
A. each user can "see" only a small part of the entire database
B. each user can access every sub¬schema
C. each subschema contains every field in the logical schema
D. All of the above
E. None of the above
Select an option to see the answer and solution.
Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
A. COMPILE PROCEDURE
B. ALTER PROCEDURE
C. MODIFY PROCEDURE id) All of the above
D. None of the above
E. None of the above
Select an option to see the answer and solution.
Internal auditors should review data system design before they are
A. developed
B. implemented
C. modified
D. All of the above
E. None of the above
Select an option to see the answer and solution.
A _____ means that one record in a particular record type may be related to more than one record of another record type.
A. One-to-one relationship
B. One-to-many relationship
C. Many-to-one relationship
D. Many-to many relationship
E. None of the above
Select an option to see the answer and solution.
Which command(s) is(are) used to redefine a column of the table in SQL ?
A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. All of the above
E. None of the above
Select an option to see the answer and solution.