 |
1 | |
Which of the following is not the duty of database administrators (DBAs)?
|
|
| | A) | Interacting with the data administration subsystem
|
| | B) | Writing programs that use the database
|
| | C) | Determining processing rights
|
| | D) | Determining which people have access to what kinds of data in the database
|
|
2 | |
What distinguishes web databases from other types of databases?
|
|
| | A) | They are user-friendly.
|
| | B) | They are available over the web.
|
| | C) | They are not user-friendly.
|
| | D) | When you use them, cookies are disabled.
|
|
3 | |
The particular field of a record that uniquely identifies each record is called the
|
|
| | A) | key field.
|
| | B) | primary field.
|
| | C) | master field.
|
| | D) | order field.
|
|
4 | |
Select the correct order of complexity of the following data categories from least complex to most complex.
|
|
| | A) | Field, character, file, record, database
|
| | B) | Character, record, field, database, file
|
| | C) | File, database, record, character, field
|
| | D) | Character, field, record, file, database
|
|
5 | |
Special software that creates, modifies, and accesses database files is referred to as a
|
|
| | A) | database management system.
|
| | B) | database dictionary.
|
| | C) | data organizer.
|
| | D) | data access manager.
|
|
6 | |
A network database is similar to a hierarchical database with the exception of this feature.
|
|
| | A) | Query language
|
| | B) | Many-to-many relationships
|
| | C) | Parent and child nodes
|
| | D) | One-to-many relationships
|
|
7 | |
One of the following is not an organizing element in an object oriented database.
|
|
| | A) | Classes
|
| | B) | Rows
|
| | C) | Entities
|
| | D) | Methods
|
|
8 | |
A database where data is stored in more than one location, often in different locations than where the users are located, is known as a
|
|
| | A) | distributed database.
|
| | B) | network database.
|
| | C) | decentralized database.
|
| | D) | Internet database.
|
|
9 | |
A technique for searching special databases, called data warehouses, looking for related information and patterns is called
|
|
| | A) | data matching.
|
| | B) | data query.
|
| | C) | data banking.
|
| | D) | data mining.
|
|
10 | |
If a user would want access to a restricted database to work on a special project, this is the person they would see to grant them access.
|
|
| | A) | Data boss
|
| | B) | Database administrator
|
| | C) | Data overseer
|
| | D) | Database executor
|
|
11 | |
A proprietary database generally describes a collection of integrated files primarily used by one person.
|
|
| | A) | TRUE |
| | B) | FALSE
|
|
12 | |
Two advantages of using a database are less data integrity and more data redundancy.
|
|
| | A) | TRUE |
| | B) | FALSE
|
|
13 | |
Batch processing refers to when data is processed at the same time the transaction occurs.
|
|
| | A) | TRUE |
| | B) | FALSE
|
|
14 | |
Data in a database is accessed via a query language, for example SQL.
|
|
| | A) | TRUE |
| | B) | FALSE
|
|
15 | |
In a relational database all related tables must have a common data item, also known as a key field, to be linked together.
|
|
| | A) | TRUE |
| | B) | FALSE
|