What is joins in DBMS ?
DBMS join is a binary operation that allows to combine join product and selecting in one single statement. If data needs to...
What is modification anomalies in DBMS ?
There are 3 types of Data Modification Anomalies: Insertion Anomaly: When one cannot insert a tuple into a relationship due...
What is database architecture in DBMS ?
Data Base Architecture: A database architecture is represented as DBMS Design. Helps to design, develop, implement and...
What is the concept of ACID properties in DBMS ?
ACID stands for Atomicity, Consisency, Isolation, and Durbility property. Multiple users can share data in a safe and secure...
What is the advantages of Normalization in Database ?
Repetition of data can be reduced by using Normalization. Data base can be organized well in Normalization. Data...
What is tier-3 architecture in DBMS ?
This architecture divides the entire system into a three inter related and independent modules. Physical Level: In...
What is Normalization in DBMS ?
Normalization is a process of breaking down the relations with a less attributes. Process of arranging the data in the...
What Are the Advantages of Database Management System ?
Better Data Transferring: User have the advantage of more and better managed data. If there are any changes made to their...
What is indexing in database ?
Answer : Indexing is the One of the ways that will optimize the database searching...
What is Normalization ?
Answer : Normalization is the process of reorganizing data in a database...
Design a database for a hierarchical data like country, state, zone, street etc., The tags and length of the hierarchy are not specific and they can change anytime ?
Answer : Hierarchical data is a common relational data pattern for representing tree-like data structures...
Characteristics of DBMS ?
Answer : D) all the above...
What is DBMS ?
Answer : DBMS is represented by the DataBase Management...
