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

Question 1

What does ACID stand for in database transactions?

Accepted Answer

Atomicity, Consistency, Isolation, Durability

Answer

ACID (Atomicity, Consistency, Isolation, Durability) defines the properties that guarantee database transactions are processed reliably.

Question 2

Which SQL command removes a table and all its data permanently?

Accepted Answer

DROP

Answer

DROP TABLE removes the entire table structure along with all its data and the schema definition from the database.

Question 3

What is a foreign key in a relational database?

Accepted Answer

A field referencing the primary key of another table

Answer

A foreign key is a column that establishes a referential link between two tables by pointing to the primary key of another table.

Question 4

What type of JOIN returns all rows when there is a match in either table?

Accepted Answer

FULL OUTER JOIN

Answer

A FULL OUTER JOIN returns all rows from both tables, filling with NULL values where no match exists in either table.

Question 5

What is normalization in database design?

Accepted Answer

Organizing data to reduce redundancy and improve integrity

Answer

Normalization organizes a database structure to reduce data redundancy and improve data integrity through a series of normal forms.

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