21. The following commands are issued against a data source containing table user2.org: CREATE ALIAS user1.org FOR sample.org CREATE TABLE org.sample ( c CHAR(1)) CREATE ALIAS sample.org FOR user2.org CREATE ALIAS user2.sample FOR sample.org Given the user SAMPLE issues the following statement: SELECT * FROM sample For which of the following database objects will access be attempted?
A. user2.org
B. org.sample
C. sample.org
D. sample.sample
满分:4 分
22. 两个子查询的结果(),可以执行并、交、差操作
A. 结构完全一致
B. 结构完全不一致
C. 结构部分一致
D. 主键一致
满分:4 分
23. DBMS是()
A. 操作系统的一部分
B. 在操作系统支持下的系统软件
C. 一种编译程序
D. 应用程序系统
满分:4 分
24. 定义基本表时,若要求某一列的值不能为空,则应在定义时使用什么保留字?但如果该列是主键,则可省写。
A. NULL
B. NOT NULL
C. DISTINCT
D. UNIQUE
满分:4 分
25. Which of the following produces a sequentially increasing number, suitable for use as a primary key?
A. ROWID data type
B. Generated IDENTITY column
C. GENERATE_UNIQUE built-in function
D. CURRENT SEQUENCE special register
满分:4 分



