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

Oracle
Edit

Statement

True-False▾

SNAPSHOTS cannot be refreshed automatically

Answer

FALSE

Explanation

  • Snapshot refresh group can specify an automatic refresh interval for the group.
  • When setting a group՚s refresh interval, consider the following:
    • The dates or date expressions specifying the refresh interval must evaluate to future time.
    • The refresh interval must be greater than the length of time to perform a refresh.
    • Relative date expressions must evaluate to time relative to the most recent date.
    • Network or system failure can interfere with scheduled group refresh changing evaluation of relative date expression.
    • Explicit date expressions must evaluate to specific points in time, the most recent refresh date.

Question 9

Oracle

Question

MCQ▾

Identify the RESTRICTED packaged procedure from the following

Choices

Choice (4)

a.

BREAK

b.

EXIT_FORM

c.

MESSAGE

d.

USER_EXIT

Answer

b.

Explanation

  • Restricted package procedure affects the basic functions of SQL ⚹ Forms.
  • That cannot used in all triggers except key triggers.

Below is the list of RESTRICTED packaged procedures:

  • Execute Query- Restricted
  • Message- Restricted
  • Post- Restricted
  • Exit_form-Restricted
  • Up-restricted

Developed by: