Oracle - DML and Transaction Management MCQ

Oracle – DML and Transaction Management

1 / 14

1. What does DML stand for in Oracle?

Data Modeling Language

Database Markup Language

Data Management Language

Data Manipulation Language

2 / 14

2. In Oracle, which statement is used to perform data manipulation operations such as INSERT, UPDATE, and DELETE?

SELECT

COMMIT

DML

CREATE

3 / 14

3. What does the RETURNING clause in DML statements provide in Oracle?

It returns the primary key of the table

It returns the current timestamp

It returns the total number of rows affected by the statement

It returns the rows that were inserted, updated, or deleted

4 / 14

4. What is the primary purpose of exception handling in DML operations in Oracle?

To bypass DML operations and return to the main program

To provide detailed error messages to the user

To roll back the transaction in case of an error

To commit the transaction automatically

5 / 14

5. In Oracle PL/SQL, what is the purpose of the COMMIT statement?

To save all the changes made during the current transaction

To lock a table for exclusive access

To undo all the changes made during the current transaction

To define a savepoint within a transaction

6 / 14

6. Which statement is used in Oracle PL/SQL to roll back the current transaction and undo all changes made?

COMMIT

ROLLBACK

SET TRANSACTION

SAVEPOINT

7 / 14

7. What is the purpose of the SAVEPOINT statement in Oracle PL/SQL?

To lock a table for exclusive access

To define a point within a transaction to which you can later roll back

To return data from DML operations

To commit the transaction

8 / 14

8. Which statement is used in Oracle PL/SQL to explicitly set properties for a transaction, such as isolation level?

SET TRANSACTION

SAVEPOINT

ROLLBACK

COMMIT

9 / 14

9. In Oracle, what is the purpose of the LOCK TABLE statement in PL/SQL?

To obtain exclusive access to a table

To delete rows from a table

To modify existing data in a table

To insert new rows into a table

10 / 14

10. What is an autonomous transaction in Oracle PL/SQL?

A transaction that cannot contain DML operations

A transaction that is automatically committed

A transaction that is automatically rolled back

A transaction that is independent of the calling transaction

11 / 14

11. In Oracle PL/SQL, what are the rules and restrictions on autonomous transactions?

They are always rolled back automatically

They cannot be committed

They cannot contain DML statements

They can contain DML statements

12 / 14

12. What is transaction visibility in Oracle?

The ability to see only the autonomous transactions

The ability to see all transactions

The ability to see the schema-level transactions

The ability to see only the current transaction

13 / 14

13. When should you use autonomous transactions in Oracle PL/SQL?

When you want to roll back a transaction

When you need to commit the transaction automatically

When you want to isolate a specific transaction

When you need to lock a table for exclusive access

14 / 14

14. What is the purpose of building an autonomous logging mechanism in Oracle PL/SQL?

To log information about autonomous transactions

To prevent DML operations

To commit transactions automatically

To track changes in the database

Your score is

Oracle – DML and Transaction Management MCQ