DBMS - Interview Questions and Answers
Why DBMS Interview Questions?
In this section you can learn and practice interview questions based on "DBMS" and improve your skills in order to face the interview, competitive examination and various entrance tests (CAT, GATE, GRE, MAT, Bank Exam, Railway Exam etc.) with full confidence.
Where can I get DBMS interview questions and answers with explanation?
IndiaBIX provides you lots of fully solved DBMS interview questions and answers with Explanation. All students, freshers can download DBMS quiz questions with answers as PDF files and eBooks. Solved examples with detailed answer description, explanation are given and it would be easy to understand. View the solution for the problems with feel and good user interface; easily go through all questions and answers.
How to answer DBMS interview questions?
You can easily answer the interview questions based on DBMS by practicing the exercises given below.
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.
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.
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.
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."
Who is E.F. Codd, and why is he significant in the development of modern database systems?
While working at IBM, E.F. Codd created the relational database model. A paper he published in 1970 presented his ideas to the world at large. His work is the foundation for most of the DBMSs currently in use, and thus forms the basis for database systems as we know and use them today.
What is SQL, and why is it important?
SQL stands for Structured Query Language, and is the most important data processing language in use today. It is not a complete programming language like Java or C#, but a data sublanguage used for creating and processing database data and metadata. All DBMS products today use SQL.