Piner's Oracle DBA interview questions!

Why check points must occur when the database switches logs? What is the significance of this checkpoint?

Which of the following table space management methods are available.

Differences between local indexes and global indexes and their applicability.

A table A varchar2 (1), B number (1), c char (2) has 100000 records, and B-tree indexes are created on field, WHO is the largest table and index? Why?

9i data guard has several modes. What are their differences.

What is an execution plan and how to view it.

Briefly describe the difference between nest loop and hash join.

The difference between DB file sequential read and DB file scattered read waits. If there are many waits, What are the problems?

What are the waiting events of the library cache pin and library cache lock?

In a 24*7 Application, you need to change the common index (A, B) of a table with a large access volume of more than 10 million of the data level to a unique constraint (A, B, c). You generally choose how to do this. Please explain the specific operation steps and statements.

If an Oracle database system on Linux suddenly slows down, you can find the cause from where.

Describe the knowledge of RAID5 and raid01/10.

List 5 new 10 Gb features

 

Http://www.itpub.net/showthread.php? S = & postid = 6204369 # post6204369