Database [3i Infotech Placement]: Sample Questions 115 - 117 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 115

Question MCQ▾

Which of the following is not an advantage of GUI systems?

Choices

Choice (4)

a.

GUI՚s can display multiple applications in multiple windows

b.

GUI՚s provide more user interface objects for a developer

c.

Intuitive and easy to use.

d.

None of the above

Edit

Answer

d.

Explanation

Advantages of GUI
  • A GUI is more user-friendly- icons are used to represent application.
  • Complex, multi-step, dependent tasks can easily be grouped together.
  • The user does not need to learn any command.
  • Clicking an icon is very easy compared to typing every command.
  • It easy to place more information within a single program.
  • A graphical user interface also makes it easier for the user to move the data or information from one application to the other.
  • GUI has standard formats that help in representing graphics and text.
  • It saves time editing settings manually.

Question 116

Write in Short Short Answer▾

Give some examples of Analytical functions.

Edit

Explanation

Analytical functions examples is AVG, LEAD, and PERCENTILE_RANK.

Question 117

Question MCQ▾

Which of the following statement is false

Choices

Choice (4)

a.

Error numbers ranging from 20000 to 20999 are reserved for user defined messages

b.

Oracle checks Uniqueness of User defined errors

c.

Raise_Application_error is used for raising an user defined error.

d.

Any procedure can raise an error, and return an user message and error number

Edit

Answer

b.

Explanation

  • The RAISE statement is used to explicitly raise an exception and display an error message, returned by an error code.
  • Used by itself within an exception handler to the calling environment.
  • Stop normal execution of a PL/SQL block or subprogram and transfer control to an exception handler.
  • Raise statements can rise predefine exceptions, or user-define exception.
  • Error number defined between 20,000 to 20,999 (and their associated text) are reserved for user defined message.
  • When ERROR_NUMBER is negative integer the range is -20,000 to -20,999.
  • The RAISE_APPLICATION_ERROR is actually a procedure defined by Oracle it allows the developer to raise an exception and associate an error number and message with the procedure.
  • When we need to raise error from the server and pass this error back to the client process, we use RAISE statement.

Two Reason to Use

  • First is: To replace generic oracle exception messages with more meaningful messages.
  • Second is: To create exception conditions when oracle would not throw them.