Oracle Interview Questions

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

Oracle interview questions

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.

2. What is mean by PGA ?

3. _________allow you to overload procedures or functions.

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

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

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit

Download mobile appsJust Swipe to apply for jobs. Try it out !