Oracle认证 - 自考题库

出自:Oracle认证

You work as a database administrator for Supportcenter.cn. Your database is opened inNOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this？（）
A:Execute the ALTER DATABASE ARCHIVELOG statement
B:Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C:Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D:Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）
A: Creating the control file for the duplicate database
B: Restoring the target data files to the duplicate database
C: Performing complete recovery using all available backups
D: Generating a new， unique DBID for the duplicate database
E: Copying the online redo log files from the target database to the duplicate database

Click the Exhibit button. Which three code fragments, added individually at line 29, produce the output 100?（）

A:n = 100;
B:i.setX( 100 );
C:o.getY().setX( 100 );
D:i = new Inner(); i.setX( 100 );
E:o.setY( i ); i = new Inner(); i.setX( 100 );
F:i = new Inner(); i.setX( 100 ); o.setY( i );

Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correcte？（）
A:This clause is not valid for a temporary or undotablespace.
B:If thetablespaceis in the NOLOGGING mode， no operation on thetablespacewill generate redo.
C:Thetablespacewill be IntheNOLOGGING mode by default， if not specified while creating atablespace.
D:Thetablespace-level logging attribute can be overridden by logging specification at the table， index， materialized view， materialized view log， and partition levels.

Which statement is true about the Manageability Monitor （MMON） background process（）
A:It transfers statistics from memory to disk at regular intervals.
B:It coordinates the rebalance activity for disk groups when ASM is used.
C:It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
D:It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

Which of the following roles must be granted to a user to perform a full database import？（）
A:CONNECT
B:IMP_FULL_DATABASE
C:FULL_EXPORT_PRIVS
D:RESOURCE
E:FULL_IMPORT_PRIVS

You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
A:The Oracle kernel will be placed in this location.
B:The Oracle software will be placed in this location.
C:The server parameter file （SPFILE） will be placed in this location.
D:The database files will be placed in this location， if not specified explicitly.
E:The location will be considered for the base of Oracle Managed Files （OMF）.
F:The location will be considered for the base of Optimal Flexible Architecture （OFA）.

在用OMS/OEM建立数据库时，什么情况下使用“数据仓库”类型，什么情况使用“事务处理”类型？

You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new organization. How would you accomplish the task？（）
A: by using the STATUS command of the Listener control utility
B: by using the STATUS L1 command of the Listener control utility
C: by using the SHOW RULES command of the Listener control utility
D: by using the SET PASSWORD command of the Listener control utility
E: by searching for the PASSWORD_LISTENER entry in the listener.ora file

You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands： STARTUP MOUNT； BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2； Which components are included in the backup？（）
A:Only the data files.
B:Only the data files and the online logs.
C:The data files， control files， and the online logs.
D:The data files and control files， but not the online logs.

You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL> startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（）
A: Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
B: Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
C: Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
D: Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
E: Issue the restore spfile from autobackup command from the RMAN prompt.

数据库服务器通过（）接收一个来自于客户应用程序的一个初始化连接，它是一个位于Oracle网络基础层顶层的一个应用程序。
A:Oracle Net
B:监听器
C:Oracle企业管理器
D:Oracle数据库管理器

In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？（）
A: The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B: The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C: The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D: If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.
E: Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)
A:Database must be running in archivelog mode.
B:Automatic undo management must be enabled.
C:Undo retention guarantee must be enabled.
D:The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?（）

A:It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.
B:It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.
C:It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.
D:It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500MB of data transfer for queries, but not for data manipulation language (DML) operations.

You creating a report that will run in both character mode and bitmapped environments. You include some printer codes in your report. What will happen when you run the report in bitmapped mode? （）
A:The report will not execute.
B:The report will only accept destination type of previewer or printer.
C:Printer codes will be ignored.
D:Only the printer codes that apply will be processes.

Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）
A:user-managed backups.
B:partial database backups.
C:consistent database backups.
D:inconsistent database backups.

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL>@utlu111i.sql Which statement about the execution of this script is true？（）
A: It must be executed from the Oracle Database 11g environment.
B: It must be executed only after the SYSAUX tablespace has been created.
C: It must be executed from the environment of the database that is being upgraded.
D: It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E: It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

You have created a resource plan， PROD_DB_PLAN， that uses the RATIO policy. The following consumer groups and their respective plan directives have been assigned to this resource plan： Consumer group HIGH_CG with CPU_P1 as 10. Consumer group MEDIUM_CG with CPU_P1 as 5. Consumer group LOW_CG with CPU_P1 as 2. Consumer group OTHER_GROUPS with CPU_P1 as 1. Which statement is correct in this scenario？（）
A: The CPU allocation would be equal between the HIGH_CG and MEDIUM_CG consumer groups if there are no sessions existing for the LOW_CG and OTHER_GROUPS consumer groups.
B: The members of the HIGH_CG consumer group would get 10% of the CPU.
C: The plan PROD_DB_PLAN can have subplans.
D: The CPU allocation for the consumer groups would be based on the ratio defined for the CPU_P1.

Examine the data in the EMPLOYEES and EMP_HIST tables:

The EMP_HIST table is updated at the end of every year. The employee ID, name, job ID, and salary of each existing employee are modified with the latest data. New employee details are added to the table. Which statement accomplishes this task?（）
A:

Given:

What is the result?（）
A:The code runs with no output.
B:An exception is thrown at runtime.
C:Compilation fails because of an error in line 20.
D:Compilation fails because of an error in line 21.
E:Compilation fails because of an error in line 23.
F:Compilation fails because of an error in line 25.

You need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）
A:set SQL_TRACE=True
B:set UNDO_RETENTION=14400
C:set FAST_START_MTTR_TARGET=240
D:set LOG_CHECKPOINT_INTERVAL=240
E:set DB_FLASHBACK_RETENTION_TARGET=14400
F:set the RETENTION GUARANTEE clause for the undo tablespace

What effect should the loss of an index tablespace have on an Oracle instance that is running？（）
A: instance hangs
B: instance gets aborted
C: instance continues running
D: instance gets restarted automatically

You work as a database administrator for Certkiller .com. According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
A:The backup is similar to image copy.
B:The backup contains all used data blocks.
C:The backup contains only unused data blocks.
D:The backup contains all data blocks changed since the last incremental level 1 backup.

Given：

Which code， inserted at line 15， creates an instance of the Point class defined in Line？（）
A:Point p = new Point（）；
B:Line.Point p = new Line.Point（）；
C:The Point class cannot be instatiated at line 15.
D:Line l = new Line（）； l.Point p = new l.Point（）；

Which four statements are true？（）
A:Has-a relationships should never be encapsulated.
B:Has-a relationships should be implemented using inheritance.
C:Has-a relationships can be implemented using instance variables.
D:Is-a relationships can be implemented using the extends keyword.
E:Is-a relationships can be implemented using the implements keyword.
F:An array or a collection can be used to implement a one-to-many has-a relationship.

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)
A:An entry is created in the alert log file and the database instance continues to function normally
B:The log switch hangs occur for transactions until free space is available in the flash recovery area
C:The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
D:The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Given：

What is the result？（）
A:2 -1
B:2 -4
C:2 -5
D:3 -1
E:3 -4

Which scenario describes an appropriate use for opening a form in a new session?（）
A:The data entered into the called form is logically independent of the data entered in the calling form.
B:The called form requires different privileges than the calling form.
C:The called form must execute as a different user than the calling form.
D:The calling form must be able to query data in the called form before it is saved.

使用（）命令，可以把查询结果保存到一个文件中，或者把查询结果发送到打印机。
A:help
B:desc
C:prompt
D:spool

首页 <上一页 46 47 48 49 50 下一页> 尾页