What is the purpose of using the Write-Ahead Logging (WAL) technique in database systems?
To provide crash recovery and rollback capabilities
A collection of Data organized in a manner that allows access, retrieval & use of the data
Which type of database backup only includes the data that has changed since the last full backup?
What does the term "normalization" refer to in the context of database design?
The purpose of the primary key in a database is to
How many types of architecture we have in DBMS
Pick the odd one out.
Which of the following joins returns all rows from both tables, filling in NULL values for non-matching rows?
In the context of databases, what does the term sharding refer to?
In a relational database, a foreign key is used to:
What is the purpose of the SQL "GROUP BY" clause?
