DBMS Sample Test2

30 Questions | Attempts: 675
Share
Please wait...
Question 1 / 30
0 %
0/100
Score 0/100
1.
What is the attribute/s which acts as both determinant and dependent?
(Type your answer in lower case)



Submit
Please wait...
About This Quiz
DBMS Sample Test2 - Quiz

This test is to test your normalization concepts

Tell us your name to personalize your report, certificate & get on the leaderboard!
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
Submit
3.     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
Submit
4. A relation is in  nNF implies it should be in (n-1)NF   
Submit
5. Normal forms applied at the logical level        
Submit
6. A table can have more than one foreign keys
Submit
7. Referential  integrity should be maintained for each table  in RDBMS      
Submit
8. If a column is a candidate key then it should be a super key
Submit
9. No of unique keys >= No of primary keys in a relation 
Submit
10. A NOT NULL constraint can have duplicate values 
Submit
11. Foreign key should be unique          
Submit
12. The number of Fully FD’s >= No of FD’s   in a relation     
Submit
13. { C1, C2 } -----> { C3}  implies C1, C2  dependent on C3  
Submit
14.      C1----> C5  then what is determinant and dependent here?
Submit
15.
 Is the relation is in 3NF?

Submit
16. In a table If a primary key is composite then implies foreign key in that table is also composite
Submit
17. FD is also called left irreducible dependency      
Submit
18. 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
Submit
19. A relation is in 2NF implies all the determinants should be primary key
Submit
20. 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?
Submit
21. Dependent  is Primary key  implies
Submit
22. If a relation is in 2NF means update anomaly is eliminated
Submit
23.       The above relation is in --------------      
Submit
24. You are given the table below for a relation R(A,B,C,D,E). You do not know the functional dependencies for this relation. A B C D E ’a’ 122 1 ’s1’ ’a’ ’e’ 236 4 ’e2’ ’b’ ’a’ 199 1 ’b5’ ’c’ ’b’ 213 2 ’z8’ ’d’

Suppose this relation is decomposed into the following two tables: R1(A,B,C,D) and R2(A,C,E). Is this decomposition lossless?
Submit
25. You are given the following functional dependencies for the ”EMPLOYEE” relation. Explain whether the relation ”EMPLOYEE” is BCNF and 3NF? Database: EMPLOYEE(ssn, first-name, last-name, address, date-joined, supervisor-ssn) DEPARTMENT(dept-no, name, manager-ssn) WORKS-IN(employee-ssn, dept-no) INVENTORY(dept-no, item-id, quantity) ITEMS(item-id, item-name, type) Foreign keys: 1. EMPLOYEE.supervisor-ssn and WORKS-IN.employee-ssn point to EMPLOYEE.ssn. 2. WORKS-IN.dept-no and INVENTORY.dept-no point to DEPARTMENT.dept-no. 3. INVENTORY.item-id points to ITEMS.item-id.  
Submit
26. Employee(EmpId, EmpSSNO, EmpName, EmpAddress, EmpSalary, EmpAge) EmpId --> EmpSSNO, EmpName, EmpAddress, EmpSalary, EmpAge
EmpSSNO --> EmpId, EmpName, EmpAddress, EmpSalary, EmpAge Which Normal form is the Employee table in?
Submit
27. In a relation all functional dependents should become a fully functional dependencies implies
Submit
28. Books(Title, Author, YrPub, Publisher) Title --> Author, YrPub, Publisher
  Sample Data
Title              Author    YrPub  Publisher
Cooking For Fun    H Clark   2001   Acme Press
Home Repair Cheap  T Rich    2000   Basic Books
Fix up your car    A Ford    1998   Acme Press
Training Goldfish  E Ward    2001   Cooper Ltd
Cooking Survival   H Clark   2001   Acme Press
Selling Your Home  T Rich    1999   Basic Books
  Which Normal form is the Books table in?
Submit
29. When a relation is in 3NF implies the relation does not have any insert anomalies 
Submit
30. Cars(Vin, Make, Style, Price, Year, Color) Vin --> Make, Style, Price, Year, Color Sample Data
Vin          Make   Style      Price Year  Color
1FD56GH8901X Ford   SUV       55,000 1965  Red
1HC21KQ0733G Chevy  Sports    18,200 1998  Green
3AS88JV9203K Dodge  Truck     13,200 1997  Silver
4PL72XD5431M Ford   Truck      5,500 1996  Blue
8BE24RU7385Y Ford   Sedan      5,500 1996  Blue
7JU69TD2485R Dodge  SUV       18,200 1998  Black
0LF83SA6540Z Dodge  Sedan        500 1990  Rust
  Which Normal form is the Cars table in?
Submit
View My Results

Quiz Review Timeline (Updated): Jul 30, 2011 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jul 30, 2011
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 23, 2010
    Quiz Created by
    Sudha_test
Cancel
  • All
    All (30)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
What is the attribute/s which acts as both determinant and...
Write the primary  key (type answer in lowercase) ...
    Write the candidate keys (type answer in...
A relation is in  nNF implies it should be in...
Normal forms applied at the logical...
A table can have more than one foreign keys
Referential  integrity should be maintained for each table...
If a column is a candidate key then it should be a super key
No of unique keys >= No of primary keys in a relation 
A NOT NULL constraint can have duplicate values 
Foreign key should be...
The number of Fully FD’s >= No of FD’s   in a...
{ C1, C2 } -----> { C3}  implies C1, C2  dependent...
     C1----> C5  then what is determinant...
 Is the relation is in 3NF?
In a table If a primary key is composite then implies foreign key in...
FD is also called left irreducible...
Does the below table design contains any insert anomoly  ...
A relation is in 2NF implies all the determinants should be primary...
Ship(BoatId, NbrOfPools, YearMade, Tonage, CompanyId, CompanyName) ...
Dependent  is Primary key  implies
If a relation is in 2NF means update anomaly is eliminated
  ...
You are given the table below for a relation R(A,B,C,D,E). You do not...
You are given the following functional dependencies for the...
Employee(EmpId, EmpSSNO, EmpName, EmpAddress, EmpSalary, EmpAge) ...
In a relation all functional dependents should become a fully...
Books(Title, Author, YrPub, Publisher) ...
When a relation is in 3NF implies the relation does not have any...
Cars(Vin, Make, Style, Price, Year, Color) ...
Alert!

Advertisement