Name the various types of relationships in the Database.
What are the common advantages of Normalizing data?
Name some DDL Commands.
Define sub-query in simple terms.
List Disadvantages of query in DBMS.
What are some phases in transaction?
What is normalization of database? Brief
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
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