Welcome to the Transactions MCQs Page

Dive deep into the fascinating world of Transactions with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of Transactions, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of Transactions, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

Check out the MCQs below to embark on an enriching journey through Transactions. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of Transactions. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

Transactions MCQs | Page 14 of 15

Explore more Topics under DBMS

01

DBMS Basics

02

Data Models

03

The Entity Relationship Approach

04

Relational Databases

05

Data Storage and Querying

06

Relational Algebra

07

Normalization

08

Storage and File Structures

09

Indexing and Hashing

10

Concurrency Control

11

Recovery System

12

Distributed Databases

13

SQL

14

Data Warehousing and Data Mining

15

RDBMS

16

Advanced SQL

17

SQL Queries,Constraints and Triggers

Q131.

In concurrency control policy the the lock is obtained on

Entire database

A particular transaction alone

All the new elements

All of the mentioned

Discuss

Answer: (a).Entire database

Q132.

A concurrency-control policy such as this one leads to ______ performance, since it forces transactions to wait for preceding transactions to finish before they can start.

Good

Average

Poor

Unstable

Discuss

Answer: (c).Poor

Q133.

__________ are used to ensure that transactions access each data item in order of the transactions’ ____ if their accesses conflict.

Zone

Relay

Line

Timestamps

Discuss

Answer: (d).Timestamps

Q134.

EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?

UPDATE empdet
SET ename = 'Amit'
WHERE empno = 1234;

DELETE FROM empdet
WHERE ename LIKE 'J%';

CREATE VIEW empvu
AS
SELECT * FROM empdept;

CREATE INDEX
empdet_idx
ON empdet(empno);

Discuss

Answer: (c).CREATE VIEW empvu
AS
SELECT * FROM empdept;

Q135.

In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

To find the groups forming the subtotal in a row

To create group-wise grand totals for the groups specified within a GROUP BY clause

To create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals

To create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals

Discuss

Answer: (c).To create a grouping for expressions or columns specified within a GROUP BY clause in one direction, from right to left for calculating the subtotals

Q136.

Which statement is true regarding external tables?

The default REJECT LIMIT for external tables is UNLIMITED

The data and metadata for an external table are stored outside the database

ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table

The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table

Discuss

Answer: (d).The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table

Q137.

A non-correlated subquery can be defined as ______

A set of sequential queries, all of which must always return a single value

A set of sequential queries, all of which must return values from the same table

A SELECT statement that can be embedded in a clause of another SELECT statement only

A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query

Discuss

Answer: (d).A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query

Q138.

Evaluate the following SQL statements in the given order.
Which statement is true regarding the above FLASHBACK operation?

DROP TABLE dept;
CREATE TABLE dept
(deptno NUMBER(3) PRIMARY KEY,
deptname VARCHAR2(10));
DROP TABLE dept;
FLASHBACK TABLE dept TO BEFORE DROP;

It recovers only the first DEPT table

It recovers only the second DEPT table

It does not recover any of the tables because FLASHBACK is not possible in this case

It recovers both the tables but the names would be changed to the ones assigned in the RECYCLEBIN

Discuss

Answer: (b).It recovers only the second DEPT table

Q139.

What would be the outcome of the below query?

CREATE TABLE digits
(id NUMBER(2),
description VARCHAR2(15));
INSERT INTO digits VALUES (1,'ONE');
UPDATE digits SET description ='TWO' WHERE id=1;
INSERT INTO digits VALUES (2,'TWO');
COMMIT;
DELETE FROM digits;
SELECT description FROM digits
VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE;

It would not display any values

It would display the value TWO once

It would display the value TWO twice

It would display the values ONE, TWO, and TWO

Discuss

Answer: (c).It would display the value TWO twice

Q140.

Which of the following is not a property of transactions?

Atomicity

Concurrency

Isolation

Durability

Discuss

Answer: (d).Durability

Page 14 of 15

Welcome to the Transactions MCQs Page

Transactions MCQs | Page 14 of 15

Explore more Topics under DBMS

DBMS Basics

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Normalization

Storage and File Structures

Indexing and Hashing

Concurrency Control

Recovery System

Distributed Databases

SQL

Data Warehousing and Data Mining

RDBMS

Advanced SQL

SQL Queries,Constraints and Triggers

Suggested Topics

Neural Networks

MongoDB

R Programming

PHP

Wireless and Mobile Communications

Management Information Systems

Object Oriented Programming

UNIX

Formal Languages and Automata Theory