Click To Get Off-Campus Placement Jobs Info !!!
Capgemini Recruitment Process 2020 – Updated Test Pattern and Selection Process in Details Latest Pattern !!
FREE!!! Capgemini Game based Aptitude Test Questions for Practice

Technical Interview Questions and Answers :: DBMS

    61 / 140

    What is a Phantom Deadlock?
    Answer:

    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.

    Please Login First :

    62 / 140

    What is a checkpoint and when does it occur?
    Answer:

    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.

    Please Login First :

    63 / 140

    What are the different phases of transaction?
    Answer:

    Different phases are
    > Analysis phase
    > Redo Phase
    > Undo phase

    Please Login First :

    64 / 140

    What do you mean by flat file database?
    Answer:

    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.

    Please Login First :

    65 / 140

    What is "transparent DBMS"?
    Answer:

    It is one, which keeps its Physical Structure hidden from the user.

    Please Login First :

    66 / 140

    Brief theory of Network, Hierarchical schemas and their properties
    Answer:

    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.

    Please Login First :
    Answer:

    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.

    Please Login First :

    68 / 140

    What do you mean by Correlated subquery?
    Answer:

    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)

    Please Login First :

    69 / 140

    What are the primitive operations common to all record management systems?
    Answer:

    Addition, deletion, and modification.

    Please Login First :

    70 / 140

    Name the buffer in which all the commands that are typed in are stored
    Answer:

    ‘Edit’ Buffer

    Please Login First :



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.