0

databases Online Quiz - 71

Description: databases Online Quiz - 71
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

  1. FCLOSE

  2. GET_LINE

  3. IS_OPEN

  4. 1,2

  5. All of the above


Correct Option: D

Which of the following exceptions are valid regarding util_file package

  1. INVALID_OFFSET

  2. VALUE_ERROR

  3. ACCESS_DENIED

  4. INVALID_MAXLINE_SIZE

  5. INVALID_FILENAME


Correct Option: D

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

  1. True

  2. False


Correct Option: B

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

  1. NEW_LINE

  2. PUT

  3. PUT_LINE

  4. PUTF

  5. None of the above


Correct Option: C

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

  1. UTL_FILE_DIR

  2. UTL_FILE_DIRECTORY

  3. UTL_DIR

  4. UTL_DIRECTORY

  5. None of the above


Correct Option: A

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

  1. 32767

  2. 0

  3. 1024

  4. 1

  5. None of the above


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 ?

  1. instance

  2. sid

  3. serial# the session connects to

  4. ALL


Correct Option: D
  1. revision and date of Change

  2. reason for any change

  3. authour name and reference to CR

  4. ALL


Correct Option: D

Which are appropriate scheduling tools for use in EIP database?

  1. CONTROL M

  2. DBMS_JOB

  3. DBMS_SCHEDULER

  4. ALL


Correct Option: D

What can be used to optimize the performance of simple SQL?

  1. DYNAMIC PARALLELISM

  2. HINTS

  3. STORED OUTLINES

  4. ALL


Correct Option: D

COMPLETE REFRESH by default will _________________all rows in an mview before inserting new rows

  1. Create

  2. Delete

  3. Append

  4. None


Correct Option: B

Indexes and statistics are built ________________ the exchange of the exchange table ?

  1. After

  2. Before

  3. In either way

  4. Not Relevant


Correct Option: B
  1. bitmap indexes

  2. b*-tree indexes

  3. composite unique index

  4. cluster index


Correct Option: A

Which object in PL/SQL provides encapsulation features ?

  1. Procedure

  2. Package

  3. Functions

  4. All


Correct Option: B

When we should truncate the working table ?

  1. At the end of the run

  2. Beginning of next run

  3. At any point of Time

  4. Can't be done


Correct Option: B

If you need remove code from a script, including PL/SQL, what you will do?

  1. remove

  2. comment the code

  3. Either of them should be fine

  4. Don't do anything


Correct Option: A
  1. explicit reference to partitions

  2. use the partition key in filter condition

  3. query will automatically decide the partition

  4. All of the above


Correct Option: B
- Hide questions