头牌英语网
投稿 图站地图 栏目RSS 情感美文 开心笑话
英语自我介绍英语求职信英语求职简历英语面试技巧面试英语英语面试职场口语职场法则职场新人职场写作人际关系职场规划辞职跳槽转行升职加薪谈判篇用英语自我介绍英语面试题
首页 > 求职英语 > 英语面试题 >英语面试题: 数据管理员面试7个顶级问题

英语面试题广告

英语面试题: 数据管理员面试7个顶级问题

[英语面试题]      来源:

Interview Questions with Top Answers
英语面试题附高分答案:

Seven Interview Questions for Data Base Administrators


1. Why is a UNION ALL faster than a UNION?

The union operation, you will recall, brings two sets of data together. It will not, however, produce duplicate or redundant rows. To perform this feat of magic, a SORT operation is done on both tables. This is obviously computationally
intensive, and uses significant memory as well.

A UNION ALL conversely just dumps collection of both sets together in random order, not worrying about duplicates.


2. What are some advantages to using Oracle's CREATE DATABASE statement to create a new database manually?

• You can script the process to include it in a set of install scripts you deliver with a product.
• You can put your create database script in CVS for version control, so as you make changes or adjustments to it, you can track them like you do changes to software code.
• You can log the output and review it for errors.
• You learn more about the process of database creation, such as what options are available and why.


3. What are three rules of thumb to create good passwords? How would a DBA enforce those rules in Oracle? What business challenges might you encounter?

Typical password cracking software uses a dictionary in the local language, as well as a list of proper names, and combinations thereof to attempt to guess unknown passwords. Since computers can churn through tens of thousands of attempts quickly, this can be a very effective way to break into a database. A good password therefore should not be a dictionary word; it should not be a proper name, birthday, or other obvious guessable information. It should also be of sufficient length, such as eight to 10 characters, including upper and lowercase, special characters, and even alternate characters if possible.

Oracle has a facility called password security profiles. When installed they can enforce complexity, and length rules as well as other password related security measures.

In the security arena, passwords can be made better, and it is a fairly solvable problem. What about in the real world? Often the biggest challenge is in implementing a set of rules like this in the enterprise. There will likely be a lot of resistance to this, as it creates additional hassles for users of the system who may not be used to thinking about security seriously. Educating business folks about the real risks, by coming up with real stories of vulnerabilities and break-ins you've encountered on the job, or those discussed on the internet goes a long way towards emphasizing what is at stake.



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 < 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.

As you prepare for your DBA Interview, or prepare to give one, we hope these questions provide some new ideas and directions for your study. Keep in mind that there are a lot of directions an interview can go. As a DBA, emphasize what you know, even if it is not the direct answer to the question, and as an interviewee, allow the interview to go in creative directions.

In the end, what is important is potential or aptitude, not specific memorized answers. So listen for problem-solving ability, and thinking outside the box, and you will surely find or be the candidate for the job.


 职场英语网   编辑   Elbert       交流摘引请注明来源

英语面试题: 数据管理员面试7个顶级问题文章来源头牌英语[英语面试题]
版权声明:头牌英语站内内容由会员投稿或收集整理自网络,如非特别声明版权归原作者与本站共同所有,转载请注明出处。英语面试题: 数据管理员面试7个顶级问题发布在[英语面试题]分类。 头牌英语网始于2007年,主体内容由无数网友共同努力建成。如果您有优秀的英语文章或英语资料欢迎向本站投稿.
英语面试题:那些公众人
英语面试题:谈谈你的长
英语面试题:你认为自己
英语面试题:你如何应对
英语面试题:你的朋友怎
  • 英语面试题:你喜欢团队还是独自
  • 英语面试题:你为啥离婚/从中学
  • 英语面试题:描述一下什么样的工
  • 英语面试题:你擅长团队管理吗
  • 英语面试题:你如何应对工作中的
  • 英语面试题:你是一个有创新精神
  • 英语面试题:你有驾照吗?
  • 英语面试题:你买人寿保险了吗?
  • 英语面试题:你和家人在一起的时
  • 英语面试题:遇到问题你如何行动
  • 英语面试题:你有储蓄规划吗?
  • 英语面试题:你对细节感到厌烦吗
  • 英文简历秘笈:二 简历内容应写
  • 英语面试题:你计划在我公司待多
  • 英语面试题:你在什么大学学习过
  • 英语面试题:你买房了还是租房呢
  • 英语面试题:商界有没有激励你的
  • 英文简历秘笈:四 求职者最常犯
  • 英语面试题:你和父母合住吗?
  • 英语面试题:请列举能激发你的五
  • 英语面试题:请说出三种你有偏好
  • 英语面试题:你在失望中学到了什
  • 英语面试题:什么样的人会让你失
  • 英语面试题:作为经理,咋和员工友
  • 英语面试题:面对团队或听众发言
  • 英语面试题:你到别的公司干不更
  • 英语面试题:你对小型公司有什么
  • 英文求职信范例二 Letter of
  • 英文求职信范例一 Letter of
  • 英语面试题:你怎样看待公司章程
  • 英语面试题:你怎样对待上司的无
  • 英语面试题:你为什么对这个工作
  • 英语面试题:你现在有改变职业行
  • 英语面试题:你为什么申请此工作
  • 英语面试题:你做过的最傻的事是
  • 英语面试题:你希望自己墓碑上刻
  • 英语面试题: 数据管理员面试7
  • 英语面试题:你认为你的老板如何
  • 英语面试题:你怎样看待晋升机会
  • 英语面试题:你开车吗?
  • 英语面试题:请谈谈你对自己的看
  • 英语面试题:解聘不称职员工你用
  • 英语面试题:工作稳定性对你来说
  • 英语面试题:你负债了吗?
  • 英语面试题:部门管理中你只照章
  • 英语面试题:解决问题遇到困难怎
  • 英语面试题:你的下属认为你的缺
  • 英语面试题:遇到的最有趣的工作
  • 英语面试题:你喜欢数字还是文字
  • 英语面试题:你能和专断的人相处
  • 英语面试题:作重大决定时你是怎
  • 英语面试题:谈谈你的长远事业目
  • 英语面试题:每天重复一件事感觉
  • 英语面试题:你遇的最难决策是如
  • 英语面试题:你认为自己为什么能
  • 英语面试题:你喜欢和别人一起工
  • 英语面试题:那些公众人物是你偶
  • 英语面试题:你会讲外语吗?
  • 英语面试题:你从犯错中学到了什
  • 英语面试题:你的住处距离公司多