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 10 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

Q91.

In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

CREATE PACKAGE

CREATE SCHEMA

CREATE CLUSTER

All of the mentioned

Discuss

Answer: (b).CREATE SCHEMA

Q92.

Which character function can be used to return a specified portion of a character string?

INSTR

SUBSTRING

SUBSTR

POS

Discuss

Answer: (c).SUBSTR

Q93.

Which of the following is TRUE for the System Variable $date$?

Can be assigned to a global variable

Can be assigned to any field only during design time

Can be assigned to any variable or field during run time

Can be assigned to a local variable

Discuss

Answer: (b).Can be assigned to any field only during design time

Q94.

What are the different events in Triggers?

Define, Create

Drop, Comment

Insert, Update, Delete

Select, Commit

Discuss

Answer: (c).Insert, Update, Delete

Q95.

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints

6789

2345

1234

456789

Discuss

Answer: (b).2345

Q96.

Which of the following SQL command can be used to modify existing data in a database table?

MODIFY

UPDATE

CHANGE

NEW

Discuss

Answer: (b).UPDATE

Q97.

When SQL statements are embedded inside 3GL, we call such a program as

Nested query

Nested programming

Distinct query

Embedded SQL

Discuss

Answer: (d).Embedded SQL

Q98.

_______________ provides option for entering SQL queries as execution time, rather than at the development stage.

PL/SQL

SQL*Plus

SQL

Dynamic SQL

Discuss

Answer: (d).Dynamic SQL

Q99.

Each modification done in database transaction are first recorded into the

Harddrive

Log

Disk

Datamart

Discuss

Answer: (b).Log

Q100.

_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Serializability

Atomicity

Isolation

Time stamping

Discuss

Answer: (c).Isolation

Page 10 of 15

Welcome to the Transactions MCQs Page

Transactions MCQs | Page 10 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

Object Oriented Programming

Visual Basic

UNIX

Big Data Computing

Operating System

Software Engineering

Computer Hardware

CSS

Java Programming