Question 1

How many LONG columns are allowed in a table ?

technology databases

0
1
8
Any number

Answer

Correct Option: B

Question 2

The data contained in Materialized view will be deleted automatically if the base tables will be deleted?

technology databases

True
False

Answer

Correct Option: B

Question 3

Find the error in the line for the query written below?

technology databases

Line 1
Line 2
Line 3
Line 4

Answer

Correct Option: D

Question 4

Can a view be created be based on another view definition?

technology databases

True
False

Answer

Correct Option: B

Question 5

Does the view exist if the table is dropped from the database?

technology databases

True
False

Answer

Correct Option: B

Question 6

Is this a valid join condition written in the query below?

technology databases

True
False

Answer

Correct Option: B

Question 7

Can we create index on Materialized Views?

technology databases

True
False

Answer

Correct Option: B

Question 8

The RowID can be changed for the particular row whenever any insert or update operation is performed on the table?

technology databases

True
False

Answer

Correct Option: B

Question 9

Which of the following will be a better compilation methodology for a Procedure that involves only looping structures.

technology databases

NATIVE
INTERPRETTED
BOTH
NONE

Answer

Correct Option: A

Question 10

You can commit inside a trigger

technology databases

Yes, there is a workaround, but not directly
yes directly
no
I dont Know

Answer

Correct Option: A

Question 11

The keyword IS & AS in Procedure definition

technology databases

Both are same
IS will only work
AS will only work
Both cannot be used in procedure definition

Answer

Correct Option: A

Question 12

Native dynamic sql works faster than dbms_sql

technology databases

True
False

Answer

Correct Option: B

Question 13

If a procedure that has overloaded procedures is called

technology databases

Normal Procedure
Overloaded Procedure
Packaged Procedure
None of these

Answer

Correct Option: C

Question 14

Which is performance friendly

technology databases

VARRAY
PL/SQL TABLE
NESTED TABLE
NONE OF THESE

Answer

Correct Option: A

Question 15

ascii() function would display the corresponding ASCII code of the string enclosed

technology databases

True
False

Answer

Correct Option: B

Question 16

In Program overloading, You have two procedures with same name. which of the following will not work

technology databases

Having the data type different
Just interchange the input parameter
having the name diffferent
both a & b

Answer

Correct Option: B

Question 17

CURSOR FOR loop can be opened with the command...

technology databases

OPEN
FETCH
PARSE
None, cursor for loops handle cursor opening implicitly

Answer

Correct Option: D

Question 18

In Oracle 9i, we can specify the FIRING order in which the that are created on a table

technology databases

True
False

Answer

Correct Option: B

Question 19

procedure to create a customized ERROR message

technology databases

RAISE_ERROR
SQLERRM
RAISE_APPLICATION_ERROR
RAISE_SERVER_ERROR

Answer

Correct Option: C

Question 20

Which of the following is false statement of the package.

technology databases

Dependency simplified
Loaded once into memory , used subsequently
Privileges to objects cannot be controlled
Encapsulation of code logic

Answer

Correct Option: C

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

databases Online Quiz - 104

Find more quizzes from top tags