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 |
Answer
d.Explanation
- 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.
- 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
Explanation
- 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 ()