《续一》各位高手帮我分析几道题，据说是某个公司的笔试题目。（感激！回复既有分数）
11. SELECT lot_number “lot number,count(*) number of cars available “ FROM CAR WHERE model =’e300’ GROUP BY lot_no HAVING COUNT(*) >10 ORDER BY COUNT(*);
which clause restricts which groups are displayed?
A. SELECT lot_number ‘lot number, count(*) number of cars available’
B. WHERE model =’e300’
C. GROUP BY lot_no
D. HAVING COUNT(*) >10
12. Consider the following query.
SELECT empno, deptt
FROM employee
WHERE empno =
(SELECT empno FROM employee WHERE salary >10000 OR age <40);
which clause will cause an error?
A. SELECT empno, deptt
B. WHERE empno =
C. WHERE salary >10000 OR age<40
D. None of the above
13. Evaluate this SQL script:
CREATE ROLE payroll;
CREATE ROLE sales_dept;
CREATE ROLE inventory;
CREATE USER scott IDENTIFIED BY tiger;
GRANT SELECT ON employee TO payroll;
GRANT SELECT ON sale TO sales_dept;
GRANT payroll TO sales_dept;
GRANT sales_dept TO inventory;
GRANT inventory TO scott
/
Which tables can user SCOTT query?
A.only SALE
B.only EMPLOYEE
C.both SALE and EMPLOYEE
D.neither SALE nor EMPLOYEE
14. You used the TRUNCATE command on the INVENTORY table. Which two results are true? (Choose two).
A.The TRUNCATE command can be rolled back.
B.The INVENTORY table definition still exists.
C.The INVENTORY table definition no longer exists.
D.All INVENTORY table constraints have been dropped.
E.All INVENTORY table constraints have been disabled.
F.The storage space held by the INVENTORY table was released.
15. Given this PL/SQL block:
BEGIN
INSERT INTO employee(salary, last_name, first_name)
VALUES(35000, 'Wagner', 'Madeline');
SAVEPOINT save_a;
INSERT INTO employee(salary, last_name, first_name)
VALUES(40000, 'Southall', 'David');
SAVEPOINT save_b;
DELETE FROM employee
WHERE dept_no = 10;
SAVEPOINT save_c;
INSERT INTO employee(salary, last_name, first_name)
VALUES(25000, 'Brown', 'Bert');
ROLLBACK TO SAVEPOINT save_c;
INSERT INTO employee(salary, last_name, first_name)
VALUE(32000, 'Dean', 'Mike');
ROLLBACK TO SAVEPOINT save_b;
COMMIT;
END;
Which two changes to the database will be made permanent? (Choose two.)
A.DELETE FROM employee
WHERE dept_no = 10;
B.INSERT INTO employee(salary, last_name, first_name)
VALUE(32000, 'Dean', 'Mike');
C.INSERT INTO employee(salary, last_name, first_name)
VALUES(25000, 'Brown', 'Bert');
D.INSERT INTO employee(salary, last_name, first_name)
VALUES(40000, 'Southall', 'David');
E.INSERT INTO employee(salary, last_name, first_name)
VALUES(35000, 'Wagner', 'Madeline');
16. As user SCOTT, which information could you display by querying the ALL_CONSTRAINTS data dictionary view?
A.types of constraints on all the tables in the database
B.names of all the constraints on the tables owned by SYS
C.names of tables you can access that have a search condition
D.names of the columns in the tables you created with constraints
17. Under which circumstance should you create an index on a table?
A.The table is small.
B.The table is updated frequently.
C.A column's values are static and contain a narrow range of values.
D.Two columns are consistently used in the WHERE clause join condition of SELECT statements.
18. The PRODUCT table contains these columns:
ID NUMBER(7) PK
SALE_PRICE NUMBER(7,2)
Evaluate these two SQL statements:
1. SELECT MAX(sale_price), MIN(sale_price), AVG(sale_price)
FROM product;
2. SELECT ROUND(MAX(sale_price),2), ROUND(MIN(sale_price),2), ROUND(AVG(sale_price),2)
FROM product
GROUP BY sale_price;
How will the results differ?
A.One of the statements will generate an error.
B.Statement 1 will display three values; statement 2 will display three values for each sale price.
C.Statement 2 will only display one row of results; statement 1 could display more than one.
D.Statement 1 will display a result for each sale price; statement 2 will display a result for each product.
19. Which three commands cause a transaction to end? (Choose three.)
A.ALTER
B.GRANT
C.DELETE
D.INSERT
E.UPDATE
F.ROLLBACK
20. You must display a salary increase of 10% for each employee plus their total compensation which includes their salary and commission. Some employees do not receive a commission.
Review this SELECT statement:
SELECT sal * 1.10 "Salary", sal * 1.10 + comm "Total Compensation"
FROM emp;
What is the result of this statement?
A.Only the new salary of all employees is displayed.
B.The new salary and total compensation for each employee is displayed.
C.The total compensation value is not displayed for employees that do not receive a commission.
D.A zero total compensation value is displayed for employees that do not receive a commission.
问题点数：0、回复次数：16Top
1 楼bzszp（SongZip）回复于 2004-08-02 14:04:53 得分 0
D;C;C ;D;DE;D;D;B;F;CTop
2 楼dinya2003（OK）回复于 2004-08-02 15:16:46 得分 0
顶一下,反对考试.Top
3 楼goldly（路人乙）回复于 2004-08-02 15:51:31 得分 0
我的答案：
D、B、C、BF、DE、？、D、B、ABF、DTop
4 楼goldly（路人乙）回复于 2004-08-02 15:52:53 得分 0
解释一下，不是考试。
什么考试现在考啊？
是我同学给我发的一个大公司的笔试的题目，只是希望大家参与一下，共同提高。Top
5 楼goldly（路人乙）回复于 2004-08-02 16:12:20 得分 0
顶一下。Top
6 楼LGQDUCKY（飘）回复于 2004-08-02 17:16:00 得分 0
14. You used the TRUNCATE command on the INVENTORY table. Which two results are true? (Choose two).
A.The TRUNCATE command can be rolled back.
B.The INVENTORY table definition still exists.
C.The INVENTORY table definition no longer exists.
D.All INVENTORY table constraints have been dropped.
E.All INVENTORY table constraints have been disabled.
F.The storage space held by the INVENTORY table was released.
选择 BF
Top
7 楼bzszp（SongZip）回复于 2004-08-02 17:21:58 得分 0
：）申题不细，太仓促了
19题也没看见（Choose three.）
ABF
Top
8 楼goldly（路人乙）回复于 2004-08-02 21:29:49 得分 0
upTop
9 楼goldly（路人乙）回复于 2004-08-02 22:20:04 得分 0
12题感觉应该是B吧Top
10 楼ineedtostudy（amei）回复于 2004-08-02 22:50:28 得分 0
12题的b,和c都有可能的，修改任何一个均可不出错误Top
11 楼bitholywing（天空の城）回复于 2004-08-03 00:08:37 得分 0
偶觉得12题应该是b！Top
12 楼conan19771130（残疾人程序员,学习第2门外语）回复于 2004-08-03 07:35:57 得分 0
upTop
13 楼zcqq1980cn（martin）回复于 2004-08-03 08:55:13 得分 0
upTop
14 楼gzbigll（）回复于 2004-08-03 11:46:59 得分 0
顶Top
15 楼allun（allun）回复于 2004-08-03 13:52:50 得分 0
d、/、b、b、de、/、/、b、/、d
哈哈
猜猜
Top
16 楼jukyy（春天会回来）回复于 2004-08-03 14:31:11 得分 0
慢慢看。
Top
