JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing Firm
Direct Client
Oracle interview questions
Oracle interview questions
Back
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
Program global area
3. _________allow you to overload procedures or functions.
A. Packages
B. SQL
C. PL/SQL
D. classes
Show Correct Answer
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
Show Correct Answer
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
Show Correct Answer
Correct Answer is :
WRAP
Similar Interview Questions
Search for latest jobs
Find Jobs