Tag: databases

Questions Related to databases

If the number of leaf blocks of index , scanned is less than 5000 then degree of parallelismis 2?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

In which version release of Oracle the UTL_FILE package was released?
technology databases

  1. 7.2

  2. 7.3.6

  3. 7.3.4

  4. 7.3.1

  5. None of the above

Show answer
Correct Option: C

The exception INVALID_FILEHANDLE can occur when the following procedures are called?

technology databases

  1. FCLOSE

  2. GET_LINE

  3. IS_OPEN

  4. 1,2

  5. All of the above

Show answer
Correct Option: D

Which of the following exceptions are valid regarding util_file package

technology databases

  1. INVALID_OFFSET

  2. VALUE_ERROR

  3. ACCESS_DENIED

  4. INVALID_MAXLINE_SIZE

  5. INVALID_FILENAME

Show answer
Correct Option: D

The package util_file can be used to read the files from Windows environment true or false

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following procedure inserts terminating character when writing to a text file?

technology databases

  1. NEW_LINE

  2. PUT

  3. PUT_LINE

  4. PUTF

  5. None of the above

Show answer
Correct Option: C

What is the name of the variable that is used to set the directories in the database initialization file
technology databases

  1. UTL_FILE_DIR

  2. UTL_FILE_DIRECTORY

  3. UTL_DIR

  4. UTL_DIRECTORY

  5. None of the above

Show answer
Correct Option: A

What is the default value of the variable max_linesize in the function FOPEN?

technology databases

  1. 32767

  2. 0

  3. 1024

  4. 1

  5. None of the above

Show answer
Correct Option: C

Logging for any SQL on a RAC env what information must pass to log module for proper identification of the source of the log ?

technology databases

  1. instance

  2. sid

  3. serial# the session connects to

  4. ALL

Show answer
Correct Option: D

Pick which all comments should all code adequately document ?

technology databases

  1. revision and date of Change

  2. reason for any change

  3. authour name and reference to CR

  4. ALL

Show answer
Correct Option: D