DBMS LAB

What is normalization in DBMS?

• Normalization in DBMS is the process of combining large tables into a single table

• Normalization in DBMS is the process of adding redundancy to the database

• Normalization in DBMS is the process of randomly organizing data in a database

• Normalization in DBMS is the process of organizing a database to reduce redundancy and dependency by dividing large tables into smaller ones and defining relationships between them.

What are transactions in DBMS?

• Transactions in DBMS are used for sorting data

• Transactions in DBMS are only applicable to read operations

• Transactions in DBMS are a set of operations that are executed as a single unit of work, ensuring data consistency and integrity.

• Transactions in DBMS are a type of data backup process

Discuss the ACID properties of transactions.

• Atomicity, Consistency, Isolation, and Durability

• Atomicity, Availability, Isolation, Durability

• Atomicity, Consistency, Isolation, Reliability

• Atomicity, Consistency, Integrity, Durability

What is concurrency control in DBMS?

• Concurrency control in DBMS is the process of managing the physical storage of data.

• Concurrency control in DBMS is the process of managing simultaneous access to the database by multiple users to ensure data consistency and integrity.

• Concurrency control in DBMS is primarily focused on data retrieval speed.

• Concurrency control in DBMS is only relevant for single-user databases.

Describe the concept of deadlock in concurrency control.

• Deadlock occurs when processes share resources without any conflicts.

• Deadlock is a state where each process in a set of processes is waiting for a resource acquired by another process in the set.

• Deadlock is a state where processes are executed sequentially instead of concurrently.

• Deadlock is a situation where processes terminate successfully without any issues.

What are some common MySQL commands for database management?

• CREATE DATABASE, DROP DATABASE, USE DATABASE, SHOW DATABASES, CREATE TABLE, DROP TABLE, ALTER TABLE, INSERT INTO, SELECT, UPDATE, DELETE

• CREATE COLUMN

• DISPLAY DATABASE

• REMOVE TABLE

How do you create a new database in MySQL?

• CREATE TABLE database_name;

• CREATE DATABASE database_name;

• ADD DATABASE database_name;

• INSERT INTO database_name;

Explain the SELECT statement in MySQL.

• The SELECT statement in MySQL is used to update data in a database.

• The SELECT statement in MySQL is used to retrieve data from one or more tables in a database.

• The SELECT statement in MySQL is used to delete data from a database.

• The SELECT statement in MySQL is used to create new tables in a database.

How do you update data in a MySQL table?

• INSERT INTO table_name (column1, column2) VALUES (value1, value2);

• MODIFY table_name SET column1 = value1, column2 = value2 WHERE condition;

• CHANGE table_name SET column1 = value1, column2 = value2 WHERE condition;

• UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;

Discuss the JOIN clause in MySQL.

• The JOIN clause in MySQL is used to insert rows from two or more tables based on a related column between them.

• The JOIN clause in MySQL is used to update rows from two or more tables based on a related column between them.

• The JOIN clause in MySQL is used to combine rows from two or more tables based on a related column between them.

• The JOIN clause in MySQL is used to delete rows from two or more tables based on a related column between them.