What is Transaction in DBMS ?

If we need one or more database access operations, we have a logical unit of processing called Database Transaction. In simple, database transactions represent real-world events of any enterprise. Database…
View Answer

Normal Forms in DBMS ?

There are 4 types of form in Normalization : First Normal Form(1NF)  If a relation does not contain any multi valued attributes, then the relation is said to be in…
View Answer

What is DBMS Queries ?

SQL Commands SQL commands are instruction which is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data It can also…
View Answer

What is ER Model in DBMS ?

ER stands for Entity-Relationship model. It is a high level data model. If any data elements or relationship of any specified system can defined using this model. Conceptual design for…
View Answer

What are Database Management Tools ?

phpMyAdmin: PhpMyAdmin is the most popular open-source web-based database management tool by MySQL. Using phpMyAdmin we can create or manage databases, tables, DB users, optimize and check errors in your…
View Answer

What is DBMS Utilities ?

Data Loading Utility: Data loading utility helps to load data from an external format without writing programs. Backup utility: In case of crashes and disasters this utility helps to take…
View Answer