Oracle认证 - 自考题库

出自:Oracle认证

Evaluate the following block of code： BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL （ acl => ’mycompany-com-permissions.xml’， principal => ’ACCT_MGR’， is_grant => TRUE， privilege => ’connect’）； DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL （ acl => ’mycompany-com-permissions.xml’， host => ’*.mycompany.com’）； END； What is the outcome of the above code？（）
A: It produces an error because a fully qualified host name needs to be specified.
B: It produces an error because the range of ports associated with the hosts has not been specified.
C: It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D: It creates an access control list （ACL） with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.

Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10：00 P.M. and 10：30 P.M. The next day， you decide to flash back the database. Before you flash back the database， you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table？（）
A: V$DATABASE
B: V$UNDOSTAT
C: V$FLASHBACK_DATABASE_LOG
D: V$FLASHBACK_DATABASE_STAT

A database exists as a read-intensive server that is operating with query_cachek_type =DEMAND. The database is refreshed periodically, but the resultset size of the queries does not fluctuate. Note the following details about this environment: A web application uses a limited set of queries. The Query Cache hit rate is high. All resultsets fit into the Query Cache. All queries are configured to use the Query Cache successfully. The response times for queries have recently started to increase. The cause for this has correctly been identified as the increase in the number of concurrent users accessing the web service. Based solely on the information provided, what is the most likely cause for this slowdown at the database level?（）
A:The Query Cache is pruning queries due to an increased number of requests
B:Query_cache_min_res_unit has been exceeded, leading to an increased performance overhead due to additional memory block lookups
C:Mutex contention on the Query Cache is forcing the queries to take longer due to its singlethreaded nature
D:The average resultset of a query is increasing due to an increase in the number of users requiring SQL statement execution

Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future. What action would you take to achieve this task（）
A:Insert finding directives for ADDM tasks in the future.
B:Create a baseline on a pair of snapshots spanning the peak-load period.
C:Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
D:Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.

In which situation will you run the script containing the following statement？（） CREATE CONTROLFILE REUSE DATABASE SALES NORESETLOGS ARCHIVELOG MAXLOGFILES 20 MAXLOGMEMBERS 3 MAXDATAFILES 30 MAXINSTANCES 10 MAXLOGHISTORY 1200 LOGFILE GROUP 1 （ ’/disk1/prod/orders/db/log1a.dbf’， ’/disk2/prod/orders/db/log1b.dbf’ ）SIZE 100K GROUP 2 （ ’/disk1/prod/orders/db/log2a.dbf’， ’/disk2/prod/orders/db/log2b.dbf’ ） SIZE 100K， DATAFILE ’/disk1/prod/orders/db/database1.dbf’， ’/disk2/prod/orders/db/file1.dbf ’；
A: when all the control files are missing and only a binary backup of the current control file exists
B: when a multiplexed copy of the current control file is missing
C: when all the control files are missing and only an ASCII representation of the binary control file exists
D: when the SPFILE is missing

You are using Recovery Manager （RMAN） for backup and recovery operations. Your backup and recovery policy is such that you are performing full database backup every Tuesday and Friday. You configure RMAN using the following command： RMAN>CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 4 DAYS； All backup and archived redo logs generated during the current week are as follows：

Which of the following files will be listed when issuing the REPORT OBSOLETE command on Sunday？（）
A: the archived redo log with the log sequence 520
B: the backup files from the full database backup performed on Tuesday
C: the archived redo log with the log sequence 520 and the backup files from the full database backup performed on Tuesday
D: archived redo logs with the log sequences 520， 521， 522 and the backup files from the full database backup performed on Tuesday

In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）
A:using only the RMAN SWITCH command to set the new location for the data file
B:placing the database in the MOUNT state for the restore and recovery operations.
C:using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
D:configuring two channels: one for the restore operation and the other for the recovery operation

在创建表时，选择“方案”的作用是什么？

Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?（）
A:The incident metadata is purged when the problem is resolved and the DBA closes the SR
B:The incident files and dumps are not retained in the ADR for the manually created incidents
C:The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SR
D:The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month

命令sqlplus/nolog的作用是（）
A:仅创建一个ORACLE实例，但并不打开数据库.
B:仅创建一个ORACLE实例，但并不登录数据库.
C:启动sqlplus，但并不登录数据库
D:以nolog用户身份启动sqlplus
E:以上所述都不正确

Identify three features of shared entities.（） (Choose three.)
A:enable one-time definition of objects
B:are referenced by several Oracle Application modules
C:are defined in each Oracle Application module separately
D:are owned by a single Oracle Application module for table purposes only
E:are owned by a single Oracle Application module to designate the primary user or decision maker

Given:

What is the result?（）
A:1
B:2
C:12
D:Compilation fails.
E:No output is produced.
F:An exception is thrown at runtime.

Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?（）
A:Database operations will be monitored only when they consume a significant amount of resource.
B:Database operations for all sessions will be monitored.
C:Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.
D:Only DML and DDL statements will be monitored for the session.
E:All subsequent statements in the session will be treated as one database operation and will be monitored.

Which statement is true about Oracle Net Listener?（）
A:It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
B:A single listener can service only one database instance and multiple remote client connections.
C:Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
D:The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

Exhibit： View the Exhibit and examine the characteristic of the USERS tablespace. You observe that a large volume of inserts and deletes are happening on the TRANS table in the USERS tablespace and you suspect that the TRANS table is fragmented. Which advisory component would you refer to， in order to find information about table fragmentation？（）

A: Memory Advisor
B: Segment Advisor
C: SLQ Tuning Advisor
D: SLQ Access Advisor
E: Automatic Database Diagnostic Monitor （ADDM）

On your Oracle Database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）
A:Only the ORD_CUSTOMER_IX1 index created.
B:Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
C:Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
D:The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
E:Both the indexes are created and used by the optimizer for queries on the ORDERS table.
F:Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Which command creates an image copy？（）
A: backup as copy
B: backup copy
C: copy as backup
D: copy back

Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?（）
A:PLSQL_BLOCK
B:JAVA_STORED_PROCEDURE
C:STORED_PROCEDURE
D:EXECUTABLE
E:None of the above are invalid settings.

当SELECT INTO语句没有返回行时，会触发的异常是（）。
A:TOO_MANY_ROWS
B:VALUE_ERROR
C:NO_DATA_FOUND
D:不会触发任何异常

列上创组合索引（也称为（））是在表的多个建的索引。
A:压缩索引
B:连接索引
C:一致索引
D:位图索引

You are configuring for Oracle Shared Server. Which service is required？（）
A:Oracle Net Service
B:Oracle HTTP Service
C:Oracle Paging Service
D:Internet Directory Service

Which of the following datatypes store time-zone information in the database？（）
A: TIMESTAMP
B: DATE
C: TIMESTAMP WITH TIME ZONE
D: TIMESTAMP WITH LOCAL TIME ZONE
E: DATETIME

CREATE，DROP，ALTER等命令属于下列哪类命令（）
A:DCL
B:DDL
C:DML
D:DQL
E:以上所述都不正确

ABC Corp. has configured 11i Oracle Applications for the English language. It is now planningto commence operations in France and so wants the same instance to be available in French aswell. It can accomplish this task by using （）.
A:Oracle Configurator
B:Oracle General Ledger
C:Application Object Library
D:Oracle Human Resources

Which two statements are true about the hashCode method？（）
A:The hashCode method for a given class can be used to test for object equality and object inequality for that class.
B:The hashCode method is used by the java.util.SortedSet collection class to order the elements within that set.
C:The hashCode method for a given class can be used to test for object inequality， but NOT objecte quality， for that class.
D:The only important characteristic of the values returned by a hashCode method is that the distribution of values must follow a Gaussian distribution.
E:The hashCode method is used by the java.util.HashSet collection class to group the elements within that set into hash buckets for swift retrieval.

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS; Under which conditions would this command execute successfully？（）
A:The database is in NOMOUNT state.
B:The database is in ARCHIVELOG mode and the tablespace is online.
C:The database is in ARCHIVELOG mode and the tablespace is offline.
D:The database is in NOARCHIVELOG mode and the tablespace is online.
E:The database is in NOARCHIVELOG mode and the tablespace is offline.

Which three statements are true about adaptive SQL plan management?（）
A:It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
B:The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
C:It adds new, bettor plans automatically as fixed plans to the baseline.
D:The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
E:The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Which of the following is not a valid calendaring syntax element？（）
A: FREQ
B: BYHOUR
C: RUNDATE
D: INTERVAL
E: BYMINUTE

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）
A:point-in-time recovery
B:execute the ROLLBACK command with transaction number
C:flashback the database to before the transaction was committed
D:determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?（）
A:ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
B:ALTER DISKGROUP dg1 UNDROP;
C:ALTER DISKGROUP dg1 UNDROP DISKS;
D:You cannot cancel the pending disk drops.

首页 <上一页 117 118 119 120 121 下一页> 尾页