gs gs117 Transactions - Transaction Concept - Quiz No.1
gs gs117 Database Management System Quiz
This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Transactions. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?
Only 1
Only 2
Both 1 and 2 individually
Either 1 or 2
Question 2: A transaction is delimited by statements (or function calls) of the form __________
Begin transaction and end transaction
Start transaction and stop transaction
Get transaction and post transaction
Read transaction and write transaction
Question 3: Identify the characteristics of transactions
Atomicity
Durability
Isolation
All of the mentioned
Question 4: Which of the following has “all-or-none” property?
Atomicity
Durability
Isolation
All of the mentioned
Question 5: The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as
Atomicity
Durability
Isolation
All of the mentioned
Question 6: The property of a transaction that persists all the crashes is
Atomicity
Durability
Isolation
All of the mentioned
Question 7: __________ states that only valid data will be written to the database.
Consistency
Atomicity
Durability
Isolation
Question 8: Transaction processing is associated with everything below except
Producing detail summary or exception reports
Recording a business activity
Confirming an action or triggering a response
Maintaining a data
Question 9: The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.
BEGIN
SET TRANSACTION
BEGIN TRANSACTION
COMMIT
Question 10: ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
Consistency
Atomicity
Durability
Isolation
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117
Database Management System Online Quizzes
