Database interview questions for both freshers and experienced are based on the basics.
They may include the following questions.
QUESTION #1: what is data?
A data is a collection of raw facts and figures. It is a set of quantitative and qualitative values.
QUESTION #2: What is database?
A database is a set of organised data. This data can be updated, stored and retrieved.
QUESTION #3: What is database management system?
A database management system is a software that defines a database. It stores data, supports query
language, produces reports and creates data entry screens.
QUESTION # 4: What are the benefits of DBMS?
The benifits of DBMS includes minimal data duplication, data consistency, integration of data, sharing of data, enforcement of standards, ease of application development, data independency.
QUESTION #5 : What is the purpose of normalisation?
The very purpose of Normalisation is to convert raw-data to allow the user to create set of tables and columns and avoiding duplicate attributes.
QUESTION #6: What are the components of dbms?
DBMS need data based engine, data dictionary, query processor, Report writer, Form generator and application generator.
QUESTION #7: What is SQL?
SQL refers to structured Query Language. It is a language specially designed for DBMS.
QUESTION #8 :What is a table?
A table is a systematic collection of records. For instance employee table, student table etc.
QUESTION #9 : What is RDBMS?
RDBMS is an abbreviated form of Relational Database Management System. It is relational based DBMS. The data from RDBMS can be accessed using SQL.
QUESTION #10: What are various SQL statements?
There are three main SQL statements namely
1. Data definition Language
2. Data Manipulation Language
3. Data Control Language.
1. Data definition Language
2. Data Manipulation Language
3. Data Control Language.
These basics may help you to answer database interview questions.
EmoticonEmoticon