题库网

题目列表

[单选题] An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command： SQL>CREATE INDEX ord_custname_ix ON orders（custname）； The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test. Which is the most efficient method of performing this task？（）

[单选题] 当需要查询当前活动进程的信息时，可以使用（）视图。

[单选题] 限制从EMP表中只选出前5条记录的查语句为（）。

[多选题] Which of the following cannot be used as input to the SQL Tuning Advisor？（）

[单选题] 当在WINDOWS平台上安装并运行ORACLE9i服务器后，可通过WINDOWS服务窗口来查看其服务情况，以下哪一个是数据库服务项（假定服务器的SID为ORA92）（）

[单选题] 在Oracle中，当FETCH语句从游标获得数据时，下面叙述正确的是（）。

[单选题] 在SQL*PLUS环境中，若想通过执行PL/SQL代码来显示指定的字符串，以下哪个方法可行（）

[多选题] 以下（）是Oracle相关的系统服务，在Windows操作系统中，可以使用控制面板的服务工具进行管理。

[单选题] A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）

[多选题] What components are present in an ASM instance？（）

Copyright © 2021 题库网浙ICP备2024091676号