adplus-dvertising

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.

frame-decoration

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

Q131.
In concurrency control policy the the lock is obtained on

a.

Entire database

b.

A particular transaction alone

c.

All the new elements

d.

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.

a.

Good

b.

Average

c.

Poor

d.

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.

a.

Zone

b.

Relay

c.

Line

d.

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?

a.

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

b.

DELETE FROM empdet
WHERE ename LIKE 'J%';

c.

CREATE VIEW empvu
AS
SELECT * FROM empdept;

d.

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?

a.

To find the groups forming the subtotal in a row

b.

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

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

d.

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?

a.

The default REJECT LIMIT for external tables is UNLIMITED

b.

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

c.

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

d.

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.

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

b.

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

c.

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

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

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;

a.

It recovers only the first DEPT table

b.

It recovers only the second DEPT table

c.

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

d.

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;

a.

It would not display any values

b.

It would display the value TWO once

c.

It would display the value TWO twice

d.

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?

a.

Atomicity

b.

Concurrency

c.

Isolation

d.

Durability

Discuss
Answer: (d).Durability
Page 14 of 15

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

IT Fundamentals

Navigate the basics of information technology with our IT Fundamentals MCQs. Get a...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...