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

Oracle

Question

MCQ▾

What are the different events in Triggers?

Choices

Choice (4)

a.

Define, Create

b.

Drop, Comment

c.

Insert, Update, Delete

d.

None of the above

Answer

c.

Explanation

  • Trigger event specifies what DML statement can initiate the trigger- INSERT, DELETE, or UPDATE operation on the table or view, or a SELECT operation that queries the table.
  • Create trigger statement must specify one trigger event.
  • We can define triggers that are activated by INSERT, DELETE, UPDATE, or SELECT statements.
  • Multiple triggers on the same table or view can active different type of trigger by the same type of trigger event.
  • We cannot specify a DELETE event if the triggering table has a referential constraint that specifies ON DELETE CASCADE.
  • Guaranty is that triggering statement returns the same result with and without the trigger action on a table.
  • Statement from an external database server can activate the trigger.
  • The INSTEAD OF trigger replaces the trigger event with the specified trigger action.
  • Any number INSTEAD OF trigger can be defined for each type of INSERT, DELETE, or UPDATE triggering event.

Question 92

Oracle

Question

MCQ▾

What built_in procedure is used to get IMAGES in Forms 4.5?

Choices

Choice (4)

a.

READ_IMAGE_FILE

b.

GET_FILE

c.

READ_FILE

d.

GET_IMAGE_FILE

Answer

a.

Explanation

  • READ_IMAGE_FILE is built_in procedure to get IMAGE in forms 4.5.
  • Used to read file into am image item on a Datablock defined as blob in the database.

Developed by: