510 questions and answers
Describe various actions of a shift reduce parsers.
Actions of shift-reduce parsers: A shift-reduce parser works by doing some combination of Shift steps and Reduce steps, hence the name.
With suitable examples, show how recovery in a database system can be done using Log Files with
Deferred Update Recovery Also called NO-UNDO/REDO
Consider the relation R={A,B,C,D,E,F,G,H,I,J} and the set of functional dependencies: F={AB → C, A → DE, B → F, F → GH, D → IJ}. Decompose R into 3NF.
A→DE, so AB→BDE (Augmentation) AB→C, so AB→ABC (Reflexivity)
What is the difference between a database and a table? Why are entity integrity and referential integrity important in a database?
Difference between database and a table: A table is an object inside a database. A database has tables of data, views, indexes and programs. A database can have 10 or thousands of tables.
Explain two-phase locking protocol.
In a multiprogramming environment where multiple transactions can be executed simultaneously,
Write short notes on the following:
Armstrong’s Axioms: An inference axiom is a rule that states if a relation satisfies certain Functional Dependencies (FDs) then it must satisfy certain other FDs.
Write short notes on the following:
View Serializability Let S and S0 be two schedules with the same set of transactions. S and S0 are view equivalent if the following three conditions are met:
Describe the wait-die and wound-wait protocols for deadlock prevention. Define three concurrency problems: dirty read, non-repeatable read, phantoms.
We can prevent deadlocks by giving each transaction a priority and ensuring that lower priority transactions are not allowed to wait for higher priority transactions (or vice versa).
What do you mean by input buffering? How is input buffering implemented? What problem can arise implementing input buffering? Give suitable example. What is sentinel? What is its use?
The Lexical Analyzer scans the characters of the source program one at a time to discover tokens.
Write short notes on:
A DBMS is a software package that carries out many different tasks including the provision of facilities to enable the user to access and modify information in the database.
MindStudy - a preparation hub for all the students. The goal is to make it easier for pupils to get better grades on exams.
Copyright © 2025 MindStudy
A product by Shunya Intelliware Solution
(Registered under MSME Uddyam)