数据管理员面试7个顶级问题
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 < 5;
--------------------------------------------------------------------------------
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?
Oracle's Data Guard technology is a layer of software and automation built on top of the standby database facility. In Oracle Standard Edition it is possible to be a standby database, and update it manually. Roughly, put your production database in archivelog mode. Create a hotbackup of the database and move it to the standby machine. Then create a standby controlfile on the production machine, and ship that file, along with all the archived redolog files to the standby server. Once you have all these files assembled, place them in their proper locations, recover the standby database, and you're ready to roll. From this point on, you must manually ship, and manually apply those archived redologs to stay in sync with production.
To test your standby database, make a change to a table on the production server, and commit the change. Then manually switch a logfile so those changes are archived. Manually ship the newest archived redolog file, and manually apply it on the standby database. Then open your standby database in read-only mode, and select from your changed table to verify those changes are available. Once you're done, shutdown your standby and startup again in standby mode.
--------------------------------------------------------------------------------
7. What is a database link? What is the difference between a public and a private database link? What is a fixed user database link?
A database link allows you to make a connection with a remote database, Oracle or not, and query tables from it, even incorporating those accesses with joins to local tables.
A private database link only works for, and is accessible to the user/schema that owns it. Any user in the database can access a global one. A fixed user link specifies that you will connect to the remote db as one and only one user that is defined in the link. Alternatively, a current user database link will connect as the current user you are logged in as.
- 上一篇：外企英语面试口语从容过关
《数据管理员面试7个顶级问题》相关文章
- 数据管理员面试7个顶级问题
- › 数据管理员面试7个顶级问题
- 在百度中搜索相关文章：数据管理员面试7个顶级问题
- 在谷歌中搜索相关文章：数据管理员面试7个顶级问题
- 在soso中搜索相关文章：数据管理员面试7个顶级问题
- 在搜狗中搜索相关文章：数据管理员面试7个顶级问题
