Click To Get Off-Campus Placement Jobs Info !!!
FREE!!! Latest Nagarro FULL Aptitude Mock Test for Practice
Practice 5+ Mettl Aptitude Mock Test

Technical Interview Questions and Answers :: DBMS

    31 / 140

    What is Data Storage - Definition Language?
    Answer:

    The storage structures and access methods used by database system are specified by a set of definition in a special type of DDL called data storage definition language

    Please Login First :

    32 / 140

    What is DML (Data Manipulation Language)?
    Answer:

    This language that enables user to access or manipulate data as organized by the appropriate data model.
    * Procedural DML or Low level: DML requires a user to specify what data are needed and how to get those data.
    * vNon-Procedural DML or High level: DML requires a user to specify what data are needed without specifying how to get those data.

    Please Login First :

    33 / 140

    What is DML Compiler?
    Answer:

    It translates DML statements in a query language into low-level instruction that the query evaluation engine can understand.

    Please Login First :

    34 / 140

    What is Query evaluation engine?
    Answer:

    It executes low-level instruction generated by compiler.

    Please Login First :

    35 / 140

    What is DDL Interpreter?
    Answer:

    It interprets DDL statements and record them in tables containing metadata.

    Please Login First :

    36 / 140

    What is Record-at-a-time?
    Answer:

    The Low level or Procedural DML can specify and retrieve each record from a set of records. This retrieve of a record is said to be Record-at-a-time.

    Please Login First :

    37 / 140

    What is Set-at-a-time or Set-oriented?
    Answer:

    The High level or Non-procedural DML can specify and retrieve many records in a single DML statement. This retrieve of a record is said to be Set-at-a-time or Set-oriented.

    Please Login First :

    38 / 140

    What is Relational Algebra?
    Answer:

    It is procedural query language. It consists of a set of operations that take one or two relations as input and produce a new relation.

    Please Login First :

    39 / 140

    What is Relational Calculus?
    Answer:

    It is an applied predicate calculus specifically tailored for relational databases proposed by E.F. Codd. E.g. of languages based on it are DSL ALPHA, QUEL.

    Please Login First :

    40 / 140

    How does Tuple-oriented relational calculus differ from domain-oriented relational calculus
    Answer:

    The tuple-oriented calculus uses a tuple variables i.e., variable whose only permitted values are tuples of that relation. E.g. QUEL
    The domain-oriented calculus has domain variables i.e., variables that range over the underlying domains instead of over relation. E.g. ILL, DEDUCE.

    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 and answers for tcs 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.