| 1 |
Identify the factor which enforces a relation in 3NF? |
Every non-key attribute is fully functionally dependent on primary key
Every non-key attribute is partially dependent on super key
The domain of attribute must include only atomic values.
Every non-key attribute is non-transitively dependent on primary key.
|
| 2 |
Which of the following concepts is applicable with respect to 2NF?
|
Full functional dependency
Any kind of dependency
Transitive dependency
Non-transitive dependency
|
| 3 |
A superkey that does not contain a subset of attributes that is itself a superkey is called a ____. |
candidate key
primary key
superkey
secondary key
|
| 4 |
A collection of concepts that can be used to describe the structure of a database |
Database
DBMS
Data model
Data
|
| 5 |
A collection of related data is
|
Logical model
Database
Data
Relational model
|
| 6 |
Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a
relationship type:
Select the correct statement among the following on the above diagram |
The relationship type Y is of cardinality ratio 1 : N
The diagram depicts existence dependencies
The participation of X in the Y relationship type is total
The participation of Z in the Y relationship type is partial.
|
| 7 |
Which of the following is INCORRECT statement concerning the database design process? |
During requirements collection and analysis phase, one can gather the data requirements of database
users.
By referring to a high level data model, it is possible to understand the data requirements of the users,
entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design
or data model mapping
During the logical design phase of internal storage structures, access paths and file organization for
the database files are specified.
|
| 8 |
Which of the following is correct? |
The relation Interview is in 3NF
The relation Interview is in BCNF.
The FD3 violates 3NF.
The FD2 violates 2NF
|
| 9 |
Which of the following constraints enforces referential integrity? |
FOREIGN KEY
CHECK
PRIMARY KEY
UNIQUE
|
| 10 |
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring
minimum data loss?
Select correct option: |
User accessible catalog
Data processing
Recovery service
Authorization service
|
.gif)
Home
News
Colleges
Courses
Admission
Lectures
Online Test
Past Papers
Date Sheets
Results
Study Abroad
Jobs
Tutors
More
Apps
