Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

What is Object Auditing ?

2 5200

What is Privilege Auditing ?

1 4253

What are the system resources that can be controlled through Profile ?

3 5205

What is Auditing ?

3 6002

What are the different Levels of Auditing ?

1 7060

What are Roles ?

2 5177

How to prevent unauthorized use of privileges granted to a Role ?

1 4959

What is default tablespace ?

3 5319

What is Tablespace Quota ?

2 4865

What is a profile ?

2 4315

What is a Multi-threaded Server Configuration?

1 4480

What is Shared SQL Area?

Oracle,

1 7276

What is the function of ARCH?

3 6123

What are the functions of SMON?

7 20266

What is Dedicated Server Configuration?

IR Consulting,

2 5427

Un-Answered Questions { Oracle }

How to run create database statement again?

1160

What are the types of windows (window style)?

Can select statements be used on views in oracle?

1027

defination of bitmap index

2131

Where in the Oracle directory tree structure are audit traces placed?

2640

List the parts of a database trigger.

1053

Why should I use oracle database?

996

how to load the data with one flat file and one rdbms table using joins?

620

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2325

Is a rollback possible to any savepoint?

1098

what are archived logs?

2203

What is a user account in oracle?

1121

If you are working Microsoft excel, which type of file you used .excel or .csv?

643

Hi Can any one tell me what are the API's used in requisition import.

1923

How can you find all the processes on your system?

573

For More Un-Answered { Oracle } Questions Click Here