Database Management Systems Expected MCQ | UGC NET Computer Science Paper 2 | Sandeep Sir | Part-1
Database Management Systems Expected MCQ | UGC NET Computer Science Paper 2 | Sandeep Sir | Part-1
☑ WhatsApp -- 7049922693
☑ Course Registration link: https://www.bsiacademy.in/courses/PAP...
☑ Telegram Channel (Computer Science) link: https://t.me/bsiacademy_cse
☑ Telegram Group (Computer Science) link: https://t.me/joinchat/VOjdUC2QA7vzwQw8
☑[email protected]
☑ Subscribe BSI Academy Computer Science:
Computer Science: / @computerscienceplus
We have discussed following 10 multiple choice questions in this video:
1. Let R (A, B, C, D, E, F) be a relational schema with the following functional dependencies:
C → F, E → A, EC → D and A → B
Which of the following is a key for R?
1. CD
2. EC
3. AE
4. AC
2. Which of the following is/are true with reference to ‘view’ in DBMS?
(a) A ‘view’ is a special stored procedure executed when certain event occurs.
(b) A ‘view’ is a virtual table, which occurs after executing a pre-compiled query.
Code:
(1) Only (a) is true
(2) Only (b) is true
(3) Both (a) and (b) are true
(4) Neither (a) nor (b) are true
3. Which of the following statement is correct, according to the following instance of the relational schema R(X, Y, Z)?
X Y Z
1 1 a
1 1 a
2 1 b
3 2 b
1. X → Y, Z → X
2. Y → Z, Z → X
3. X → Y, X → Z
4. Y → X, X → Z
4. ________ command is used to remove a relation from an SQL database.
1. Update table
2. Remove table
3. Delete table
4. Drop table
5. Identify the correct operation which produces the below given output based on two relations R1 and R2.
R1:
Name Class
a1 9
b1 5
c1 6
d1 11
R2:
Name Class
b1 5
f1 8
Output:
Name Class
b1 5
Choose the correct answer from the options below:
1. R1 ∩ R2
2. R1 – R2
3. R1 – (R1 – R2)
4. R1 U R2
6. Match List I with List II:
List - I List - II
(A) BCNF (I) It removes multivalued dependency
(B) 3 NF (II) It is not always dependency preserving
(C) 2 NF (III) It removes transitive dependency
(D) 4 NF (IV) It removes partial functional dependency
Choose the correct answer from the options given below:
1. (A) - (III), (B) - (II), (C) - (IV), (D) - (I)
2. (A) - (II), (B) - (IV), (C) - (I), (D) - (III)
3. (A) - (II), (B) - (III), (C) - (IV), (D) - (I)
4. (A) - (II), (B) - (I), (C) - (IV), (D) - (III)
7. A transaction may be in one of the following states during its execution life cycle in concurrent execution environment.
A. FAILED
B. TERMINATED
C. PARTIALLY COMMITTED
D. COMMITTED
E. ACTIVE
Given a transaction in active state during its execution, find its next transitioned state from the options given below:
1. A only
2. Either A or C only
3. C only
4. D only
8. Two concurrent executing transactions T1 and T2 are allowed to update same stock item say ‘A’ in an uncontrolled manner. In such scenario, following problems may occur:
(a) Dirty read problem
(b) Lost update problem
(c) Transaction failure
(d) Inconsistent database state
Which of the following option is correct if database system has no concurrency module and allows concurrent execution of above two transactions?
(1) (a), (b) and (c) only
(2) (c) and (d) only
(3) (a) and (b) only
(4) (a), (b) and (d) only
9. With respect to relational algebra, which of the following operations are included from mathematical set theory?
(a) Join
(b) Intersection
(c) Cartesian product
(d) Project
(1) (a) and (d)
(2) (b) and (c)
(3) (c) and (d)
(4) (b) and (d)
10. In relational databases, if relation R is in BCNF, then which of the following is in BCNF, then which of the following is true about relation R?
1. R is in 4NF
2. R is not in 1NF
3. R is in 2NF and not in 3NF
4. R is in 2NF and 3NF