Logical Database Design - General Questions Online Exam Quiz
Logical Database Design - General Questions GK Quiz. Question and Answers related to Logical Database Design - General Questions. MCQ (Multiple Choice Questions with answers about Logical Database Design - General Questions
The entity integrity rule states that:
Options
A : no primary key attribute may be null.
B : no primary key can be composite.
C : no primary key may be unique.
D : no primary key may be equal to a value in a foreign key.
When mapping a many-to-many unary relationship into a relation which of the following is true?
Options
A : One relation is created.
B : Two relations are created.
C : Three relations are created.
D : Four relations are created.
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
Options
A : First normal form
B : Second normal form
C : Third normal form
D : Fourth normal form
A foreign key is which of the following?
Options
A : Any attribute
B : The same thing as a primary key
C : An attribute that serves as the primary key of another relation
D : An attribute that serves no purpose
A transitive dependency is which of the following?
Options
A : A functional dependency between two or more key attributes.
B : A functional dependency between two or more nonkey attributes.
C : A relation that is in first normal form.
D : A relation that is in second normal form.
When mapping a multivalued attribute into a relation which of the following is true?
Options
A : One relation is created.
B : Two relations are created.
C : Three relations are created.
D : Four relations are created.
If no multivalued attributes exist in a relation, then the relation is in what normal form?
Options
A : First normal form
B : Second normal form
C : Third normal form
D : Fourth normal form
A primary key is which of the following?
Options
A : Any attribute
B : An attribute that uniquely identifies each row
C : An attribute that uniquely identifies each column
D : A derived attribute
The relational model consists of:
Options
A : data in the form of tables.
B : data redundancy.
C : operations using non-SQL languages.
D : unorganized data.
When mapping a binary many-to-many relationship into a relation which of the following is true?
Options
A : One relation is created.
B : Two relations are created.
C : Three relations are created.
D : Four relations are created.
Advanced SQL - General Questions more Online Exam Quiz
Data Warehousing - General Questions
Distributed Databases - General Questions
Introduction to Database - General Questions
Introduction to SQL - General Questions
JDBC, Java Server Pages, and MySQL - General Questions
Managing Databases with Oracle - General Questions
SQL Server 2000 - General Questions
Managing Multiuser Databases - General Questions