B.S.W.E. Bachelor of Software Engineering Database Systems & SQL 3

Question 1

What is a transaction in database systems?

Accepted Answer

A logical unit of work that must be completed entirely or not at all

Answer

A transaction is a sequence of database operations treated as a single logical unit, following ACID properties for reliability.

Question 2

What is the purpose of the ROLLBACK statement?

Accepted Answer

To undo changes made in the current transaction

Answer

ROLLBACK undoes all changes made during the current transaction, restoring the database to its state before the transaction began.

Question 3

What is sharding in database systems?

Accepted Answer

Horizontal partitioning of data across multiple database instances

Answer

Sharding is a database scaling technique that horizontally partitions data across multiple instances to distribute load and improve performance.

Question 4

What does ORM stand for in software development?

Accepted Answer

Object Relational Mapping

Answer

Object Relational Mapping (ORM) converts data between object-oriented programming languages and relational databases automatically.

Question 5

What is a deadlock in database systems?

Accepted Answer

When two or more transactions wait indefinitely for each other's locks

Answer

A deadlock occurs when two or more transactions each hold a lock the other needs, causing all of them to wait indefinitely.

B.S.W.E. Bachelor of Software Engineering Practice Test