向高手请教一道 007 TESTKING 试题的正确答案!!!!

benny2002

我觉得E是对的

husthxd

最初由 benny2002 发布
[B]我觉得E是对的 [/B]

group by dept_id,salary
是不对的.

rollingpig

最初由 悟不空 发布
[B]Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)
A. It releases the storage space used by the table.
B. It does not release the storage space used by the table.
C. You can roll back the deletion of rows after the statement executes.
D. You can NOT roll back the deletion of rows after the statement executes.
E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement
executes will display an error.
F. You must be the owner of the table or have DELETE ANY TABLE system privileges to
truncate the DEPT table
Answer: B, D, F


我觉得答案应该是A,D,F, 从ORACLE 官方教材看,TRUNCATE statement does release the storage space used by the table.

请教了!!
多谢! [/B]

晕
这道题目看起来只有D是对的，其他都错。
A/B
sometimes release storage,sometime not release storage.
F.You must be the owner of the table or have drop ANY TABLE system privileges to
truncate the DEPT table

更正一下
truncate 别人的table需要
drop any table 权限

rollingpig

最初由 little_soap 发布
[B]多谢！
我这还有一道题想不通，如下：

Which statement shows the department ID,minimum salary,and maximum salary paid in that department,only of the minimum salary is less than 5000 and the maximum salary is more than 15000?

A: select dept_id,min(salary(,max(salary)
     from employees
     where min(salary) <5000 and max(salary) >15000;
B: select dept_id,min(salary),max(salary)
     from employees
     where min(salary) <5000 and max(salary) >15000
     group by dept_id;
C: select dept_id,min(salary),max(salary)
     from employees
     having min(salary) <5000 and max(salary) >15000;
D: select dept_id,min(salary),max(salary)
     from employees
     group by dept_id
     having min(salary) <5000 and max(salary) <15000;
E: select dept_id,min(salary),max(salary)
     from employees
     group by dept_id,salary
     having min(salary) <5000 and max(salary) >15000;

答案是E，可我觉得没有一个答案是对的，如果D的最后一个条件是max(salary) 改为大于 15000,则D是对的。按E来执行的话则employees中的每条记录都出来了。 [/B]

题目的确是有问题。

wyq21973

TRUNCATE statement does release the storage space used by the table.
这句话的意思就是说会释放空间，你是不是把does看成了doesnot 了？

rollingpig

如果不抠字眼的话
A. It releases the storage space used by the table.
可以说是对的。
严格来说，应该是
truncate statement releases the storage space used by the table that exceed the initial extent.

wtc1967

最初由 rollingpig 发布
[B]
晕
这道题目看起来只有D是对的，其他都错。
A/B
sometimes release storage,sometime not release storage.
F.You must be the owner of the table or have alter ANY TABLE system privileges to
truncate the DEPT table [/B]

我还是觉的F是对的。查书：Delete any table :delete rows from tables,table partitions,or views in any schema
alter any table:alter any table or view in any schema

rollingpig

最初由 wtc1967 发布
[B]
我还是觉的F是对的。查书：Delete any table :delete rows from tables,table partitions,or views in any schema
alter any table:alter any table or view in any schema [/B]

呵呵
delete和truncate是两码事，你试试看就知道了。

[php]
grant resource to test1 identified by test1;
grant connect to test2 identified by test2;
create table test1.test as select sysdate as tt from dual;
grant delete any table to test2;
conn test2/test2
truncate table test1.test;
/*.....
error
....*/
conn /as sysdba
grant alter any table to test2;
conn test2/test2
truncate table test1.test;
/*.....
error
....*/
conn /as sysdba
grant drop any table to test2;
conn test2/test2
truncate table test1.test;
/* ....
success
....*/
conn /as sysdba
drop user test1 cascade;
drop user test2 cascade;
[/php]

rollingpig

汗。。。。
原来不是 alter any table
而是  drop any table

wtc1967

最初由 rollingpig 发布
[B]汗。。。。
原来不是 alter any table
而是  drop any table [/B]

Drop any table这样就对了，谢谢您的解答，受教了！