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

Oracle

Question

MCQ▾

What is TERM?

Choices

Choice (4)

a.

TERM is the terminal definition file that describes the terminal from which you are using R20DES (Reports designer)

b.

There is no Parameter called TERM in Reports 2.0

c.

TERM is the terminal definition file that describes the terminal from which you are using R20RUN (Reports run time)

d.

None of the above

Answer

c.

Explanation

  • The term is terminal definition file describing the terminal using R20RUN.
  • This corresponds to oracle report functions.

Question 112

Oracle
Edit

Statement

True-False▾

A database trigger does not apply to data loaded before the definition of the trigger

Answer

FALSE

Explanation

Define Types of Triggers
  • Database triggers are executed in response to events that occur in the database.
  • Like a stored procedure it is predefined before event occurs.
  • Enable database administrators to create additional relationships between separate databases.
  • It can execute before or after an INSERT, UPDATE, or DELETE operation.
  • If a trigger event occurs, the trigger՚s function is called at the appropriate time to handle the event.
  • Stored code executed immediately after a predefined event.
  • A database trigger does apply to data loaded before the definition of the trigger.
  • Mostly used for maintaining the integrity of the information on the database.

Developed by: