Question 1

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

technology databases

FCLOSE
GET_LINE
IS_OPEN
1,2
All of the above

Answer

Correct Option: D

Question 2

Which of the following exceptions are valid regarding util_file package

technology databases

INVALID_OFFSET
VALUE_ERROR
ACCESS_DENIED
INVALID_MAXLINE_SIZE
INVALID_FILENAME

Answer

Correct Option: D

Question 3

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

technology databases

True
False

Answer

Correct Option: B

Question 4

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

technology databases

NEW_LINE
PUT
PUT_LINE
PUTF
None of the above

Answer

Correct Option: C

Question 5

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

technology databases

UTL_FILE_DIR
UTL_FILE_DIRECTORY
UTL_DIR
UTL_DIRECTORY
None of the above

Answer

Correct Option: A

Question 6

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

technology databases

32767
0
1024
1
None of the above

Answer

Correct Option: C

Question 7

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

instance
sid
serial# the session connects to
ALL

Answer

Correct Option: D

Question 8

Pick which all comments should all code adequately document ?

technology databases

revision and date of Change
reason for any change
authour name and reference to CR
ALL

Answer

Correct Option: D

Question 9

Which are appropriate scheduling tools for use in EIP database?

technology databases

CONTROL M
DBMS_JOB
DBMS_SCHEDULER
ALL

Answer

Correct Option: D

Question 10

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

technology databases

DYNAMIC PARALLELISM
HINTS
STORED OUTLINES
ALL

Answer

Correct Option: D

Question 11

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

technology databases

Create
Delete
Append
None

Answer

Correct Option: B

Question 12

On a partitioned table which index is used mostly

technology databases

Local
Global
Both
None

Answer

Correct Option: A

Question 13

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

technology databases

After
Before
In either way
Not Relevant

Answer

Correct Option: B

Question 14

If the value in a column is not unique then which index is used ?

technology databases

bitmap indexes
b*-tree indexes
composite unique index
cluster index

Answer

Correct Option: A

Question 15

Which object in PL/SQL provides encapsulation features ?

technology databases

Procedure
Package
Functions
All

Answer

Correct Option: B

Question 16

When we should truncate the working table ?

technology databases

At the end of the run
Beginning of next run
At any point of Time
Can't be done

Answer

Correct Option: B

Question 17

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

technology databases

remove
comment the code
Either of them should be fine
Don't do anything

Answer

Correct Option: A

Question 18

while making query in a partitioned table which one we should use .

technology databases

explicit reference to partitions
use the partition key in filter condition
query will automatically decide the partition
All of the above

Answer

Correct Option: B

Question 19

I/O operations on the data warehouse is expensive ?

technology databases

True
False

Answer

Correct Option: B

Question 20

SYS_CONTEXT can be used to know details about a session running the code?

technology databases

True
False

Answer

Correct Option: B

Description: databases Online Quiz - 71
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 71

Find more quizzes from top tags