问题:Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?()A、The size of the shared pool is too small.B、Cursors are not being shared.C、A large number COMMITS are being performed.D、There are frequent logons and logoffs.E、The buffers are being read into the buffer cache, but some other session is changing the buffers.
查看答案
问题: 对于以下SQL语句说法正确的是() SELECT ename FROM emp WHERE sal IN (SELECT MAX(sal) FROM emp GROUP BY deptno);A、这个语句是符合语法的B、这个语句是不能执行的,因为缺少HAVING子句C、这个语句是不能执行的,因为分组的条件列不在SELECT列表中D、这个语句是不能执行的,因为GROUP BY子句应该在主查询中,而不是在子查询中E、在主查询的WHERE条件中,不应该用IN,而应该用等号
问题:Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do?()A、 Disable SQL tracing for the APPS tablespace.B、 Disable logging attributes for the APPS tablespace.C、 Modify the tablespace to be a dictionary-managed tablespace.D、 Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.E、 Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.
问题:Which two tasks can you perform using only the TO_CHAR function? ()A、convert 10 to 'TEN'B、convert '10' to 10C、convert 10 to '10'D、convert 'TEN' to 10E、convert a date to a character expressionF、convert a character expression to a date
问题: In your production database, you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager?()A、CPU usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed
问题:Which two statements regarding a SQL profile are true?()A、 It is built by Automatic Tuning Optimizer.B、 It cannot be stored persistently in the data dictionary.C、 It can be used by the query optimizer automatically.D、 It can be created manually by using the CREATE PROFILE command.
问题:In your test database, you find that a user’s session is executing a lot of SQL statements, resulting in the generation of a large number of trace files. While investigating the reason, you find that SQL trace has been enabled at the instance level. You want to disable SQL trace, remotely, only for that user session to reduce the volume of trace data being generated.How do you achieve this objective?()A、 by setting the SQL_TRACE parameter to FALSE in the parameter fileB、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionC、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionD、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
问题: You issue the following command on the RMAN prompt. REPORT NEED BACKUP DAYS 5; Which statement is true about executing this command?()A、It will display a list of files that need incremental backupB、It will display a list of files that need backup after five daysC、It will display a list of files that were backed up in the last five daysD、It will display a list of files that have not been backed up in the last five daysE、It will apply the current retention policy to determine the files that need to be backed up
问题:You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?()A、Configure Java Pool to cache the java objects.B、Configure Streams Pool to enable parallel processing.C、Increase Shared Pool size to cache more PL/SQL objects.D、Increase Database Buffer Cache size to increase cache hits.E、Configure Large Pool to be used by RMAN and shared server.F、Increase the total System Global Area (SGA) size to increase memory hits.
问题: Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?() a. restore controlfile b. restore database c. restore spfile d. recover database e. alter database open f. alter database open resetlogsA、 b, a, c, d, eB、 a, c, b, d, fC、 c, a, b, d, eD、 c, a, b, d, fE、 e, a, b, d, c
问题:What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause?()A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. D、Global indexes remain intact and available for use by data manipulation language (DML) statements even for sessions that have not enabled the skipping of unusable indexes.
问题:Which component does the SQL Tuning Advisor NOT analyze for the SQL statements?() A、ADDMB、AWRC、Cursor CacheD、SQL Tuning SetsE、Flash Recovery Area
问题:You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting?() A、 The database will not start.B、 The database will start but will not retain the undo data in the undo segment.C、 The database will start, and the undo segment will contain the undo data for at least one hour.D、 The database will start, and the undo segment will retain the undo data for at least 15 minutes.
问题:当ORACLE9.2数据库服务器安装后,将自动创建两个具有超级权限的用户,并且要求设定这两个用户的口令,这两个用户是()A、SYSTEM和MANAGERB、SYS和SYSTEMC、SYS和SYSMAND、ROOT和SUPERMANE、SCOTT和TIGER
问题:Which statement about using RMAN stored scripts is true?()A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
问题: You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()A、LOG_ARCHIVE_DEST was not set in the parameter file.B、LOG_ARCHIVE_START was not set in the parameter file.C、alter database archivelog; was not executed in MOUNT mode.D、LOG_ARCHIVE_MAX processes were not set in the parameter file.
问题:View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities:SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0;What do you infer from this()A、The database instance is running with manual PGA management.B、The database instance is running with manual shared memory management.C、The database instance has the MEMORY_TARGET value set to a nonzero value.D、All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel queryoperations have been performed
问题:Which two statements are true about encrypting RMAN backup?() (Choose two.)A、The transparent encryption of backups uses the encryption walletB、The database uses the same encryption key for every encrypted backupC、The password encryption of backups only uses the password while creating and restoring backupD、If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.
问题: Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? ()A、INSERT INTO employees VALUES ( NULL, 'John', 'Smith');B、INSERT INTO employees( first_name, last_name) VALUES( 'John', 'Smith');C、INSERT INTO employees VALUES ( '1000', 'John', NULL);D、INSERT INTO employees (first_name, last_name, employee_id) VALUES ( 1000, 'John', 'Smith');E、INSERT INTO employees (employee_id) VALUES (1000);F、INSERT INTO employees (employee_id, first_name, last_name) VALUES ( 1000, 'John', ' ');
问题: You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?()A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.