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

Oracle

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

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 12

Oracle

Question

MCQ▾

What is a DATABLOCK

Choices

Choice (4)

a.

Set of Segments

b.

Set of Extents

c.

Smallest Database storage unit

d.

Question does not provide sufficient data or is vague

Answer

c.

Explanation

Oracle Data Block and Operating System Block
  • A smallest database storage unit.
  • The small unit of I/O by a database.
  • A specific number of bytes of physical database space on disk.
  • Oracle requests data in multiples of Oracle data blocks, not operating system blocks.
  • A multiple the os block size.
  • Oracle data blocks are the smallest units of storage that Oracle can use or allocate.

Developed by: