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.

Regular Expression Interview Questions and Answers

Question: What is the mean of Regular Expressions?
Regular Expressions is a pattern which is used to search string like "Search name start with a" OR "Search name end with z".


Question: What is use of Regular Expressions?
It is used to Search Simple String OR Complex String.
For Example:
Search all name start with a.
Search all names end with a


Question:What the mean of different symbols like ^ $ in Regular Expression?
^a Search all string which start with "a".
a$ Search all string which end with "a".
[a-z0-9]{2,5} there should be 2-5 string which can be a-z and 0-9 characters.
[a-z]{2,5} there should be 2-5 string which are a-z characters.
[0-9]{2,5} there should be 2-5 string which are 0-9 characters.


Question: What is Regular Expression to validate Email?

^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$

Question: Write a Regular expression to match line that doesn't contain a word?
To find a word "FINDME" in String.

^((?!FINDME).)*$

Question: How do I remove all non alphanumeric characters from a string?
Suppose you want to remove all character except a-z, 0-9 and "space".

[^a-zA-Z0-9\s] 

Question: Simple regular expression for a decimal with a precision of 2

\d+(\.\d{1,2})?

Best Related Posts are Following:

1. Regular Expressions PHP/Javascript.
2. Regular Expression.