Sign Up Login


  1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

How do you analyze table partition using oracle provided package?

 354

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

 504

What is oracle partial backup?

 402

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

 369

How do you put database is archivelog mode, explain procedure?

 397

Do you need a commit after ddl statements?

 390

Explain the wait events in statspack report 'enqueue'?

 381

What is the difference between raid 5 and raid 10? Which is better for oracle?

 412

What is the difference between truncate and delete? Why is one faster?

 387

Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?

 354

What are bind variables and why are they important?

 367

Explain force logging feature in 9i.

 394

Which rman command is used to create an exact replica of a database innew host?

 368

What operator tests column for the absence of data?

 395

System tablespace cant be exported from one database and imported into another why?

 380

Un-Answered Questions { Oracle }

Differentiate between pre-select and pre-query?

817

What are summary column and placeholder column in reports?

1

How will you differentiate between varchar & varchar2?

785

What is varray?

772

How do I learn what codesets are available in oracle?

760

What are oracle functions?

758

how do u place it in required folder

1670

What is the function of cache fusion in oracle rac?

1

What is the difference between bind and lexical parameter?

762

How would you identify the shared_pool_size parameter that needs to be adjusted?

1

what is insert all statement in sql

5918

How many memory layers are in the oracle shared pool?

843

How to create tables for odbc connection testing?

700

What is an Oracle Rollback Segment?

857

What is an oracle database table?

756

For More Un-Answered { Oracle } Questions Click Here