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

Question MCQ▾

SUBSTR (SQUARE ANS ALWAYS WORK HARD, 14,6) will return

Choices

Choice (4)

a.

ALWAY

b.

ALWAYS

c.

S ALWA

d.

None of the above

Edit

Answer

b.

Explanation

  • SUBSTR (SUBSTRING) function extracts a portion of a string from a string of characters.

    Syntax

  • SUBSTR (source_string, starting_position, [length] ) ;
  • The string_position is the position in the source_string we want to start extracting characters.
  • source_string is always ‘1’ , NOT ‘0’
    • starting_position is 0, then SUBSTR treats start_position as 1 (i.e.: the first position in the string) .
    • starting_position is a positive number, then SUBSTR starts from the beginning of the string.
    • starting_position is a negative number, then SUBSTR starts from the end of the source_string and counts backwards.
  • The length parameter is optional, and specifies the number of characters to extract.
  • If length is a negative number, then SUBSTR will return NULL value.
Table of the Square Ans Always Work Hard
SQUAREANSALWAYSWORKHARD
123456789101112131415161718192021222324252627
  • So, SUBSTR (SQUARE ANS ALWAYS WORK HARD, 14,6) will return: ALWAYS.

Question 14

Question MCQ▾

What is Library in Forms 4.0?

Choices

Choice (4)

a.

Collection of PL/SQl functions, procedures and packages

b.

Collection of External field

c.

Collection of PL/SQL procedures & triggers

d.

Collection of built_in packages

Edit

Answer

a.

Explanation

  • Is a collection of subprograms- includes user-named procedures, function and package.
  • Provides a convenient means of storing client-side program units and sharing multiple apps.
  • Once library is created it can be attached to any form, menu, or library module- the same library can be attached in multiple forms and modules and also attached to other libraries.
  • When library attaches to other library, first library can reference program unit in the attached library.