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

Association, Constraint, Index, Data

Answer

Aggregate, Commit, Insert, Delete

Answer

Authentication, Consistency, Integrity, Distribution

Question 2

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

Accepted Answer

DROP

Answer

DELETE

Answer

TRUNCATE

Answer

REMOVE

Question 3

What is a foreign key in a relational database?

Accepted Answer

A field referencing the primary key of another table

Answer

A primary key in a different format

Answer

An encrypted key for secure access

Answer

A unique identifier generated automatically

Question 4

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

Accepted Answer

FULL OUTER JOIN

Answer

INNER JOIN

Answer

LEFT JOIN

Answer

RIGHT JOIN

Question 5

What is normalization in database design?

Accepted Answer

Organizing data to reduce redundancy and improve integrity

Answer

Converting data to normal distribution

Answer

Indexing all columns for performance

Answer

Encrypting sensitive data

Question 6

Which SQL aggregate function returns the number of rows matching a condition?

Accepted Answer

COUNT()

Answer

SUM()

Answer

AVG()

Answer

MAX()