Different types of Keys in DBMS
There are 7 keys in DBMS Primary Key Key which is used to identify one and only instance of entity uniquely. An Enity can...
What are the data models in DBMS ?
There are 4 data models in DBMS Relational Data Model Edgar F.Codd described the model in 1969. Data are designed using...
Difference between Trigger and Stored procedure in DBMS
Triggers Stored Procedures A Trigger is created in such a way that it fires when a specific event occurs. A group of sql...
Difference between DBMS and File System
File System DBMS A software that manages and organizes the file in storage medium is called as file system. DBMS is ...
What are Database Management Tools ?
phpMyAdmin: PhpMyAdmin is the most popular open-source web-based database management tool by MySQL. Using phpMyAdmin we can...
What is DBMS Utilities ?
Data Loading Utility: Data loading utility helps to load data from an external format without writing programs. Backup...
Difference between RDBMS and DBMS ?
DBMS RDBMS Data is stored in file format Data is stored in table format. Data is stored either in a hierarchical form or...
Difference between Delete and Truncate
Delete Truncate Used to delete rows from a table based on the condition provided on the where clause. Used to delete...
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 are the various elements provided by HTML 5 for media content ?
There are lot of new elements are added which provides some extra functionality to create dynamic and attractive website in...
What is the use of Namespace in Web Development ?
It refers to the programming paradigm of providing scope to the identifiers like name of types, functions, variables, etc....
What is Cors ?
CORS- Cross-Origin Resource Sharing. It is header-based mechanism that allows a server to indicate any origins like scheme,...
What is SVG and why is it used ?
SVG- Scalar Vector Graphics. It is a popular tool for displaying two-dimensional charts, graphics and illustrations on...
