Oracle Interview Questions | Snaprecruit.com
Oracle Interview Questions | Snaprecruit.com
JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing
Enterprises
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
Title
Location
Find Jobs