00:00:00
1. Which one is not a logical database structure:
Chain
Tree
Relational
Network
None of the above
2. Initial state of transaction
Committed
Failed
Aborted
Partially committed
Active
3. In RDBMS, Data is presented as a collection of ............
Entity
Table
Attribute
Relation
None of these
4. The rule that always generate true dependencies is called
referential rule
inferential rule
closure rule
reflexive rule
None of these
5. Which one is not a basic property of transaction:
Activity
Atomicity
Isolation
Durability
Consistency
6. The normal form which is based on the transitive dependency is
third normal form
second normal form
first normal form
fourth normal form
none of the above
7. BCNF is an extended form of............
1NF
2NF
3NF
4NF
None of the above
8. In the __________ normal form, a composite attribute is converted to individual attributes.
second
first
fourth
third
None of these
9. How many rules are there is E.F. Codd's Rule?
10
9
12
13
11
10. Which of the SQL statements is correct?
SELECT Username, Password FROM Users
SELECT Username AND Password FROM Users
SELECT Username, Password WHERE Username = 'user1'
SELECT Username AND Password FROM Users WHERE Username = 'user1'
None of these