Thursday 15 October 2015

DBMS Interview Questions and Answers for Freshers

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.