3i Infotech Placement: Sample Questions 103 - 104 of 1245

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

Question 103

Question MCQ▾

What is built_in Subprogram?

Choices

Choice (4)

a.

Collection of Subprograms

b.

Stored procedure & Function

c.

Collection of Packages

d.

None of the above

Edit

Answer

d.

Explanation

Understanding of Built-In Subprograms
  • A built-in-function is SQL keyword to execute some operation in SQL statements which are built in the system - to perform some built-in function.
  • Also used in program or subprogram environment that provide by the oracle database.
  • It executes store procedures, function, triggers.

Two types of subprogram:

  • Procedures
    • Use perform the action
  • Function
    • Use to compute the value.

    Subprogram is PL/SQL block that can be called with a set of parameters.

Two Types of Subprogram
  • It has:
  • A declarative part, with declarations of types, cursors, constants, variables, exceptions and nested subprograms.
  • An executable part, with statement, its assigned values, control execution, and manipulate oracle data.
  • Optional exception-handling part, which deals with runtime error conditions.

Question 104

Describe in Detail Essay▾

What is meant by servlet? What are the parameters of service method?

Edit

Explanation

Understanding of Servlet
  • A servlet is a java programming language class to extend the capabilities of servers that use request-response programming mode.
  • Servlet respond to requests and extend the applications hosted by web servers.
  • Java servlet technology defines HTTP-specific servlet classes with following methods:
    • int ()
    • service ()
    • getServletConfig ()
    • getServletInfo ()
    • destroy ()