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 database backup operation

Answer

A SQL SELECT query

Answer

A schema update operation

Question 2

What is the purpose of the ROLLBACK statement?

Accepted Answer

To undo changes made in the current transaction

Answer

To commit a transaction permanently

Answer

To create a database backup

Answer

To drop all tables in the database

Question 3

What is sharding in database systems?

Accepted Answer

Horizontal partitioning of data across multiple database instances

Answer

Encrypting database rows for security

Answer

Creating indexes on all columns

Answer

Duplicating a database for read redundancy

Question 4

What does ORM stand for in software development?

Accepted Answer

Object Relational Mapping

Answer

Open Resource Management

Answer

Optimized Read Model

Answer

Object Response Method

Question 5

What is a deadlock in database systems?

Accepted Answer

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

Answer

When a database server goes offline

Answer

When a query takes too long to execute

Answer

When a database runs out of storage space

Question 6

What does the CAP theorem state about distributed databases?

Accepted Answer

Consistency, Availability, and Partition tolerance cannot all be guaranteed simultaneously

Answer

Caching, Archiving, and Processing are the core database operations

Answer

Compression, Authentication, and Performance are the key metrics

Answer

Create, Access, and Persist define the fundamental database operations