本文介绍了DBA有什么好问题?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

在Linux上使用DB2 3年后,我将离开现有的雇主

来代替SQL Server商店工作。为了找到我的

替代品,他们正试图整理一系列问题以获得

两者都能理解候选人知识的广泛性,以及如何

他们知道的DB2具体细节。在下面的问题中,你认为有多少人认为你是否有人能够保持DB2实例,并开发新结构业务

问题到了,编写有用/高效的SQL? (这些因此

范围从愚蠢到非常具体 - 有多少人觉得

实际上不公平?或者我应该从Celko得到一些问题?)

[我不是为了工作或其他招聘目的而拖网,

诚实......]


1.我'有一个2000万行的预订表,按产品,地区,日期和客户编号细分。它没有加载新数据

或很快查询。我该怎么办?

2.你喜欢存储过程吗?

3.什么是内联视图?

4.如何当GROUP BY每行给你一个总额

时,你会做一笔运行金额吗?

5.你更喜欢星型模式还是雪花模式?为什么?

6.我有一个包含三列的表:日期(日期),国家

(varchar(10)),预订(int)。

给我一个查询,告诉我在过去2周内按预订国家/地区总计

,并显示预订总数

过去两周也是。

7.你知道MQT是什么吗?

8.如果我的所有客户都被给出了描述
$的xy坐标b $ b他们家的位置(即客户的每一行都有x_coordinate

(int)和y_coordinate(int),伯明翰是(35000,55000),并且

曼彻斯特是(25000,65000),约克是(33000,70000),然后,假设欧几里德几何,

,给我一个针对

客户的WHERE条款表只返回住在伯明翰北部的客户

以及通过约克和曼彻斯特的一条线的南边。

9.我有两套同样的客户15列。什么是

最好的方式只返回两组中的客户,对于谁来说两个数据的数据是相同的?

10给我一个方法让数据库每天检查一下如果

与去年相比出现了令人惊讶的销售情况

同时。 />
11. DB2 UDB LUW 8.1.4。在接下来的六个月中,每天需要创建十个新表格,并且每天创建自动例程并设置自动例程,以便在创建后每天加载
。您是公司中唯一负责管理数据库的人员。你使用DMS或短信

表空间吗?为什么?

12.你的经理写了一些代码,'应该花5分钟来运行'b $ b $'。这需要4个小时。你是做什么的?

13.多维数据集视图?

14.你最自豪的是你写的SQL是什么?

15. HADR与RAC相比有哪些缺点?

16. SQL Server联合与DB2 Information Integrator - 任何

的想法?

谢谢


JCSJF

After 3 years of using DB2 on Linux, I''m leaving my current employers
to go work for a SQL Server shop instead. In order to find my
replacement, they''re trying to put together a set of questions to get
both some understanding of how wide candidates knowledge is, and how
much DB2 specifics they know. Of the questions below, how many do you
think are useful in determining if you''ve got somebody capable of
keeping a DB2 instance up, developing new structures as new business
problems arrive, and writing useful/performant SQL? (these therefore
range from the inane to quite specific - how many do people feel are
actually unfair? or should I just get some questions from Celko?)
[I''m not trawling for a job or for other recruitment purposes here,
honest...]

1. I''ve got a bookings table with 20 million rows, broken down by
product, region, date and customer number. It''s not loading new data
or querying very quickly. What should I do?
2. Do you like stored procedures?
3. What''s an inline view?
4. How do you do a running sum when GROUP BY just gives you a total
per row?
5. Do you prefer star schemas or snowflake schemas? Why?
6. I have a table with three columns: date (date), country
(varchar(10)), bookings (int).
Write me a query that gives me a total by country of bookings made
in the last 2 weeks, AND that displays the total number of bookings
made in the last 2 weeks too.
7. Do you know what an MQT is?
8. If all my customers have been given x-y coordinates that describe
the position of their house (ie every line in customer has x_coordinate
(int) and y_coordinate (int), and Birmingham is at (35000, 55000), and
Manchester is at (25000, 65000) and York is at (33000, 70000), then,
assuming Euclidean geometry, give me a WHERE clause against the
customer table to return only customers who live north of Birmingham
and south of a line that passes through both York and Manchester.
9. I have two sets of customers with the same 15 columns. What''s the
best way to return only those customers that are in both sets, for whom
the data is the same in both sets?
10. Give me a way to get the database to check on a daily basis if
something surprising is happening to sales when compared with last year
at the same time.
11. DB2 UDB LUW 8.1.4. For the next six months, ten new tables need
to be created every day and automated routines set up to load them
every day after they''re created. You are the only person in the company
responsible for administering the database. Do you use a DMS or SMS
tablespace? Why?
12. Your manager has written some code that ''should take 5 minutes to
run''. It takes 4 hours. What do you do?
13. Cube Views?
14. What SQL that you''ve written are you most proud of?
15. What are the disadvantages of HADR vis a vis RAC?
16. SQL Server federation vs DB2 Information Integrator - any
thoughts?
Thanks

JCSJF

推荐答案



大多数问题都是非常开放的,非常主观,我怀疑

从答题纸上阅读答案的人将能够理解同样有效的答案并且不同意答案表。


这些问题似乎高度倾向于决策支持数据库,但

也许你正在寻找拥有这些技能的人。但是,如果你是,我不会看到任何有关内部或内部分区并行性的问题,这比你提出的大多数问题更重要。

。 br />

似乎有很多关于复杂SQL的问题。您是在寻找DBA

还是SQL人员?


如果您正在寻找DB2 DBA,他们需要了解Oracle吗? />
RAC?


BTW,DB2中的内联视图是什么?

Most of the questions are very open-ended and highly subjective, and I doubt
that the person reading the answers from an answer sheet will be able to
understand equally valid answers that don''t agree with the answer sheet.

The questions seem highly skewed toward decision support databases, but
maybe you are looking for someone with those skills. But if you are, I don''t
see any questions about intra or inter partition parallelism which is much
more important than most of the questions you asked..

Seem to be a lot of questions about complex SQL. Are you looking for a DBA
or an SQL person?

If you are looking for a DB2 DBA, whey do they need to know about Oracle
RAC?

BTW, what is an inline view in DB2?




如果你认为这些问题足够了,祝你好运。我有一个

认证的DBA,他不能在键盘前蹲下。

If you think these questions are going to be enough, good luck. I have a
certified DBA who can''t do squat in front of a keyboard.




嗯。 OP列出的所有问题都与IBM在DB2 DBA认证测试中的问题无关。


如果您的DBA不能在前面蹲下键盘,是因为他们没有b / b Linux / UNIX,vi等,或者其他一些原因。

Hmm. None of the questions the OP listed is anything like those on the IBM
DB2 DBA Certification test.

If your DBA can''t do squat in front of keyboard, is that because they don''t
Linux/UNIX, vi, etc, or some other reason.


这篇关于DBA有什么好问题?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-15 19:18
查看更多