Interview Questions - DBMS

Why should I learn to solve DBMS technical interview questions?

Learn and practise solving DBMS technical interview questions and answers to enhance your skills for clearing technical interviews, HR interviews, campus interviews, and placement tests.

Where can I get technical DBMS technical interview questions and answers with explanations?

IndiaBIX provides you with lots of fully solved DBMS technical interview questions and answers with a short answer description. You can download DBMS technical interview questions and answers as PDF files or e-books.

How do I answer DBMS technical interview questions from various companies?

You can answer all kinds of DBMS technical interview questions by practising the given exercises (short answer type). You can also find the frequently asked DBMS technical interview questions with answers from various companies, such as TCS, Wipro, Infosys, CTS, IBM, etc.

1.
What are data and information, and how are they related in a database?
Data is recorded facts and figures, and information is knowledge derived from data. A database stores data in such a way that information can be created.

2.
What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application?
Enterprise Resource Planning (ERP) is an information system used in manufacturing companies and includes sales, inventory, production planning, purchasing and other business functions. An ERP system typically uses a multiuser database.

3.
What is a DBMS?
DBMS stands for Database Management System. A DBMS receives requests from applications and translates those requests into actions on a specific database. A DBMS processes SQL statements or uses other functionality to create, process and administer databases.

4.
Why is a database considered to be "self-describing"?
In addition to the users' data, a database contains a description of its own structure. This descriptive data is called "metadata."