DBMS Interview Questions and Answers for Freshers

Question: What is database?
Database is a collection of information which are stored in organised way.


Question: What is DBMS?
Full for of DBMS is Database Management System.
It is Management System which manage the databases and its table.


Question: What are the advantages of using DBMS?

1. Backup and Recovery
2. It contains two-dimensional tables with rows and columns.
3. Integrity constraints
4. Redundancy can be reduced
5. Give Access to User in controlled way.

Question: What are the disadvantage in File Processing System?

1. Data redundancy and inconsistency.
2. Data integrity.
3. Security Problems
4. Data isolation.
5. Difficult in accessing data.

Question:What is Data Model?
A collection of conceptual tools for describing data, data relationships, data semantics & constraints.
Question: What is normalization?
Normalization is the process of organizing tables in such a way that the results are always unambiguous, accurate and fast.


Question: What is BCNF (Boyce-Codd Normal Form)?
A relation schema R is in BCNF if it is in 3NF and satisfies an additional constraint that for every FD X A, X must be a candidate key.


Question: What is RDBMS?
Relational Database Management system (RDBMS) is a database management system (DBMS) that is based on the relational model.


Question: What is SQL?
Structured Query Language is a language designed specifically for communicating with databases to get the required results.


Question: What is a Record in a database?
A record is the collection of values / fields of a specific entity: i.e. an Employee.
It have employee details like employee id,name, email and address etc.


Question: What is Object Oriented model?
This model is based on collection of objects.


Question: What is an Entity?
small independent things.


Question: What is an Entity type?
It is a collection (set) of entities that have same or different attributes.


Question: What is Weak Entity set?
An entity set may not have sufficient attributes to form a primary key.


Question: What is DDL?
Full form of DDL is Data Definition Language.
DDL is a standard for commands that define the different structures in a database.
DDL statements create, modify and remove database objects such as tables, indexes, and users.
Most Common DDL statements are CREATE, ALTER and DROP.


Question: What is Data mining?
Data mining is a process of analyzing current data and summarizing the information in more useful.

Best Related Posts are Following:

1. How to get a list of MySQL user accounts?.
2. SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 2269548 for key PRIMARY.
3. Multiple column ordering in Zend Framework.
4. Mysql Privileges - Types of privileages in MySql - How do I grant privileges in MySQL.
5. Difference Between Primary Key And Unique Key And Foreign Key And Composite Key.
6. Difference Between MyISAM and innoDB - MySQL.
7. MySQL Functions - MySQL tutorial for beginners.
8. mysqlsubqueries examples Scalar Subqueries Row Subqueries Column Subqueries Table Subqueries.
9. Mysql FullText Search Examples.
10. MySQL Constraint Example.
11. MySQL Cascade Example.
12. Mysql-Group-Concat.
13. MySQL Expressions.
14. MySQL Delete Table Example.
15. Replace Table - Update Field, Move Records to another table MySQL.
16. mysql insert syntax - Add records from another table - Copy Table from one table to another.
17. Mysql Update Syntax - Update Multiple Records.
18. What is Mysql.
19. Mysql Console Commands - Export and Import database from command line.
20. MySQL interview Questions and Answers For Experienced.