Placement papers on Database - Set 4

Placement papers on Database - Set 4

1. A relation scheme is said to be in ______________ form if the values in the domain of each attribute of the relation are atomic ?

Unnormalized
First Normal
BoyceCODD
None of these
View Answer / Hide Answer


2. A second Normal form does not permit ______________ dependency between a non prime attribute and the relation key ?

Partial
Multi
Functional
Valued
View Answer / Hide Answer


3. A relation scheme is in ____________ if it is in the 1NF and if all non key attributes are fully functionally dependent on the primary key ?

First Normal Form
Second Normal Form
Boyce Codd Normal Form
Fourth Normal Form
View Answer / Hide Answer


4. A generalization of the Boyce Codd Normal form to relation schemes which includes the multivalued dependencies is called ?

Second Normal Form
Third Normal Form
Fourth Normal Form
Fifth Normal Form
View Answer / Hide Answer


5. 5 NF is related to ?

Functional dependency
Multivalued dependency
Join dependency
None of these
View Answer / Hide Answer


6. Project join Normal form is also referred to as ?

Second Normal Form
Third Normal Form
Fourth Normal Form
Fifth Normal Form
View Answer / Hide Answer


7. The compiled form of the definition is known as ?

Data Dictionary
Directory
System catalog
All of above
View Answer / Hide Answer


8. Once a sequence is created, it is documented in the ?

Database
Datatable
Data Dictionary
Data Document
View Answer / Hide Answer


9. In relational schema, each tuple is divided into fields called ?

Relations
Domains
Queries
All of above
View Answer / Hide Answer


10. A logical schema ?

is the entire database
is a standard way of organizing information into accessible parts
describes how data is actually stored on disk
All of above
View Answer / Hide Answer