Database-Oracle [3i Infotech Placement]: Sample Questions 109 - 110 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 109

Oracle
Edit

Statement

True-False▾

SET TRANSACTION USE ROLLBACK SEGMENT is used to create user objects in a particular Table space.

Answer

FALSE

Explanation

Transaction and Rollback Segments
  • The SET TRANSACTION statement:
    • Sets a transaction as read-only
    • Sets a transaction as read/write
    • Assigns a name to a transaction
    • Assigns a rollback segment to a transaction
  • The operation performed affects only our current transaction.
  • Transaction ends COMMIT or ROLLBACK statement is issued.
  • Oracle Database implicitly commits the current transaction before and after executing a data definition language statement.

Syntax of Set Transaction

SET TRANSACTION [READ ONLY|READ WRITE]

[ISOLATION LEVEL [SERIALIZE|READ COMMITED]

[USE ROLLBACK SEGMENT ‘segment_name’ ]

[Name ‘transaction_name’ ] ;

Question 110

Oracle

Question

MCQ▾

The packaged procedure that makes data in form permanent in the database is

Choices

Choice (4)

a.

Post

b.

Commit form

c.

Post form

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

  • The packaged procedure that makes data in form permanent in the database is commit form.
  • Commit form is a form built-in function to save the data to the database.
  • Commit is a command for committing all the transactions that have been performed.

Developed by: