|
|---|
|
|
|
|
|
|
n****g
发帖数: 76 | 1 【 以下文字转载自 JobHunting 讨论区,原文如下 】
发信人: njying (嘟嘟), 信区: JobHunting
标 题: 朋友传给我的INTERVIEW问题2...SQL
发信站: The unknown SPACE (Tue Jan 28 18:44:49 2003) WWW-POST
1. There is a table 'T' with order ids ('oi') and customer ids ('ci'). Each
order only belongs to a single customer and each customer may have multiple
orders. How do you find how many orders each customer has? Please provide
the SQL.
2. Users report that the server has become non-responsive. What are the
possible explanations, and how do | a*****i
发帖数: 4391 | 2
SELECT COUNT(oi) FROM T GROUP BY ci ?
That depends on what he means by "non-responsive" bah.
Isolation level.
Not sure why they might occur in a simple situation. Never had one in my
life.:)
【在 n****g 的大作中提到】
: 【 以下文字转载自 JobHunting 讨论区,原文如下 】
: 发信人: njying (嘟嘟), 信区: JobHunting
: 标 题: 朋友传给我的INTERVIEW问题2...SQL
: 发信站: The unknown SPACE (Tue Jan 28 18:44:49 2003) WWW-POST
: 1. There is a table 'T' with order ids ('oi') and customer ids ('ci'). Each
: order only belongs to a single customer and each customer may have multiple
: orders. How do you find how many orders each customer has? Please provide
: the SQL.
: 2. Users report that the server has become non-responsive. What are the
: possible explanations, and how do
| g***o
发帖数: 297 | 3
Each
multiple
provide
in
A
normally
simple
two transactions are waiting for each other when they try to act to the same
data object since DBMA will put a lock on the data object before it was
accessed by any transactions
【在 a*****i 的大作中提到】
:
: SELECT COUNT(oi) FROM T GROUP BY ci ?
: That depends on what he means by "non-responsive" bah.
: Isolation level.
: Not sure why they might occur in a simple situation. Never had one in my
: life.:)
|
|
|
|
|
|
|
|
