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 5059

What is Privilege Auditing ?

1 4163

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

3 5042

What is Auditing ?

3 5808

What are the different Levels of Auditing ?

1 6960

What are Roles ?

2 5018

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

1 4856

What is default tablespace ?

3 5141

What is Tablespace Quota ?

2 4734

What is a profile ?

2 4177

What is a Multi-threaded Server Configuration?

1 4333

What is Shared SQL Area?

Oracle,

1 7106

What is the function of ARCH?

3 5949

What are the functions of SMON?

7 19887

What is Dedicated Server Configuration?

IR Consulting,

2 5278

Un-Answered Questions { Oracle }

What are the types of schemas?

530

What are the differences between char and nchar in oracle?

1020

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1055

How to create an initialization parameter file?

981

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2306

How to insert a record into a table?

1018

What degree do database administrators need?

501

Oracle Data Integrator Interview Questions and answers?

598

What is a trigger oracle?

1037

What are the benefits of ordbms?

1024

What do you understand by the term 'system change number (scn)'?

524

What skills does a dba need?

536

What is meant by an index?

1057

What happens in oracle commit?

969

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

559

For More Un-Answered { Oracle } Questions Click Here