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

Oracle
Edit

Statement

True-False▾

Explicitly we can assign transaction to a rollback segment

Answer

TRUE

Explanation

  • Yes, we can assign transaction to a rollback segment.
  • Rollback segment is a database object containing before-images of data written to the database.

Rollback Segment

  • Used to undo changes when a transaction is rolled back.
  • Transaction does not see uncommitted changes made to the database.
  • Recover the database to a consistent state in failures.

Two types of rollback segments:

  • Private rollback segments
  • Public rollback segments
Two Types of Rollback Segments

Question 46

Oracle

Question

MCQ▾

What built-in subprogram is used to manipulate images in image items?

Choices

Choice (4)

a.

Zoom_image

b.

Image_zoom

c.

Zoom_out

d.

Zoom_in ′

Answer

b.

Explanation

Image_zoom is built-in subprogram used to manipulate image in image items.

Question 47

Oracle

Question

MCQ▾

Which is not part of the Data Definition Language?

Choices

Choice (4)

a.

ALTER

b.

ALTER SESSION

c.

CREATE

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

Define DDL Statements
  • ALTER SESSION is not support of the Data Definition Language.

Data Definition Language

  • Used to alter/modify a database or table structure and schema.
  • These statements handle the design and storage of database objects.

DDL statement enable:

  • Create, alter and drop schema objects
  • Grant and revoke privileges.
  • Analyse information on a table, index, or cluster.
  • Establish auditing options
  • Add comments to the data dictionary
  • The current transaction must end before and after every DDL statement.
  • Many DDL statement cause recompile of schema objects.

Examples

  • CREATE: create a new table, database, schema
  • ALTER: alter existing table, column description
  • DROP: delete existing objects from database

Developed by: