MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
database
Quiz 2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
In a relation, the order of the rows matters.
True
False
Q.2
In a relation, the rows are sometimes called "records".
True
False
Q.3
A relation is a two-dimensional table.
True
False
Q.4
Any table that meets the definition of a relation is said to be in first normal form.
True
False
Q.5
Given the functional dependency
R → (S,T)
, then it is also true that
R → S
.
True
False
Q.6
A relation in this form is free of all modification anomalies.
First normal form
Second normal form
Third normal form
Domain/key normal form
Q.7
If attributes A and B determine attribute C, then it is also true that:
A → C.
B → C.
(A,B) is a composite determinant.
C is a determinant.
Q.8
A tuple is a(n):
column of a table.
two dimensional table.
row of a table.
key of a table.
Q.9
If attribute A determines both attributes B and C, then it is also true that:
A → B.
B → A.
C → A.
(B,C) → A.
Q.10
One solution to the multivalued dependency constraint problem is to:
split the relation into two relations, each with a single theme.
change the theme.
create a new theme.
add a composite key.
Q.11
Table is synonymous with the term:
record.
relation.
column.
field.
Q.12
Which of the following is not a restriction for a table to be a relation?
The cells of the table must contain a single value.
All of the entries in any column must be of the same kind.
The columns must be ordered.
No two rows in a table may be identical.
Q.13
For some relations, changing the data can have undesirable consequences called:
referential integrity constraints.
modification anomalies.
normal forms.
transitive dependencies.
Q.14
A key:
must always be composed of two or more columns.
can only be one column.
identifies a row.
identifies a column.
Q.15
An attribute is a(n):
column of a table.
two dimensional table.
row of a table.
key of a table.
Q.16
Which of the following is a group of one or more attributes that uniquely identifies a row?
Key
Determinant
Tuple
Relation
Q.17
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):
transitive dependency.
insertion anomaly.
referential integrity constraint.
normal form.
Q.18
A relation is considered a:
Column.
one-dimensional table.
two-dimensional table.
three-dimensional table.
Q.19
In the relational model, relationships between relations or tables are created by using:
composite keys.
determinants.
candidate keys.
foreign keys.
Q.20
Which of the following is a group of one or more attributes that uniquely identifies a row?
Key
Determinant
Tuple
Relation
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)