Dbms Interview Questions And Answers

Dbms Interview Questions list for experienced

  1. When is a database in 1NF?
  2. When is a database in 2NF?
  3. When is a database in 3NF?
  4. When is a database in BCNF?
  5. What are the 1NF AND 2NF?
  6. What are relationships and what are they?
  7. What is DBMS used for? brief explanation
  8. Name the various types of relationships in the Database.
  9. What are the common advantages of Normalizing data?
  10. Name some DDL Commands.
  11. Define sub-query in simple terms.
  12. List Disadvantages of query in DBMS.
  13. What are some phases in transaction?
  14. What is normalization of database? Brief
  15. List Different advantages of DBMS(Database management System).

Dbms interview questions and answers on advance and basic Dbms with example so this page for both freshers and experienced condidate. Fill the form below we will send the all interview questions on Dbms also add your Questions if any you have to ask and for apply in Dbms Tutorials and Training course just send a mail on info@pcds.co.in in detail about your self.

Top Dbms interview questions and answers for freshers and experienced

What is Dbms ?

Answer :

Questions : 1 :: When is a database in 1NF?

A database is said to be in first normal form, or 1NF if it has a candidate key present. A default relationaal Database or RDBMS is in 1NF. But, in the first normal form, level of redundancy is too...View answers

Questions : 2 :: When is a database in 2NF?

As, it is an advancement in 1NF, so we can say that the level of redundancy has reduced to some extent. As we proceed towards the higher normal forms, the redudancy is lowered. If we say that a...View answers

Questions : 3 :: When is a database in 3NF?


As we proceed to higher normal forms, the redudancy levels are reduced. If it is said that a given relational schema R is in present in 3NF, it is considered that the relation satisfies the...View answers

Questions : 4 :: When is a database in BCNF?

As we proceed to higher normal forms, the redudancy levels are reduced. At this level, there are very less redundancy present. If a given relational schema R is in present in BCNF, then it has the...View answers

Questions : 5 :: What are the 1NF AND 2NF?

1NF:  This should remove all the duplicate columns from the table. Creation of tables for the related data and identification of unique columns.   2NF: Meeting all the requirements of...View answers

Questions : 6 :: What are relationships and what are they?


Database Relationship is defined as the connection between the tables in the database. One To One One To Many Many To One Many To...View answers

Questions : 7 :: What is DBMS used for? brief explanation

DBMS is simply Database Management System used for dealing with data. To store, retrieve data DBMS is used. It makes things easier for users for handling...View answers

Questions : 8 :: Name the various types of relationships in the Database.

Various type of relationships are: 1. One to One 2. One to many 3. Many to many 4. Many to...View answers

Questions : 9 :: What are the common advantages of Normalizing data?


There are many advantages of normalizing data, Few of them are listed as follow: Avoid Duplicate entries Saves a lot of storage Improve...View answers

Questions : 10 :: Name some DDL Commands.

CREATE: Helps in creating database, table, row and col. ALTER: Helps to alter the existing entities. DROP: It delete current table, row,...View answers

Questions : 11 :: Define sub-query in simple terms.

A query inside query is what is called a subquery. It is the same as the nested function is there.

Questions : 12 :: List Disadvantages of query in DBMS.

No indexes stored procedures are compiled in excess

Questions : 13 :: What are some phases in transaction?

Phases in transaction process are: Analysis Phase Redo Phase Undo...View answers

Questions : 14 :: What is normalization of database? Brief

Normalization is a process of organizing data in a database efficiently. Two goals are: To eliminate redundant data. ensure data dependencies make sense.   These both are very important as...View answers

Questions : 15 :: List Different advantages of DBMS(Database management System).

The list of several advantage of DBMS: Improved data security Better data integration Minimized data inconsistency Improved data access Improved decision making Increased end user...View answers
More Question

Ask your interview questions on Dbms

Write Your comment or Questions if you want the answers on Dbms from Dbms Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---