Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
WHICH OF THE FOLLOWING ARE NOT ADVANTAGES OF A
DATABASE SYSTEM?
a. | SEQUENTIAL ACCESS EFFICIENCY | c. | UNIFORM SECURITY AND PRIVACY | b. | MINIMAL DATA REDUNDANCY | d. | EASIER ENFORCEMENT
OF STANDARDS |
|
|
|
2.
|
A DATABASE IS A COLLECTION OF DATA THAT IS SHARED
AND ..
a. | UNIFORM | c. | INTEGRATED | b. | ACCESSIBLE | d. | INDEPENDENT |
|
|
|
3.
|
WHICH OF THE FOLLOWING ARE DATABASE
MODELS?
a. | NETWORK
| c. | RELATIONAL | b. | HIERARCHICAL
| d. | ALL OF THE
ABOVE |
|
|
|
4.
|
An application where only one user accesses the
database at a given time is an example of a(n) _________ .
a. | single-user database
application
| c. | e-commerce database
application
| b. | multiuser database
application
| d. | data mining database
application
|
|
|
|
5.
|
Because it contains a description of its own
structure, a database is considered to be ____________ .
a. | described
| c. | self-describing
| b. | metadata
compatible
| d. | an application program
|
|
|
|
6.
|
Which of the following products implemented the
CODASYL DBTG model?
a. | IDMS
| c. | dBase-II
| b. | DB2
| d. | R:base
|
|
|
|
7.
|
Data definition commands are
sometimes called:
a. | DDL. | c. | SQL. | b. | DML. | d. | None of the above |
|
|
|
8.
|
What allowed database
technology to move from an organizational context to a personal-computing context?
a. | The combination of microcomputers and distributed
database processing | c. | The development of the
Web | b. | Object-Oriented DBMS | d. | The combination of
microcomputers, the relational model, and improved user
interfaces |
|
|
|
9.
|
The data about the structure of
a database is called:
a. | application metadata. | c. | metadata. | b. | user
data. | d. | indexes. |
|
|
|
10.
|
Facts about objects, people, or entities is/are called:
a. | Information | c. | Metadata | b. | Data | d. | none of the
above |
|
|
|
11.
|
Which of the following is not true about manual file processing?
a. | data is separated and isolated | c. | File definitions are
independent | b. | Files are often incompatible | d. | None of the
above |
|
|
|
12.
|
Which of the following is not an advantage of a DBMS?
a. | Reduced data redundency | c. | Information
protection | b. | Faster response time | d. | None of the above |
|
|
|
13.
|
When should you use a Database?
a. | Application needs are constantly changing | c. | Data elements are shared amomg
users | b. | Rapid access is required | d. | All of the above |
|
|
|
14.
|
Which of the following is not considered one of the 3 levels of
databases?
a. | Workgroup | c. | Distributed | b. | Personal | d. | Organizational |
|
|
|
15.
|
“Many to Many” relationships are implementable in which of the
following models?
a. | Hierarchical | c. | Relational | b. | Network | d. | None of the
above |
|
|
|
16.
|
In which of the following models is a an entity not allowed to be both a parent
and a child?
a. | Relational | c. | Limited Network | b. | Simple Network | d. | None of the
above |
|
|
|
17.
|
Which of the following is not considered to be a component of a DBMS?
a. | Hardware | c. | Procedures | b. | Software | d. | None of the
above |
|
|
|
18.
|
Which of the following is not a Rule of
Precedence:
a. | Multiplication and division occur before addition
and subtraction.
| c. | Parentheses are used to override
the default precedence or to clarify the statement.
| b. | Operators of the same priority are evaluated from left to
right. | d. | You must separate the operators with
spaces
|
|
|
|
19.
|
The concatenation operator
is.
|
|
|
20.
|
You use SQL statements
to:
a. | Retrieve, modify, add, and remove data from the
database
| c. | Create script files to store SQL
statements for repeated use in the future
| b. | Format, perform calculations on, store, and print query results in the form of
reports
| d. | All of the
above |
|
|
|
21.
|
The DESCRIBE
command
a. | Is not an SQL statement
| c. | Shows the format of the table | b. | Can be abbreviated
| d. | All of the
above
|
|
|
|
22.
|
The % symbol in the LIKE
condition
a. | Represents 1 character in the
string
| c. | Is invalid, you must use the
*
| b. | Represents 0,1 or more characters in the
string | d. | None of the Above
|
|
|
|
23.
|
The order of precedence in
compound conditions is
a. | OR,
AND,NOT
| c. | NOT, OR,
AND
| b. | AND, OR, NOT
| d. | NOT, AND, OR
|
|
|
|
24.
|
Substitution variables are represented by
the following
|
|
|
25.
|
Which of the following is not a restriction for a
table to be a relation?
a. | The cells of the table must contain a single
value. | c. | The columns must be ordered. | b. | All of the entries in any column must be of the same
kind. | d. | No two rows in a table may be
identical. |
|
|
|
26.
|
A tuple is a(n):
a. | column of a table | c. | row of a
table. | b. | two dimensional table. | d. | key of a
table. |
|
|
|
27.
|
An attribute is a(n):
a. | column of a table. | c. | row of
a table. | b. | two dimensional table. | d. | key of a
table. |
|
|
|
28.
|
A functional dependency is a relationship between
or among:
a. | tables. | c. | relations. | b. | rows. | d. | attributes |
|
|
|
29.
|
The primary key is selected from the:
a. | composite keys. | c. | candidate keys. | b. | determinants. | d. | foreign keys. |
|
|
|
30.
|
In the relational model, relationships between
relations or tables are created by using:
a. | composite keys. | c. | candidate keys. | b. | determinants. | d. | foreign keys. |
|
|
|
31.
|
When the values in one or more attributes being
used as a foreign key must exist in another set of one or more attributes in another table, we have
created a(n):
a. | transitive dependency. | c. | referential integrity constraint. | b. | insertion anomaly. | d. | normal
form. |
|
|
|
32.
|
For some relations, changing the data can have
undesirable consequences called:
a. | referential integrity constraints. | c. | normal forms | b. | modification
anomalies. | d. | transitive dependencies. |
|
|
|
33.
|
The different classes of relations created by the
technique for preventing modification anomalies are called:
a. | normal forms. | c. | functional dependencies. | b. | referential
integrity constraints. | d. | None of the above is
correct. |
|
|
|
34.
|
A relation in this form is free of all modification
anomalies.
a. | First normal form | c. | Third
normal form | b. | Second normal
form | d. | Domain/key normal form |
|
|
|
35.
|
Eliminating modification anomalies is a(n)
_____________ of normalization.
a. | advantage | c. | either
an advantage or disadvantage | b. | disadvantage | d. | neither an advantage nor
disadvantage |
|
|
|
36.
|
Needing to using more complicated SQL in database
applications is a(n) _____________ of normalization.
a. | advantage | c. | either
an advantage or disadvantage | b. | disadvantage | d. | neither an advantage nor
disadvantage |
|
|
|
37.
|
Normalization _________________ data duplication.
a. | eliminates | c. | increases | b. | reduces | d. | maximizes |
|
|
|
38.
|
Most of the time, modification anomalies are
serious enough that tables should be normalized into:
|
|
|
39.
|
If a table has been normalized so that all
determinants are candidate keys, then that table is in:
a. | 1NF. | c. | 3NF. | b. | 2NF. | d. | BCNF. |
|
|
|
40.
|
Which of the following is NOT a basic element of
all versions of the E-R model?
a. | Entities | c. | Relationships | b. | Attributes | d. | Primary keys |
|
|
|
41.
|
Entities of a given type are grouped into a(n):
a. | database. | c. | attribute. | b. | entity
class. | d. | ERD. |
|
|
|
42.
|
Which of the following refers to something that can
be identified in the users' work environment, something that the users want to track?
a. | Entity | c. | Identifier | b. | Attribute | d. | Relationship |
|
|
|
43.
|
Properties that describe the characteristics of
entities are called:
a. | entities. | c. | identifiers. | b. | attributes. | d. | relationship |
|
|
|
44.
|
An attribute that names or identifies entity
instances is a(n):
a. | entity. | c. | identifier. | b. | attribute. | d. | relationship. |
|
|
|
45.
|
In which of the following is a single-entity
instance of one type of related to a single-entity instance of another type?
a. | One-to-One Relationship | c. | Many-to-Many Relationship | b. | One-to-Many Relationship | d. | Composite
Relationship |
|
|
|
46.
|
Which of the following indicates the maximum number
of entities that can be involved in a relationship?
a. | Minimum cardinality | c. | ERD | b. | Maximum
cardinality | d. | Greater Entity Count (GEC) |
|
|
|
47.
|
Which of the following refers to an entity in which
the identifier of one entity includes the identifier of another entity?
a. | Weak entity | c. | ID-dependent entity | b. | Strong
entity | d. | ID-independent entity |
|
|
|
48.
|
Which type of entity cannot exist in the database
unless another type of entity also exists in the database, but does not require that the identifier
of that other entity be included as part of its own identifier?
a. | Weak entity | c. | ID-dependent entity | b. | Strong
entity | d. | ID- independent entity |
|
|
|
49.
|
Which type of entity is related to two or more
associated entities that each contain specialized attributes that apply to some but not all of the
instances of the entity?
a. | Supertype entity | c. | Archetype entity | b. | Subtype
entity | d. | Instance entity |
|
|
|
50.
|
A recursive relationship is a relationship between
an entity and __________________ .
a. | itself | c. | an
archetype entity | b. | a subtype
entity | d. | an instance entity |
|