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 |
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.
S | Q | U | A | R | E | A | N | S | A | L | W | A | Y | S | W | O | R | K | H | A | R | D | ||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 |
- 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 |
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.