Technical Interview Questions and Answers :: DBMS
11 / 143
Physical level
12 / 143
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.
13 / 143
A collection of conceptual tools for describing data, data relationships data semantics and constraints.
14 / 143
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.
15 / 143
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.
16 / 143
It is a 'thing' in the real world with an independent existence.
17 / 143
It is a collection (set) of entities that have same attributes.
18 / 143
It is a collection of all entities of a particular entity type in the database.
19 / 143
The collections of entities of a particular entity type are grouped together into an entity set.
20 / 143
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.
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.