Database-Oracle [3i Infotech Placement]: Sample Questions 95 - 96 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 95

Oracle

Question

MCQ▾

What does a COMMIT statement do to a CURSOR

Choices

Choice (4)

a.

Open the Cursor

b.

Close the Cursor

c.

Fetch the Cursor

d.

None of the above

Answer

d.

Explanation

  • A commit statement in a cursor will free the memory area, which is being used by the cursor.
  • When a cursor is open we cannot insert a commit command.
  • The reason is that Oracle closes all open cursors when a commit command is entered.
  • COMMIT ONLY closes cursors that used for Update/Insert/Delete statements.
  • It is not an update but the status of cursor become invalid after commit.

Question 96

Oracle

Question

MCQ▾

The status of the Rollback segment can be viewed through

Choices

Choice (4)

a.

DBA_ROLES

b.

DBA_FREE_SPACES

c.

DBA_ROLLBACK_SEG

d.

DBA_SEGMENTS

Answer

c.

Explanation

Rollback Segments in the Database
  • DBA_ROLLBACK_SEGS can be used to query the data dictionary view- finding the name, segment ID number, and status of each rollback segment in the database
  • Rollback segment allocates one or more rollback segments by name to this instance.
  • If this parameter is set- instance acquires the entire rollback segment to be named in this parameter.
  • Cannot change the value of this parameter dynamically- change its value and then restart this instance.
  • Specifies private rollback segments.

Use Parameter

String

Syntax

ROLLBACK_SEGMENT = (segment_name [, segment_name] … .)

Default value:

  • Instance uses public rollback segments by default, unless the UNDO_MANAGEMENT init parameter is set to AUTO.

Modifiable:

  • No

Range of value:

  • Any rollback segment name in DBA_ROLLBACK_SEGS

Developed by: