DBMS Sample Test2
30 Questions
| Total Attempts: 670
This test is to test your normalization concepts
Questions and Answers
- 1.Write the candidate keys (type answer in lowercase) Acct_id Cust_id State_code Bal 100 C1 AZ 10000 200 C2 CA 65675 423 C1 MN 45646 111 C3 AZ 456456 100 C6 MN 65675 800 C2 TX 12133 500 C3 IL 123123
- 2.Write the primary key (type answer in lowercase) Acct_id Cust_id State_code Bal 100 C1 AZ 10000 200 C2 CA 65675 423 C1 MN 45646 111 C3 AZ 456456 100 C6 MN 65675 800 C2 TX 12133 500 C3 IL 123123
- 3.The number of Fully FD’s >= No of FD’s in a relation
- A.
True
- B.
False
- 4.When a relation is in 3NF implies the relation does not have any insert anomalies
- A.
True
- B.
False
- 5.Foreign key should be unique
- A.
True
- B.
False
- 6.A relation is in 2NF implies all the determinants should be primary key
- A.
True
- B.
False
- 7.{ C1, C2 } -----> { C3} implies C1, C2 dependent on C3
- A.
True
- B.
False
- 8.No of unique keys >= No of primary keys in a relation
- A.
True
- B.
False
- 9.A NOT NULL constraint can have duplicate values
- A.
True
- B.
False
- 10.C1----> C5 then what is determinant and dependent here?
- A.
C1 Determinant C2 Dependent
- B.
C2 Determinant C1 Dependent
- C.
Both are dependent
- D.
Both are Determinant
- E.
None of the above
- 11.Referential integrity should be maintained for each table in RDBMS
- A.
True
- B.
False
- 12.A relation is in nNF implies it should be in (n-1)NF
- A.
True
- B.
False
- 13.FD is also called left irreducible dependency
- A.
True
- B.
False
- 14.Normal forms applied at the logical level
- A.
True
- B.
False
- 15.If a column is a candidate key then it should be a super key
- A.
True
- B.
False
- 16.If a relation is in 2NF means update anomaly is eliminated
- A.
True
- B.
False
- 17.In a table If a primary key is composite then implies foreign key in that table is also composite
- A.
True
- B.
False
- 18.A table can have more than one foreign keys
- A.
True
- B.
False
- 19.In a relation all functional dependents should become a fully functional dependencies implies
- A.
All the determinants are candidate keys
- B.
All determinants consists of only one column
- C.
The relation is in 3NF
- D.
There are more than one candidate key
- 20.Dependent is Primary key implies
- A.
There are more than one candidate key
- B.
The relation contains full FD's
- C.
There are more than one alternative keys
- D.
There is only one super key
- 21.
![The above relation is in --------------
- ProProfs]( "The above relation is in --------------")
The above relation is in --------------- A.
3NF
- B.
BCNF
- C.
2NF
- D.
None of the above
- 22.
![Is the relation is in 3NF? - ProProfs]( "Is the relation is in 3NF?")
Is the relation is in 3NF?- A.
Yes
- B.
No
- C.
Can't say
- 23.
![What is the attribute/s which acts as both determinant and dependent?(Type your answer in lower case) - ProProfs]( "What is the attribute/s which acts as both determinant and dependent?(Type your answer in lower case)")
What is the attribute/s which acts as both determinant and dependent?(Type your answer in lower case) - 24.Does the below table design contains any insert anomoly movie_id movie_name Director_id Dir_name M1 ABC D1 KKK M2 DEF D2 EEE M3 AAA D1 LLL M4 BBB D3 YYY M5 CCC D5 QQQ M6 DDD D4 MMM M7 EEE D5 PAS
- A.
Yes
- B.
No
- C.
Can'y say
- 25.Ship(BoatId, NbrOfPools, YearMade, Tonage, CompanyId, CompanyName) The only functional dependencies for this table are: BoatId --> NbrOfPools, YearMade, Tonage, CompanyId, CompanyName CompanyId --> CompanyName CompanyName --> CompanyId Which Normal form is the Ship table in?
- A.
1NF
- B.
2NF
- C.
3NF
- D.
BCNF
- E.
Can't say
Back to top