Oracle - Sequences Commits and rollbacks Exception MCQ

Oracle – Sequences Commits and rollbacks Exception

1 / 25

1. Which statement is used to create a sequence in Oracle?

CREATE PROCEDURE

CREATE INDEX

CREATE TABLE

CREATE SEQUENCE

2 / 25

2. What is the purpose of a sequence in Oracle?

To generate unique numbers

To create a stored procedure

To perform data manipulation

To define a table structure

3 / 25

3. How do you drop a sequence in Oracle?

DELETE SEQUENCE

DROP SEQUENCE

ERASE SEQUENCE

REMOVE SEQUENCE

4 / 25

4. Which statement is used to commit the current transaction in Oracle?

BEGIN

COMMIT

ROLLBACK

SAVEPOINT

5 / 25

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

To create a new transaction

To save changes made in the current transaction

To undo changes made in the current transaction

To define a new sequence

6 / 25

6. What happens when you issue a COMMIT statement in Oracle?

The transaction is deleted.

The transaction is paused.

The transaction is committed, and changes are saved permanently.

The transaction is rolled back.

7 / 25

7. Which statement is used to undo changes made in the current transaction in Oracle?

BEGIN

SAVEPOINT

COMMIT

ROLLBACK

8 / 25

8. In Oracle, what is the purpose of the ROLLBACK statement?

To save changes made in the current transaction

To undo changes made in the current transaction

To define a new sequence

To create a new transaction

9 / 25

9. What happens when you issue a ROLLBACK statement in Oracle?

The transaction is deleted.

The transaction is committed, and changes are saved permanently.

The transaction is paused.

The transaction is rolled back, and changes are undone.

10 / 25

10. Which of the following is a valid use case for committing a transaction in Oracle?

To ensure that changes are permanent and cannot be rolled back

To create a new table

To delete a sequence

To temporarily save changes until a later time

11 / 25

11. In Oracle PL/SQL, what is the primary purpose of exception handling?

To perform calculations

To create sequences

To define tables

To handle errors and exceptions gracefully

12 / 25

12. Which statement is used to raise a predefined exception in Oracle PL/SQL?

THROW_EXCEPTION

RAISE_APPLICATION_ERROR

RAISE_USER

RAISE_CUSTOM

13 / 25

13. What is the purpose of the RAISE_APPLICATION_ERROR statement in Oracle PL/SQL?

To raise a predefined exception

To create a new sequence

To save changes

To define a custom exception

14 / 25

14. In Oracle PL/SQL, what is the purpose of the EXCEPTION section in a block of code?

To define variables

To handle errors and exceptions

To execute SQL statements

To create sequences

15 / 25

15. Which keyword is used to handle exceptions in Oracle PL/SQL?

CATCH

EXCEPTION

HANDLE

TRY

16 / 25

16. What happens when an unhandled exception occurs in Oracle PL/SQL code?

The exception is automatically handled by the system.

An error message is displayed, and the program terminates abnormally.

The program crashes and terminates.

The program continues executing normally.

17 / 25

17. In Oracle PL/SQL, which keyword is used to define a custom exception?

DEFINE

EXCEPTION

DECLARE

CUSTOM

18 / 25

18. What is the purpose of defining a custom exception in Oracle PL/SQL?

To define variables

To handle application-specific errors

To create sequences

To handle predefined exceptions

19 / 25

19. Which of the following is a valid way to handle exceptions in Oracle PL/SQL?

Using the CREATE TABLE statement

Using the WHILE loop

Using the COMMIT statement

Using the EXCEPTION section

20 / 25

20. In Oracle PL/SQL, which statement is used to specify the action to be taken when a specific exception occurs?

WHEN

THROW

RAISE

CATCH

21 / 25

21. Which of the following is true about sequences in Oracle?

Sequences are used to create tables.

Sequences are used to define stored procedures.

Sequences are used to handle exceptions.

Sequences are used to generate unique numbers.

22 / 25

22. What is the primary purpose of a SAVEPOINT statement in Oracle?

To define a sequence

To specify a target location within a transaction

To create a new table

To define a custom exception

23 / 25

23. In Oracle PL/SQL, what is the primary purpose of the SAVEPOINT statement?

To define a custom exception

To create a new table

To specify a target location within a transaction

To define a sequence

24 / 25

24. Which of the following is a valid way to define a sequence in Oracle?

DEFINE SEQUENCE my_sequence;

DROP SEQUENCE my_sequence;

CREATE SEQUENCE my_sequence;

INSERT SEQUENCE my_sequence;

25 / 25

25. In Oracle PL/SQL, which keyword is used to declare a sequence?

SEQUENCE

CREATE

TABLE

DECLARE

Your score is

0%

Oracle – Sequences Commits and rollbacks Exception MCQ