Database [3i Infotech Placement]: Sample Questions 226 - 227 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 226

Database
Edit

Statement

True-False▾

These following parameters are optional in init. ora parameter file

DB_BLOCK_SIZE,

PROCESSES

Answer

FALSE

Explanation

  • Init. ora or the parameter file is a simple text file that can be update by a standard editor
  • Contains various initialization parameters used while starting a database instance.
  • Recovery manager (helps in data backup recovery process) does not backup parameter file or init. ora file.
  • DB_BLOCK_SIZE, PROCESSES parameter are most important part of init. ora parameter file.
  • The initialization parameter is most important part of the oracle database.

DB_BLOCK_SIZE

  • Is set to either 4k or 8k
  • Different from operating system block size.
  • Maximum value of DB_BLOCK_SIZE is 16 kb.

Processes Parameter

  • Determines maximum number of operating system process that can connect to oracle concurrently.
  • The value of processes parameter is 5 for background process.

Question 227

Database

Question

MCQ▾

TRANSLATE ( ‘333SQD234’ , ‘0123456789ABCDPQRST’ , ‘0123456789’ ) will return

Choices

Choice (4)

a.

333234

b.

234333

c.

333333

d.

None of the above

Answer

a.

Explanation

  • TRANSLATE function replaces one set of characters in a string with another set of characters.
  • Perform the replacement in sequence, one character at a time, matching the character replaced with the replacement character.
  • Allows for multiple target for the replacement to perform on.
  • Replace the 1st character in the string_to_replace with the 1st character in the replacement_string.
  • Replace the 2nd character in the string_to_replace with the 2nd character in the replacement_string, and so on.
  • TRANSLATE function return a string value.
  • Extra characters appear in char, they are removed from the return value.
  • Cannot use an empty string for to_string to remove all characters in from_string from the return value.
  • If the function is null then argunment is null.

    Syntax

    TRANSLATE (string1, string_to_replace, replacement_string)

    EX

    TRANSLATE ( ‘333SQD234’ , ‘0123456789ABCDPQRST’ , ‘0123456789’ )

    string1 = 333SQD234

    string_to_replace = 0123456789ABCDPQRST

    replacement_string = 0123456789

    So, return will 333234

  • Because, Extra characters appear in char, they are removed from the return value.

Developed by: