4 Jul 2014

Smu mba database management system sample paper set four











Question: _______________ is one of the most important considerations of a relational schema.Response:
Database
Anomalies
Attributes
Should have chosen
Storage space
Unit-09-2Mark
Question: A relation schema R is in first normal form ifResponse:
No prime attribute is transitively dependent on the primary key.
There is a set of attributes 'Z' Le x->, z->y is transitive.
Every non-prime attribute A in R is fully functionally dependent on the Primary Key of R.
Should have chosen
Every attribute of R takes only single atomic values.
Question: If every non-prime attribute A in R is fully functionally dependent on the Primary Key of R then the relation R is in which form?Response:
1NF
Should have chosen
2NF
3NF
Boyce codd NF
Question: Normalization is the process of building database structures to store data, becauseResponse:
Has a significant effect on th estorage space o fthe relational schema
Application always depends on the storage media
Should have chosen
Any application ultimately depends on its data structures.
It specifies how the attribute values in a tuple relate to one another.
Question: Whenever we group attributes to form a relation, we assume that a certain meaning is associated with the attributes. This meaning is called ________________Response:
Schema
Should have chosen
Semantics
Tuples
primary keys
Unit-10-1Mark
Question: A transaction is a _________ unit of database processing that includes one or more database access operationsResponse:
Physical
Diagrammatic
Should have chosen
Logical
Flow
Question: A _____________ is an atomic unit comprised of one or more SQL statements.Response:
Tuple
relational attribute
Should have chosen
transaction
DBMS
Question: Match the followingResponse:
Match
Correct Answer
User answer
Feedback

Match
Correct Answer
User answer
Feedback
SELF JOIN
It involves the same table in the join
Used to display rows that do not meet the join condition
incorrect
OUTER JOINS
Used to display rows that do not meet the join condition
It involves the same table in the join
incorrect
SIMPLE EQUI-JOINS
The foreign key of table1 will be made equal to the primary key of table 2
It is possible to build powerful sql programs
incorrect
NESTED QUERIES
It is possible to build powerful sql programs
The foreign key of table1 will be made equal to the primary key of table 2
incorrect
Unit-09-1Mark
Question: A second normal form is based on the concept of __________________.Response:
transitive dependency
Should have chosen
Partial Functional dependency
full functional dependency
semi functional dependent
Question: Improper grouping of attributes has a significant effect on the storage space of the ________Response:
Database
relational attribute
Should have chosen
Relational schema.
DBMS
Question: If many of the attributes do not take any values, we insert _____________ values.Response:
Data
Should have chosen
NULL
Attribute
Schema
Question: _______________ is the process of building database structures to store dataResponse:
Transition
Functional dependencies
Correct
Normalization
Semantics
Question: Third normal form is based on the concept of ________________Response:
functional dependency
full functional dependency
semi functional dependency
Should have chosen
transitive dependency

No comments:

Post a Comment