Filters
Question type
Study Flashcards

The ____ manager is responsible for assigning and policing the locks used by the transactions.


A) transaction
B) database
C) lock
D) schedule

E) C) and D)
F) All of the above

Correct Answer

verifed

verified

Atomicity indicates the permanence of the database's consistent state.

A) True
B) False

Correct Answer

verifed

verified

Explain the transaction log.What is its function?

Correct Answer

verifed

verified

A DBMS uses a transaction log to keep tr...

View Answer

The DBMS guarantees that the semantic meaning of a transaction truly represents the real-world event.

A) True
B) False

Correct Answer

verifed

verified

What are the three basic techniques to control deadlocks?

Correct Answer

verifed

verified

Deadlock prevention.A transaction reques...

View Answer

The ____ approach to scheduling concurrent transactions assigns a global unique stamp to each transaction.


A) scheduled
B) table-locking
C) unique
D) timestamping

E) A) and D)
F) B) and C)

Correct Answer

verifed

verified

To ensure consistency of the database,every transaction must begin with the database in an unstable state.

A) True
B) False

Correct Answer

verifed

verified

A transaction is a ____ unit of work that must be either entirely completed or aborted.


A) timed
B) practical
C) logical
D) physical

E) All of the above
F) None of the above

Correct Answer

verifed

verified

____________________ can take place at any of the following levels: database,table,page,row,or field.

Correct Answer

verifed

verified

One of the three most common data integrity and consistency problems is ____.


A) lost updates
B) disk failures
C) user errors
D) deadlocks

E) A) and C)
F) A) and B)

Correct Answer

verifed

verified

Showing 61 - 70 of 70

Related Exams

Exam 1

Database Systems

70 Questions

Exam 2

Data Models

70 Questions

Exam 3

The Relational Database Model

100 Questions

Exam 4

Entity Relationship (ER)Modeling

100 Questions

Exam 5

Advanced Data Modeling

70 Questions

Exam 6

Normalization of Database Tables

100 Questions

Exam 7

Introduction to Structured Query Language (SQL)

100 Questions

Exam 8

Advanced SQL

100 Questions

Exam 9

Database Design

100 Questions

Exam 11

Database Performance Tuning and Query Optimization

70 Questions

Exam 12

Distributed Database Management Systems

70 Questions

Exam 13

Business Intelligence and Data Warehouses

100 Questions

Exam 14

Database Connectivity and Web Technologies

100 Questions

Exam 15

Database Administration and Security

100 Questions

Show Answer