Computer Science : Relational model and Keys Online Test
Follow @mishrajigpo
For updates Please Like our Page :
Time Remaining:
Q.1) Table is synonym with the term -
A. tuple
B. column
C. field
D. relation
A. tuple
B. column
C. field
D. relation
Answer: Option (D)
Answer Description: Table is the synonym with the term 'Relation' in relational database systems.
Answer Description: Table is the synonym with the term 'Relation' in relational database systems.
Q.2) A key -
A. identifies a column
B. identifies a row
C. must always be composed of two or more columns
D. can only be one column
A. identifies a column
B. identifies a row
C. must always be composed of two or more columns
D. can only be one column
Answer: Option (B)
Answer Description: na
Answer Description: na
Q.3) An attribute is a(an) -
A. column of table
B. two dimensional table
C. row of a table
D. key of a table
A. column of table
B. two dimensional table
C. row of a table
D. key of a table
Answer: Option (A)
Answer Description: An attribute is a column of a table.
Answer Description: An attribute is a column of a table.
Q.4) Which of the following is group of the one or more attributes that uniquely identifies a row -
A. tuple
B. determinants
C. relation
D. key
A. tuple
B. determinants
C. relation
D. key
Answer: Option (D)
Answer Description: na
Answer Description: na
Q.5) A relation is considered a-
A. Column
B. One dimensional table
C. Two dimensional table
D. Three Dimensional table
A. Column
B. One dimensional table
C. Two dimensional table
D. Three Dimensional table
Answer: Option (C)
Answer Description: na
Answer Description: na
Q.6) A functional dependency is a relationship between or among -
A. tables
B. relations
C. rows
D. attributes
A. tables
B. relations
C. rows
D. attributes
Answer: Option (D)
Answer Description: n/a
Answer Description: n/a
Q.7) The different classes of relations created by the technique for preventing modification anomalies are called -
A. Functional dependency
B. Referencial integrity constraints
C. Normal Forms
D. None of the above
A. Functional dependency
B. Referencial integrity constraints
C. Normal Forms
D. None of the above
Answer: Option (C)
Answer Description: n/a
Answer Description: n/a
Q.8) Row is synonymous with the term -
A. record
B. column
C. relation
D. field
A. record
B. column
C. relation
D. field
Answer: Option (A)
Answer Description: Row is also known as Record.
Answer Description: Row is also known as Record.
Q.9) A relationship is in the form if it is in BCNF and has no multivalued dependencies -
A. second normal form
B. third normal form
C. fourth normal form
D. domain/key normal form
A. second normal form
B. third normal form
C. fourth normal form
D. domain/key normal form
Answer: Option (C)
Answer Description: not available
Answer Description: not available
Q.10) The primary key is selected from the -
A. Candidate key
B. foreign key
C. composite key
D. determinants
A. Candidate key
B. foreign key
C. composite key
D. determinants
Answer: Option (A)
Answer Description: The primary key is selected from the candididate key.
Answer Description: The primary key is selected from the candididate key.
Follow @mishrajigpo