Take FREE!! Online Mettl Mock Test to Crack TechM and Other Companies Written Exams.
Get Off-Campus Placement Jobs Info !!!
Practice Tech Mahindra Essay Topics

Technical Interview Questions and Answers :: DBMS

    131 / 143

    What is the difference between cold backup and hot backup?
    Answer:

    Cold backup is a physical backup. During a cold backup, the database is closed and not available to users. All files of the database are copied (image copy). The data files do not change during the copy so the database is in sync upon restore.

    Used when: Service level allows for some down time for backup

    Hot backup is a physical backup. In a hot backup, the database remains open and available to users. All files of the database are copied (image copy). There may be changes to the database as the copy is made and so all log files of changes being made during the backup must be saved too. Upon a restore, the changes in the log files are reapplied to bring the database in sync.

    Used when: A full backup of a database is needed Service level allows no down time for the backup

    Please Login First :

    132 / 143

    What is hot and cold back up?
    Answer:

    A cold backup also called an offline backup, is a database backup during which the database is offline and not accessible to update. This is the safest way to back up because it avoids the risk of copying data that may be in the process of being updated.

    Please Login First :

    133 / 143

    What is a cumulative backup?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    134 / 143

    How is Durability maintained in Database?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    135 / 143

    What are the other storage thing before RDBMS?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    136 / 143

    What is concurrency control and what is its objective?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    137 / 143

    How can concurrency lead to inconsistency?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    138 / 143

    What is meant by concurrency control?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    139 / 143

    What is data concurrency?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    140 / 143

    Which one is better - Java with DB or PL/SQL and why?
    Answer:

    No Discussion on this question yet!

    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 Technical Interview Questions and Answers - Q4Interveiw.com 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.