WB JECA MCA Database Management Systems Previous Year Question Paper and Solution with PDF

Aspire's Library

A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations

WB JECA MCA
Previous Year Questions

WB JECA MCA
Previous Year Questions
WB JECA MCA

WB JECA MCA Previous Year Questions (PYQs)

WB JECA MCA Database Management Systems PYQ

Qus : 1 WB JECA MCA PYQ

Which key can be derived directly from a Super Key?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

A Candidate Key is derived from a Super Key, and then one candidate key is chosen as the Primary Key.

Qus : 2 WB JECA MCA PYQ

Relational Algebra is ____________ query language.

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

Relational Algebra is a procedural query language because it specifies the operations to obtain the result.

Qus : 3 WB JECA MCA PYQ

In case of union compatibility, ____________

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

For union compatibility, two relations must have the same set of attributes and domains.

Qus : 4 WB JECA MCA PYQ

Which option cannot be used with “ALTER table” command in SQL ?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

ALTER TABLE can ADD, MODIFY, and DROP columns, but DELETE is a DML operation, not part of ALTER.

Qus : 5 WB JECA MCA PYQ

Third normal form (3NF) removes ____________ from a relation.

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

3NF eliminates transitive dependencies.

Qus : 6 WB JECA MCA PYQ

Which option is not a step for query processing ?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

Metadata organization is not a query processing step.

Qus : 7 WB JECA MCA PYQ

Which of the following option is not a transaction state ?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

Transaction states are Active, Partially committed, Failed, Aborted, Terminated. There is no "Updated" state.

Qus : 8 WB JECA MCA PYQ

Which of the following option does not have any partial functional dependencies ?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2023 PYQ

Solution

2NF removes partial dependency.

Qus : 9 WB JECA MCA PYQ

Relational calculus is a

(A) Procedural language

(B) Non-procedural language

(D) High-level language

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Relational Algebra is procedural (it specifies how to obtain the result).
Relational Calculus is non-procedural (it specifies what to obtain, not how).

Therefore, Relational Calculus is a Non-procedural language.

Correct Answer: (B) Non-procedural language

Qus : 10 WB JECA MCA PYQ

Which of the following should not have transitive dependency?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution:
- 3NF (Third Normal Form) removes transitive dependency.
- Hence, it should not have transitive dependency.
Answer = (C) Third normal form

Qus : 11 WB JECA MCA PYQ

In an ER diagram, an entity set is represented by a

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: Entity sets are rectangles; Attributes = ellipses; Relationships = diamonds.
Answer: (A) Rectangle

Qus : 12 WB JECA MCA PYQ

Given an unsorted array where each element is at most k distance from its position in a sorted array. Which sorting algorithm can be easily modified for this and what is its time complexity?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: A k-sorted array can be efficiently sorted using a min-heap of size k, yielding O(n log k) time.
Answer: (B) Heap Sort with O(n log k)

Qus : 13 WB JECA MCA PYQ

In a relational database, what does the term "ACID" stand for?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: ACID properties are Atomicity, Consistency, Isolation, Durability. Option (A) is closest (Integrity ~ Isolation).
Answer: (A) Atomicity, Consistency, Integrity, Durability

Qus : 14 WB JECA MCA PYQ

Which of the following statements about primary key in a database table is true?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: A table can have only one primary key, it cannot contain NULLs. Its main property: uniquely identifies each record.
Answer: (B) A primary key uniquely identifies each record in a table

Qus : 15 WB JECA MCA PYQ

Numbers 7, 5, 1, 8, 3, 6, 0, 9, 4, 2 are inserted in that order into an initially empty binary search tree. The tree uses usual ordering. What is the in-order traversal sequence?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: In-order traversal of a BST gives the sorted order of keys ⇒ 0 to 9 ascending.
Answer: (C) 0, 1, 2, 3, 4, 5, 6, 7, 8, 9

Qus : 16 WB JECA MCA PYQ

Which of the following is popular for applications such as storage of log files in a DBMS since it offers the best write performance ?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: RAID 0 (striping) provides maximum write throughput (no redundancy), often used for logs/temp data.
Answer: (A) RAID level 0

Qus : 17 WB JECA MCA PYQ

Which of the following statement is correct ?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: For a BST, only in-order traversal yields the keys in sorted order.
Answer: (B)

Qus : 18 WB JECA MCA PYQ

What is the result of postfix expression ab*c+d+ where a=2, b=2, c=3, d=4 ?

1
2
3
4
Go to Discussion

WB JECA MCA Previous Year PYQ WB JECA MCA JECA MCA 2024 PYQ

Solution

Solution: Postfix: a*b*c + d + ⇒ 2*2*3 + 4 = 12+4 = 16 (check carefully). Actually: ab* c + d + → (a*b)+c+d.
2*2+3+4=11 (typo). But correct reading: (a*b*c)+d= (2*2*3)+4=16. Options given: 16 present.
Answer: (A) 16

WB JECA MCA

Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More

WB JECA MCA

Online Test Series,
Information About Examination,
Syllabus, Notification
and More.

Click Here to
View More

Ask Your Question or Put Your Review.

Please provide more information - at least 10 characters

Feedback

Info.

Information

Aspire's Library

WB JECA MCA Previous Year Questions (PYQs)

WB JECA MCA Database Management Systems PYQ

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

Solution

WB JECA MCA

WB JECA MCA

Info.

Confirm Delete

Edit