吉大11春学期《数据库应用技术》在线作业一答案
在线作业, 数据库, 单选题, 答案
一、单选题（共 25 道试题，共 100 分。）V 1.  Which of the following database resources can be freed when a unit of work is committed?
A. row locks
B. cursor names
C. buffer pools
D. cursors WITH HOLD
      满分：4  分
2.  Which of the following will retrieve results that will only be in lower case?
A. SELECT NAME FROM EMPLOYEE WHERE NAME='ali'
B. SELECT NAME FROM EMPLOYEE WHERE LCASE(NAME)='ali'
C. SELECT UCASE(NAME) FROM EMPLOYEE WHERE LCASE(NAME)='ali'
D. SELECT NAME FROM EMPLOYEE WHERE NAME IN (SELECT NAME FROM EMPLOYEE WHERE LCASE(NAME)=LCASE('ALI'))
      满分：4  分
3.  下列SQL语句中，能够实现”收回U4对学生表(STUD)中学号(XH)的000权”这一功能的是以下哪项？
A. REVOKE UPDATE(XH) ON TABLE FROM U4
B. REVOKE UPDATE(XH) ON TABLE FROM PUBLIC
C. REVOKE UPDATE(XH) ON STUD FROM U4
D. REVOKE UPDATE(XH) ON STUD FROM PUBLIC
      满分：4  分
4.  Given the table T1 with the following data: C1 --- ABC DE and the application code: EXEC SQL DECLARE cur1 CURSOR WITH HOLD FOR SELECT c1 FROM t1 ORDER BY c1 EXEC SQL DECLARE cur2 CURSOR WITH HOLD FOR SELECT c1 FROM t1 ORDER by c1 EXEC SQL OPEN cur1 EXEC SQL OPEN cur2 EXEC SQL FETCH cur1 INTO :hv EXEC SQL FETCH cur1 INTO :hv EXEC SQL FETCH cur2 INTO :hv EXEC SQL COMMIT EXEC SQL FETCH cur2 INTO :hv EXEC SQL FETCH cur2 INTO :hv EXEC SQL FETCH cur1 INTO :hv EXEC SQL CLOSE cur2 EXEC SQL CLOSE cur1 What is the final content of the host variable "hv"?
A. A
B. B
C. C
D. D
      满分：4  分
5.  Given the EMPLOYEE table definition: CREATE TABLE employee ( workdept CHAR(30), salary INTEGER ) Which of the following is a correct usage of parameter markers in a JDBC program?
A. String sql = "UPDATE employee SET salary=salary*?WHERE workdept=?"; statement stmt=con.createStatement(sql);
B. String sql = "UPDATE employee SET 奥鹏11春作业答案www.vu80.com *?WHERE workdept=?"; statement stmt=con.createStatement(sql);
C. String sql = "UPDATE employee SET salary=salary*?WHERE workdept=?"; statement stmt=con.createStatement(sql);
D. String sql = "UPDATE employee SET salary=salary*?WHERE workdept=?"; statement stmt=con.createStatement(sql);
      满分：4  分
6.  How many rows can be retrieved using a single SELECT INTO statement?
A. Only one row
B. As many as are in the result
C. As many as are host variables used in the call
D. As many as host variable array structures can hold
      满分：4  分
7.  Which of the following privileges is required to successfully execute a Java stored procedure that uses JDBC to update several different tables?
A. The user must have UPDATE privilege on the referenced tables.
B. The developer must have EXECUTE privilege on the stored procedure.
C. The user must have UPDATE privilege on the referenced tables and EXECUTE privilege on the stored procedure.
D. The developer must have UPDATE privilege on the referenced tables and EXECUTE privilege on the stored procedure.
      满分：4  分
8.  当数据库遭到破坏时，为了能迅速恢复，在进行事务处理过程中将对数据库更新的全部内容写入以下哪项？
A. 副本文件
B. 日志文件
C. 检查点文件
D. 死锁文件
      满分：4  分
9.  Given an ODBC/CLI program with a single connection, two threads and the following actions which complete successfully: Thread 1: INSERT INTO mytab VALUES (1) Thread 2: INSERT INTO mytab VALUES (2) Thread 1: COMMIT Thread 2: INSERT INTO mytab VALUES (3) Thread 1: ROLLBACK Thread 2: COMMIT How many records will be inserted and retained in the table MYTAB?
A. 0
B. 1
C. 2
D. 3
      满分：4  分
10.  在语句CREATE VIEW EMP_VIEW2 (EMPNO, EMPNAME, DEPTNO, JOBTITLE, HIREDATE) AS SELECT ID, NAME, DEPT, JOB, HIREDATE FROM EMPLOYEE WHERE DEPT=10 WITH CHECK OPTION; 所定义的视图中，当使用INSERT语句时，若新增的行中DEPTNO数值不为10，则该行将被拒绝插入。
A. 正确
B. . 错误
      满分：4  分
11.  To prepare an embedded SQL program for use with a host-language compiler, which of the following database components is required?
A. Binder
B. Precompiler
C. Stored Procedure Builder
D. Application Development Center
      满分：4  分
12.  Under which of the following situations must dynamic SQL be used?
A. When temporary table references exist at compile time
B. When the host variables' values are unknown at compile time
C. When the columns in the SELECT clause are unknown at compile time
D. When the number of rows being returned are unknown at compile time
      满分：4  分
13.  缺省的数据库日志文件的类型是：
A. Circular Log
B. Archival Log
C. Primary Log
D. Secondary log
      满分：4  分
14.  关系数据库管理系统应能实现的专门关系运算包括（）
A. 排序、索引、统计
B. 选择、投影、连接
C. 关联、更新、排序
D. 显示、打印、制表
      满分：4  分
15.  下列那种隔离级对于只读操作不在数据行上加锁？
A. RR
B. RS
C. CS
D. UR
      满分：4  分
16.  Given the tables T1 and T2 with INTEGER columns: T1 COL1 ----------- 1- 1- 22 T2 COL1 ----------- 1- 2- 22 and the following statement that executes successfully: DELETE FROM t1 WHERE col1 IN (SELECT * FROM t2) How many rows will be left in T1 after running this statement?
A. 0
B. 2
C. 3
D. 6
      满分：4  分
17.  Given the tables T1 and T2, each containing an integer column COL1: T1 COL1 ----------- 1- 1- 22 T2 COL1 ----------- 1- 2- 22 and the following query that executes successfully: SELECT COUNT(*) FROM t1 RIGHT OUTER JOIN t2 ON t1.col1=t2.col1 How many rows are returned?
A. 1
B. 6
C. 8
D. 36
      满分：4  分
18.  Which of the following methods must be used for deleting a row using the Statement interface in JDBC?
A. delete()
B. execute()
C. executeUpdate()
D. executeDelete()
      满分：4  分
19.  对于UNIX和Intel平台上的数据库应用，如果需要存取OS/400、VM/VSE和OS/390系统上的数据库，需要DB2哪种产品的支持？
A. DB2 Connect
B. DB2 DataPropagator
C. DB2 Net.Data
D. DB2 DataJoiner
E. DB2 Relational Connect
      满分：4  分
20.  Which of the following is TRUE for all cursors defined as FOR FETCH ONLY?
A. The cursors are unambiguous.
B. Only the first row is returned.
C. Cursor stays open after a commit.
D. A temporary table is created on the server.
      满分：4  分
21.  定义基本表时，若要求某一列的值不能为空，则应在定义时使用什么保留字？但如果该列是主键，则可省写。
A. NULL
B. NOT NULL
C. DISTINCT
D. UNIQUE
      满分：4  分
22.  Given the tables, the relationships and the statements: EMPLOYEE DEPT emp_num emp_name dept dept_id dept_name 1 Adams 1 1 Planning 2 Jones 1 2 Support 3 Smith 2 4 Williams 1 Relationship: employee.dept is a foreign key on dept.dept_id. stmt="INSERT INTO employee VALUES (5,'jones',3)"; EXEC SQL EXECUTE IMMEDIATE :stmt; stmt="INSERT INTO employee VALUES (6,'jhonson',2)'; EXEC SQL EXECUTE IMMEDIATE :stmt; How many rows are successfully inserted?
A. One row is inserted in EMPLOYEE
B. No rows are inserted in EMPLOYEE
C. Two rows are inserted in EMPLOYEE
D. One row is inserted in DEPT and 2 rows are inserted in EMPLOYEE
      满分：4  分