Technical Interview Questions and Answers :: DBMS
In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to identify deadlocks that do not really exist. Such situations are called phantom deadlocks and they lead to unnecessary aborts.
A Checkpoint is like a snapshot of the DBMS state. By taking checkpoints, the DBMS can reduce the amount of work to be done during the restart in the event of subsequent crashes.
Different phases are
> Analysis phase
> Redo Phase
> Undo phase
It is a database in which there are no programs or user access languages. It has no cross-file capabilities but is user-friendly and provides user-interface management.
It is one, which keeps its Physical Structure hidden from the user.
Network schema uses a graph data structure to organize records example for such a database management system is CTCG while a hierarchical schema uses a tree data structure example of such a system is IMS.
A query with respect to DBMS relates to user commands that are used to interact with a database. The query language can be classified into data definition language and data manipulation language.
Subqueries, or nested queries, are used to bring back a set of rows to be used by the parent query. Depending on how the subquery is written, it can be executed once for the parent query or it can be executed once for each row returned by the parent query. If the subquery is executed for each row of the parent, this is called a correlated subquery.
A correlated subquery can be easily identified if it contains any references to the parent subquery columns in its WHERE clause. Columns from the subquery cannot be referenced anywhere else in the parent query. The following example demonstrates a non-correlated subquery.
E.g. Select * From CUST Where '10/03/1990' IN (Select ODATE From ORDER Where CUST.CNUM = ORDER.CNUM)
Addition, deletion, and modification.
Database Management System(DBMS) is an important subject for Freshers and Experienced candidates, Who are looking to grab a job as a Database Developer or Administrator. Practice the frequently Asked DBMS Interview Questions Basic, DBMS SQL Interview Questions asked at Freshers and Experienced level. Most of the listed questions here have been previously asked during the technical rounds in IT companies. You can test your SQL database knowledge by solving these questions and compare your chances of getting the job with a top IT company.
Go through the basics of Database Management System before the interview process. Here, listed DBMS interview questions are Frequently asked during an Interview with different companies like Wipro, Accenture, TCS, Oracle, CTS, Adobe, TechM.
You can Filter the question set by the company name easily. If you are not sure about a specific answer, you can easily click and read the answer along with the explanation. So, check these SQL Technical Interview Questions and Answers to prepare for your dream job.