Oracle Interview Questions

Q: Name the tool for tuning SQL statements.

The correct answer is EXPLAIN PLAN

Q: What is mean by PGA ?

The correct answer is Program global area

Q: Which type of index should be used on a fact table?

The correct answer is A bitmap index

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Name the tool for tuning SQL statements.

A. TUNEUP SYS

B. EXPLAIN SYS

C. DB_TUNEUP

D. EXPLAIN PLAN

Correct Answer is : EXPLAIN PLAN

2. What is mean by PGA ?

A. Program global area

B. Program given area

C. Procedure given area

D. None of these

Correct Answer is : Program global area

3. _________allow you to overload procedures or functions.

A. Packages

B. SQL

C. PL/SQL

D. classes

Correct Answer is : Packages

4. Which type of index should be used on a fact table?

A. A binary index

B. A bitmap index

C. A metadata index

D. A database schema index

Correct Answer is : A bitmap index

5. What command is used to encrypt a PL/SQL application?

A. DB_ENCRYPT

B. DBMS_ENCRYPT

C. DBMS_WRAP

D. WRAP

Correct Answer is : WRAP

Oracle interview questions