WorksheetsDBMS Internal 1 - CSE,BMSIT
Total questions: 10
Worksheet time: 6mins
A collection of conceptual tools for describing data, relationships, semantics and constraints is
referred to as ..........
Data Model
E-R Model
DBMS
All of the above
In E-R Diagram, weak entity is represented by.......
Rectangle
Square
Double Rectangle
Circle
Which of the following is a Data Definition Language (DDL) command?
Delete
Insert
Drop
Merge
Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH -> G, A -> BC, B -> CFH, E -> A, F -> EG} is a set of functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R.
How many candidate keys does the relation R have?
3
4
5
6
Which of the following is TRUE?
Every relation in 3NF is also in BCNF
A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R
Every relation in BCNF is also in 3NF
No relation can be in both BCNF and 3NF
Which of the following is used with database?
ATM
Payment gateway
Data Mining
None of the above
Given the following two statements:
S1: Every table with two single-valued
attributes is in 1NF, 2NF, 3NF and BCNF.
S2: AB->C, D->E, E->C is a minimal cover for
the set of functional dependencies
AB->C, D->E, AB->E, E->C.
S1 is TRUE and S2 is FALSE.
Both S1 and S2 are TRUE.
S1 is FALSE and S2 is TRUE.
Both S1 and S2 are FALSE.
A relation between two entities is treated as a single entity is called__________
Aggregation
Specialization
Generalization
None of the above
E-R Modeling technique is a _______
Top-down approach
Bottom-up approach
User-Defined
None of the above
Table A
Id Name Age
----------------
12 Arun 60
15 Shreya 24
99 Rohit 11
Table B
Id Name Age
----------------
15 Shreya 24
25 Hari 40
98 Rohit 20
99 Rohit 11
Table C
Id Phone Area
-----------------
10 2200 02
99 2100 01
Consider the above tables A, B and C. How many tuples does the result of the following SQL query contains?
SELECT A.id
FROM A
WHERE A.age > ALL (SELECT B.age FROM B
WHERE B. name = "arun")
4
3
0
1
