各位高手帮我分析几道题，据说是某个公司的笔试题目。（感激！回复既有分数）
1. What are the three major theoretical characteristics of an RDBMS?
A. Integrity rules
B. Records
C. Fields
D. Structures
E. Operations
F. Instances
2. There are four categories of SQL operations, Which is the category for operations that include REVOKE, ALTER USER and GRANT?
A. DML(Data Manipulation Language)
B. TCO(Transaction Control Operations)
C. DDL(Data Definition Language)
D. DCL(Data Control Language)
3. Which character function would you use to return a specified portion of a character string?
A. CONCAT
B. SUBSTR
C. LENGTH
D. INITCAP
4. There are four set operations, which one would show common results from queries A and B?
E. COMMON
F. MINUS
G. INTERSET
H. UNION ALL
I. UNION
5. You are evaluating a procedure that has the function MOD(100, 10). What would be the result?
A. 10
B. 1000
C. 10000
D. 100
E. 0
6. You encounter the following statements:
SELECT e1.ename||’works for ‘||e2.ename “Employees and their Managers”FROM emp e1, emp e2 WHERE e1.mgr =e2.empno; What kind of join is this?
A. Cartesian
B. Equi
C. Self
D. Outer
7. Evaluate the following statement
SELECT qty FROM sales WHERE rate IN (300, 800);
Which operator among the following could be used to substitute the ‘IN’operator?
A. AND
B. BETWEEN ..AND
C. LIKE
D. >=
E. OR
F. <=
8. One is the default length value for which column?
A. CHAR
B. VARCHAR2
C. NUMBER
D. DATE
9. What does the following statement accomplish?
CREATE PUBLIC SYNONYM emp FOR john.employee;
A. New object privilege was assigned
B. System privilege was created
C. Need to use an object name with its schema was eliminated
D. None of above
10. Which of the following commands cause an implicit COMMIT?
A. ALTER
B. GRANT
C. UPDATE
D. COMMIT
E. INSERT
F. CREATE
问题点数：0、回复次数：9Top
1 楼goldly（路人乙）回复于 2004-08-02 13:49:45 得分 0
下面是偶的答案，欢迎拍砖。
Top
2 楼goldly（路人乙）回复于 2004-08-02 15:43:30 得分 0
下面是偶的答案，欢迎拍砖。
1. ADE
2. A
3. B
4. F
5. E
6. C
7. B
8. A
9. A
10. ABF
Top
3 楼goldly（路人乙）回复于 2004-08-02 16:07:26 得分 0
顶一个！Top
4 楼netjia（风中流浪）回复于 2004-08-02 17:05:28 得分 0
不怎么明白
顶哦~Top
5 楼goldly（路人乙）回复于 2004-08-02 21:30:38 得分 0
up!!!Top
6 楼ineedtostudy（amei）回复于 2004-08-02 22:39:28 得分 0
2:c
7:e
8:c
继续欢迎拍砖Top
7 楼goldly（路人乙）回复于 2004-08-02 23:19:59 得分 0
2 D
7 E
8 ATop
8 楼dinya2003（OK）回复于 2004-08-03 07:39:33 得分 0
我来看看大家做题,学习.Top
9 楼bzszp（SongZip）回复于 2004-08-03 10:19:32 得分 0
4:G
10:13:28 SQL> select distinct upper(b) from tb_1;
UPPER(B)
----------
8
9
A
C
G
T
已选择6行。
已用时间: 00: 00: 00.31
10:13:43 SQL> select distinct upper(col1) from tb;
UPPER(COL1
----------
A
B
C
已用时间: 00: 00: 00.00
10:13:53 SQL> select distinct upper(col1) from tb
10:13:56 2 intersect
10:13:58 3 select distinct upper(b) from tb_1;
UPPER(COL1
----------
A
C
已用时间: 00: 00: 00.15
10:14:01 SQL>Top
