Actualtests 1z0-007在TK 183道题基础上加了23道，但我认为里面很多错误，又没有详细

winllen

QUESTION 204:我执行的时候要拿掉所有的prefix，就是B和C一起才可以，只选其中一个还是执行不了，大家试试吧

liuqixin

非常好的东东！谢谢啦！

racoonwise

楼主厉害，够细心

winllen

184, select count(department_id) from employees
group by department_id

可以执行的，所以C是对的

nishi2b

alter session set NLS_DATE_FORMAT='yy/mm/dd'
这样的话
INSERT INTO employees (employee_id, first_name, last_name, hire_date) VALUES (1000, 'John', 'smith','01/01/01');
就插得进去了啊……

这道题有忽悠人的成分的说……

[ 本帖最后由 nishi2b 于 2009-3-24 20:47 编辑 ]

nishi2b

184 的E 是不是这个意思 ？  你只可以在整个TABLE 都GROUP 的时候 才可以使用聚合函数？

laisu521

谢谢LZ共享呀，答案里确实有很多值得商榷的地方～学习了～

losebird

很详细！

achilly

192 该选C吧，CREATE [PUBLIC] SYNONYM synonym FOR object;

jiangsuwwj

关于:
QUESTION 203:
Which three statements about subqueries are true? (Choose three.)
A.A main query can have more than one subquery.
B.A subquery can have more than one main query.
C.The subquery and main query must retrieve data from the same table.
D.The subquery and main query can retrieve data from different tables.
E.Only one column or expression can be compared between the subquery and main query.
F.Multiple columns or expression can be compared between the subquery and main query.
Answer: A, C, E
又是子查询，A同意，C明显不对，select a from b where b.c =select e.c from e应为D
我记得F可以select a from b where (a,c)in select e.a,e.c from e,见sg 18-6Multiple-Column Subqueries那E就错了
===============================================================================

我认为正确的答案是:ADF
关于F:在一个资料中我看到这样的一段话
If you want compare two or more columns. you must write a compound WHERE clause using logical operators Multiple-column subqueries enable you to combine duplicate WHERE coditions into a single WHERE clause.

Using Multiple-Column Subqueries

Display the order number, product number, and quantity of any item in
which the product number and quantity match both the product number
and quantity of an item in ordid 365.
SELECT  ordid, prodid, qty
FROMitem
WHERE  (prodid,   qty)    IN
                                        (SELECT prodid,   qty
                                         FROM        item
                                         WHERE     ordid =   365)
AND ordid   =   365 ;
ORDID  PRODID  QTY
365  84  22

当然也可以写成这样
Nonpairwise Comparison Subguery
Display the order number, product number, and quantity of any item in
which the product number and quantity match any product number and any
quantity of an item in order 605.
SELECT  ordid, prodid, qty
  FROM  item
  WHERE  prodid  IN  (SELECT  prodid
                                 FROM  Item
                                 WHERE  ordid  = 365)
  AND  qty  IN  (SELECT  qty
                            FROM  item
                            WHERE  ordid = 365)
  AND  ordid  =  365 ;
ORDID  PRODID  QTY
365  84  22