Multiple choice

Which of the following is called the security technique(s) while Committing Transactions in Oracle P/L SQL?

  1. It makes the changes permanent and affects the savepoints.

  2. The changes are not final.

  3. The changes are not visible to other users of the database instance.

  4. The newest Database Express Edition issues an implicit COMMIT statement before and after any data definition language (DDL) statement.

  5. The data restoration process will be at one point.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The changes are visible to user, but not to other users of the database instance. It makes the database secure and authenticated.

Keep practicing — related questions