Question
During transaction before commit which of the following
statements is done automatically in case of shutdown?Solution
The correct answer is A
In a relational database, what is a foreign key?
What is the output of the following pseudo-code?Â
 ```
  count = 0
  for i from 1 to 3:
    for j from 1 t...
What is the purpose of a "View" in a database?
In the context of database transactions, which isolation level allows "non-repeatable reads" but prevents "dirty reads"?
A transaction that reads a value then later sees a different value because another transaction updated and committed in between experiences which anomaly?
A relation is in 1NF (First Normal Form) if:
A view in SQL is:
What does [aeiou] match in a regular expression?Â
Given a relation R(A, B, C, D, E) and functional dependencies {A -> B, BC -> D, D -> E}. Which of the following is a candidate key for R?
Which of the following database models represents data as a collection of tables, where each table consists of rows and columns?
