4. Describe the Oracle Wait Interface, how it works, and what it provides. What are some limitations? What do the db_file_sequential_read and db_file_scattered_read events indicate?

 

The Oracle Wait Interface refers to Oracle's data dictionary for managing wait events. Selecting from tables such as v$system_event and v$session_event give you event totals through the life of the database (or session). The former are totals for the whole system, and latter on a per session basis. The event db_file_sequential_read refers to single block reads, and table accesses by rowid. db_file_scattered_read conversely refers to full table scans. It is so named because the blocks are read, and scattered into the buffer cache.

 

5. How do you return the top-N results of a query in Oracle? Why doesn't the obvious method work?

 

Most people think of using the ROWNUM pseudocolumn with ORDER BY. Unfortunately the ROWNUM is determined before the ORDER BY so you don't get the results you want. The answer is to use a subquery to do the ORDER BY first. For example to return the top five employees by salary: SELECT * FROM (SELECT * FROM employees ORDER BY salary) WHERE ROWNUM

 

6. Can Oracle's Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync?

【数据管理员面试常见七个问题】相关文章：

★ 面试英语：性格问题

★ 专家指导面试英语技巧（视频）

★ 避免简历面试中的10种陈词滥调

★ 如何巧妙回答英语面试中99%会被问到的十个问题

★ 新书披露谷歌面试怪题

★ 英语电话面试常见问题

★ 面试英语必备：外企求职面试时禁忌的问题

★ 面试英语常见15个问题及回答

★ 十招助你成功：女性面试技巧与注意事项（组图）

★ 不得不看的面试常见36个问题