Oracle认证 - 自考题库

出自:Oracle认证

You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）
A:Disable automatic checkpoint tuning.
B:Check the size of the redo log file size and increase the size if it is small.
C:Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D:Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）
A: Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
B: Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
C: Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
D: Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.

Given：

What is the result？（）
A:r， t， t，
B:r， e， o，
C:Compilation fails.
D:An exception is thrown at runtime.

You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export file expdat.dmp. Which import statement is correct？（）
A:imp hr/hr TABLES=（ts_employees） rows=y
B:imp system/manager FROMUSER=hr file=expdat.dmp
C:imp hr/hr TRANSPORT_TABLESPACE=y file=expdat.dmp
D:imp system/manager TRANSPORT_TABLESPACE=y TABLESPACE=ts_employees

You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level？（）
A: issuing the ALTER SYSTEM ENABLE RESUMABLE；statement
B: issuing the ALTER SESSION ENABLE RESUMABLE；statement
C: modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D: issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=；statement

What is true about sequences?（）
A:The start value of the sequence is always 1.
B:A sequence always increments by 1.
C:The minimum value of an ascending sequence defaults to 1.
D:The maximum value of descending sequence defaults to 1.

You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）
A: INSTANCE_TYPE
B: DB_UNIQUE_NAME
C: ASM_DISKSTRING
D: ASM_POWER_LIMIT

对于Oracle的服务，描述正确的是（）。
A:OracleOraDb11g_homeTNSListener服务：Oracle服务器的监听程序
B:OracleDBConsoleSID://Oracle的核心服务，要启动Oracle实例，必须启动该服务
C:OracleJobSchedulerSID://任务调度服务，负责对用户创建的作业按预先设置的时间周期性地进行调度执行，从而实现Oracle服务器的自动管理功能
D:OracleServiceSID://负责在Windows平台下启动Oracle企业管理器。Oracle 11g企业管理器是一个功能完善的Oracle数据库管理工具，可以管理本地数据库环境和网格环境

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）
A:Set MEMORY_TARGET to zero
B:Set the STATISTICS_LEVEL parameter to BASIC
C:Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D:Set the PGA_AGGREGATE_TARGET parameter to nonzero value

ABC Company has approximately 150’000 products in their catalog and wants to put these within a Coherence cache to improve performance and access times of their existing JEE application without too much change to existing code. There are a number of servlets that get the same product information multiple times within a page. There are also a number of server-based processes that run at regular intervals and also request product information many times. Products have small changes which need to be updated during the day. What would be the most appropriate caching scheme to use ？（）
A: Near Cache
B: Distributed Cache
C: Local Cache
D: Replicated Cache

During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation？（）
A: The installation terminates with an error.
B: The installation proceeds with the default value without warnings and errors.
C: The installation proceeds with the default value but it would not be an OFA-compliant database.
D: The installation proceeds with the default value but a message would be generated in the alert log file.

You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）
A:MERGE
B:INSERT
C:UPDATE
D:ADD
E:ENTER
F:You cannot enter the phone numbers for the existing employee records.

Which of the following Scheduler elements encourage object reuse?（）
A:Schedule objects
B:Program arguments
C:Job classes
D:Job arguments
E:All of the above

Which two statements are true regarding a PL/SQL package body？（）
A:It cannot be created without a package specification.
B:It cannot invoke subprograms defined in other packages.
C:It can contain only the subprograms defined in the package specification.
D:It can be changed and recompiled without making the package specification invalid.

What are the prerequisites for enabling Flashback Database？（）
A: The database must be started in the MOUNT EXCLUSIVE state.
B: The database must have multiplexed control files.
C: The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）.
D: The database must be in ARCHIVELOG mode.
E: The database must be in the NOMOUNT state.
F: The database must be opened in RESTRICTED mode.

Which three statements are true regarding the data types in Oracle Database 10g/11g?（）
A:Only one LONG column can be used per table
B:A TIMESTAMP data type column stores only time values with fractional seconds
C:The BLOB data type column is used to store binary data in an operating system file
D:The minimum column width that can be specified for a VARCHAR2 data type column is one
E:The value for a CHAR data type column is blank-padded to the maximum defined column width

In the Oracle9i Data Guard architecture， what is the purpose of the Log Transport Services？（）

A:A
B:B
C:C
D:D

Which command do you use to generate a report of database incarnations？（）
A: list incarnation of database
B: report incarnation of database
C: list database incarnation
D: database incarnation list
E: report database incarnation

The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit. Which two statements about the results of the query shown in the Exhibit are correct? （）(Choose two.)

A:The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
B:The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
C:The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
D:The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command： RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS； After configuring the recovery window， you performed the database backup as follows：（）
A: Backup RB1 at log sequence number 12871 on 5th Jan
B: Backup RB2 at log sequence number 15622 on 12th Jan
C: Backup RB3 at log sequence 16721 on 15th Jan
D: On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.

In which cases is reference partitioning effective in enhancing performance?（）
A:It is effective only in partition pruning.
B:It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C:It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D:It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

You want to enable automatic PGA memory management in your database. Which setting is required toachieve this?（）
A:Set MEMORY_TARGET to zero
B:Set the STATISTICS_LEVEL parameter to BASIC
C:Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D:Set the PGA_AGGREGATE_TARGET parameter to nonzero value

Given classes defined in two different files：

What is required at line 5 in class SomeApp to use the process method of BitUtils？（）
A:process（bytes）；
B:BitUtils.process（bytes）；
C:app.BitUtils.process（bytes）；
D:util.BitUtils.process（bytes）；
E:import util.BitUtils.*； process（bytes）；
F:SomeApp cannot use the process method in BitUtils.

Given：

What is the result？（）
A:harrier
B:shepherd
C:retriever
D:Compilation fails.
E:retriever harrier

The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan？（）
A:ALTER TABLE employees monitor index employee_idx_fk;
B:ALTER INDEX employee_idx_fk monitoring on;
C:ALTER TABLE employees monitor all indexes;
D:ALTER INDEX employee_idx_fk monitoring usage;

假设在数据库中已经创建了某个用户test，需要将其口令修改为oracle，可以使用如下（）语句。
A:ALTER USER test IDENTIFIED BY oracle
B:ALTER USER test PASSWORD oracle
C:CREATE USER test IDENTIFIED BY oracle
D:UPDATE USER test IDENTIFIED BY oracle

当在SQL*Plus中需要以DBA连接到Oracle数据库，可以使用如下（）方式。
A:CONNECT SYS/password SYSDBA
B:CONNECT SYS/password AS SYSDBA
C:CONNECT AS SYSDBA SYS/password
D:CONNECT DBA SYS/password

Which of the following is a benefit of ASM fast disk resync？（）
A: Failed disks are taken offline immediately but are not dropped.
B: Disk data is never lost.
C: By default， the failed disk is not dropped from the disk group ever， protecting you from loss of that disk.
D: The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
E: Hot spare disks are automatically configured and added to the disk group.

What is the architectural benefit of keeping WebLogic Server transaction log in the database?（）
A:Oracle does not allow replicating files between data centers, so keeping transaction log in database allows for replication.
B:Many transactions in WebLogic are database centric, so keeping log in database makes Two Phase Commit protocol possible.
C:It obviates the need to keep in sync two replication technologies (file and database) between data centers. The single replication technology is used for frequently changing data.
D:Transaction log in a file system is extremely slow so it cannot be efficiently replicated.

首页 <上一页 146 147 148 149 150 下一页> 尾页