Practice Test: Question Set - 12
1. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
- (A) Special
purpose packages
- (B) Custom made
programs
- (C) Single
function application packages
- (D) Data
management packages
2. A number of related records that are treated as a unit is called
- (A) File
- (B) Field
- (C) Data
- (D) Batch
3. A _______ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
- (A) Network
- (B) Hierarchical
- (C) Relational
- (D) Object-Oriented
4. Which two files are used during operation of the DBMS?
- (A) Query
language and utilities
- (B) Data
manipulation language and query language
- (C) Data
dictionary and transaction log
- (D) Data
dictionary and query language
5. In SQL, which command(s) is(are) used to create a synonym for a schema object?
- (A) CREATE
SCHEMA
- (B) CREATE
SYNONYM
- (C) CREATE SAME
- (D) None of the
above
6. Periodically adding, changing and deleting file records is called file
- (A) Updating
- (B) Upgrading
- (C) Restructuring
- (D) Renewing
7. In a _______ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
- (A) Network
database
- (B) Relational
database
- (C) Distributed
database
- (D) Hierarchical
database
8. In mathematical term Row is referred as
- (A) Relation
- (B) Attribute
- (C) Tuple
- (D) Domain
9. Which of the following is not Unary operation?
- (A) Select
- (B) Project
- (C) Rename
- (D) Union
10. ODBC stands for _________
- (A) Offline
database connection
- (B) Oriented
database connection
- (C) Open
database connection
- (D) None
of above
11. A transaction completes its execution is said to be
- (A) Saved
- (B) Loaded
- (C) Rolled
- (D) Committed
12. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
- (A) Tables
- (B) Relations
- (C) Tuple
- (D) Both (a) and
(b)
13. In SQL, which of the following is not a data definition language commands?
- (A) RENAME
- (B) REVOKE
- (C) GRANT
- (D) UPDATE
14. A _________ DBMS distributes data processing tasks between the workstation and a network server.
- (A) Network
- (B) Relational
- (C) Client
Server
- (D) Hierarchical
15. Long-range planning report produced in an MIS are primarily designed for
- (A) Top
management
- (B) Middle
management
- (C) Lower
management
- (D) None
of the above
Next Tests: