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

Oracle

Question

MCQ▾

REPLACE ( ‘JACK AND JUE’ , ‘J’ , ‘BL’ ) will return

Choices

Choice (4)

a.

BLACK AND JACK

b.

BLACK AND BLUE

c.

JACK AND BLUE

d.

All of the above

Answer

b.

Explanation

  • REPLACE function replaces a sequence of characters in a string with another set of characters.
  • replacement_string is omitted or null, then all search_string are removed.
  • search_string is null, then char is return.

Syntax:

REPLACE (string1, string_to_replace [, replacement_string] )

EX:

REPLACE ( ‘JACK AND JUE’ , ‘J’ , ‘BL’ )

J = search_string

BL = replacement_string

So, JACK = BLACK

JUE = BLUE

So, return string is BLACK AND BLUE

Question 55

Oracle

Question

MCQ▾

Which of the following packaged procedure is UNRESTRICTED?

Choices

Choice (4)

a.

CALL_INPUT

b.

CLEAR_BLOCK

c.

USER_EXIT

d.

EXECUTE_QUERY

Answer

c.

Explanation

Understanding of Representation Basis Understricted and Restricted Sampling
  • Unrestricted package procedure does not interfere with the basic functions of SQL ⚹ Forms
  • It can be used in any triggers.

Below gives the list of restricted and unrestricted procedure

  • Call-unrestricted
  • User Exit- Unrestricted
  • Call_query- unrestricted
  • Break-unrestricted
  • Up-restricted
  • Execute Query- Restricted
  • Message- Restricted
  • Post- Restricted
  • Exit_form-Restricted

Developed by: