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

    11 / 143

    What is Data Independence?
    Answer:

    Physical level

    Please Login First :

    12 / 143

    What is a view? How it is related to data independence?
    Answer:

    A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that directly represents the view instead a definition of the view is stored in data dictionary.
    Growth and restructuring of base tables are not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

    Please Login First :
    Answer:

    A collection of conceptual tools for describing data, data relationships data semantics and constraints.

    Please Login First :
    Answer:

    This data model is based on the real world that consists of basic objects called entities and of a relationship among these objects. Entities are described in a database by a set of attributes.

    Please Login First :

    15 / 143

    What is Object Oriented model?
    Answer:

    This model is based on a collection of objects. An object contains values stored in instance variables within the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.

    Please Login First :

    16 / 143

    What is an Entity?
    Answer:

    It is a 'thing' in the real world with an independent existence.

    Please Login First :

    17 / 143

    What is an Entity type?
    Answer:

    It is a collection (set) of entities that have same attributes.

    Please Login First :

    18 / 143

    What is an Entity set?
    Answer:

    It is a collection of all entities of a particular entity type in the database.

    Please Login First :

    19 / 143

    What is an Extension of entity type?
    Answer:

    The collections of entities of a particular entity type are grouped together into an entity set.

    Please Login First :

    20 / 143

    What is Weak Entity set?
    Answer:

    An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and the primary key of its parent entity, then it is said to be Weak Entity set.

    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, DBMS Interview Question and Answers 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.