1 |
Which of the following is used to describe the characteristics of an object? |
Attribute
Relationship
Cardinality
Modality
|
2 |
A data model is : |
A logical representation of the structure of the database
Shown as an entity-relationship diagram
Transformed into tables and relationships
All
|
3 |
In hybrid distribution, what types of fragments are stored at only one site? |
Critical fragments
Non-critical fragments
Critical and non-critical fragments
Only large fragments
|
4 |
An entity related to itself in an ERD model refers to : |
Recursive relationship
One-to-many relationship
Many-to-many relationship
One-to-one relationship
|
5 |
Which of the following keys us not unique: |
Candidate key
Forein key
Primary key
Secondary key
|
6 |
Which of the following are properties of relations? |
Each attribute has a unique name
No two rows in a relation are identical
There are no multivalued attributes in a relation
All of the above
|
7 |
An index can be used to : |
Improve the performance of the database
Document the structure of the database
Reduce data dependency for application programs
All
|
8 |
Which of the following is NOT a characteristic of relation? |
Each row is unique
The order of columns is significant
The order of rows is insignificant
Columns are all elemental or atomic
|
9 |
The data or information that describes an entity is called: |
Attribute
Data item
Record
Tuple
|
10 |
A person, place, thing or event about which data is kept in the database is called: |
Attribute
Field
Record
Entity
|
11 |
A row of a relation is called: |
Attribute
Entity
Tuple
a and c
|
12 |
An attribute is also known as a: |
Table
Row
Relation
Field
|
13 |
A relation is also known as: |
Table
Tuple
Relationship
Attributes
|
14 |
A table is a two-dimensional structure that consists of: |
x and y co-ordinates
Matrix elements
Rows and columns
Intersection of data
|
15 |
A two-dimensional table of data is called: |
Group
Set
Module
Relation
|
16 |
A table should have : |
Primary key
Secondary key
Composite key
Sort key
|
17 |
The forein key is found in: |
Parent table
Dependent table
Pivot table
Index table
|