Search Header Logo

DBMS TAE-3

Authored by SHIVANI HARDE

Computers

University

Used 1+ times

DBMS TAE-3
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following properties ensures that a transaction is processed in a way that either all of its operations are executed or none are executed?

  • A) Durability

  • B) Consistency

  • C) Atomicity

  • D) Isolation

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The isolation property in transactions ensures that:

  • A) Each transaction is executed independently

  • B) Each transaction affects only its own data

  • C) Each transaction leaves the database in a valid state

  • D) Each transaction appears to be the only transaction running

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following ensures that the result of executing concurrent transactions is the same as if they were executed serially?

  • A) Deadlock prevention

  • B) Two-phase locking

  • C) Serializability

  • D) Cascading rollback

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a key component of the Two-Phase Commit protocol?

  • A) Commit log

  • B) Prepared log

  • C) Commit request and acknowledgment

  • D) Deadlock detection

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In a database system, a cursor is used for:

  • A) Recovering from a system failure

  • B) Serializing transaction execution

  • C) Traversing through the result set row by row

  • D) Locking rows during a transaction

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of index stores a sorted order of data values to improve query performance?

  • A) Hash index

  • B) Primary index

  • C) Clustered index

  • D) Non-clustered index

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is typically the first step in query processing?

  • A) Query execution

  • B) Query optimization

  • C) Parsing the query

  • D) Transaction logging

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?