更多"Oracle 9i共有三种版本，分别为：个人版（Personal Ed"的相关试题:
[填空题]Oracle9i是指Oraclc9i数据库、Oracle9i自（）和Oracle9iDeveloperSuite的完整集成。
[单项选择]Oracle9i数据库使用的I/O最小单位是（）。
A. Block
B. Extent
C. Tablespace
D. Segment
[单项选择]以下关于ORACLE9i的叙述正确的是（）
A. ORACLE9i是一种关系型数据库服务器产品，是在ORACLE8i的基础上发展起来的。
B. Oracle9i Application Server（AS）是一种面向Internet应用的数据库服务器。
C. Oracle9i Developer Suite（DS）是一套面向于NET框架结构的开发工具集。
D. ORACLE9i数据库服务器要在ORACLE9iAS和ORACLE9iDS的配合下才能提供服务。
E. 以上所述都不正确
[单项选择]安装oracle9i数据库的配置文件名（）
A. tnsname.ora
B. tnsnames.ora
C. tnsname.ini
D. tnsnames.ini
[简答题]在Win2003Service操作系统下，如何正确卸载Oracle9i？
[单项选择]在Oracle 9i中导入导出功能要完成的主要工作是（）。
A. 完成不同格式的数据库之间的相互转换
B. 完成数据的备份功能
C. 完成数据的校验功能
D. 完成数据的传输功能
[单项选择]ORACLE9i数据库服务器不能在下列哪个OS平台上安装运行（）
A. Windows NT
B. Windows 2000
C. Windows 98
D. SCO UNIX
E. Redhat Linux
[多项选择] Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing thedbms_redefinition_start_redef table procedure call？（）
A. Grand privileges on the interim table.
B. Invoke the dbms_redefinition.can_redef_table procedure.
C. Invoke the dbms_redefinition.sync_interim_table procedure.
D. Create any triggers， indexes， or constraints on the interim table.
E. Create an empty interim table with all the desired characteristics.
[填空题]在Oracle 9i内提供了一套具有图形用户界面的数据库管理工具（）。
[单项选择]Oracle9i offers the ability to monitor the dynamic use of the SGA through the DB_CACHE_ADVICE parameter. When this parameter is set to READY， what is its effect？ （）
A. The Advisory is on and will capture both CPU and memory overhead.
B. The Advisory is on but the memory for the Advisory is not allocated.
C. The Advisory is off and the memory for the Advisory is not allocated.
D. The Advisory is off but the memory for the Advisory remains allocated.
[单项选择]Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）
A. No literal value is substituted for a shared cursor.
B. Different execution plans are generated for substituted literal values.
C. The substitution of a literal value will produce different execution plans.
D. The substitution of any literal value will produce exactly the same execution plan.
[单项选择]What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）
A. The filename format.
B. Information stored inside a data dictionary table.
C. Information stored in the ALERT.LOG file for the corresponding instance.
D. Information stored inside the corresponding initialization parameter file for the instance.
[简答题]分别写出在oracle 9i数据库中实现以下功能的sql语句：查找当前系统时间。
[单项选择]When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）
A. During a query’s parse time only.
B. During a query’s execution time only.
C. During any kind of DML statement execution.
D. During the execution of an INSERT statement only.
[单项选择]当在WINDOWS平台上安装并运行ORACLE9i服务器后，可通过WINDOWS服务窗口来查看其服务情况，以下哪一个是数据库服务项（假定服务器的SID为ORA92）（）
A. OracleORA92ManagementServer
B. OracleORA92Agent
C. OracleORA92HTTP
D. OracleORA92TNSListener
E. OracleServiceORA92
[判断题]税控收款机管理系统数据库采用oracle9i，一主一备方式进行双机热备。
[单项选择]在缺省安装oracle9i时，会安装XML数据库。XML启动了一个HTTP服务，占用了8080端口，会与（）冲突。
A. 报表系统
B. 文件系统
C. 网管系统
D. 告警系统
[判断题]一个Oracle Server包含一个Oracle Instance和一个Oracle Database。
