ITPub博客

531.When starting up your ASM instance, you receive the following error:ASM实例启动时，您会收到以下错误：SQL> startup pfile=?/dbs/init+ASM.oraASM instance started+Total System Global Area 104611840 bytesFixed Size 1298220 bytesVariable Size 78147796 bytesASM Cache 25165824 bytesORA-15032: no...

105.Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overh...

60.For which two situations would you use functionality provided by the Resource Manager? (Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to...

563.How many individual archive-log destination directories are supported by Oracle Database11g?A. 7B. 1C. 10D. 11E. 21Answer: COracle 11g支持多少个归档日志目标？应该是31个，10g是支持10个。SQL> select * from v$version;BANNER----------------------------------------------------------...

208.You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level? (Choose two.)A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RE...

496.Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance e...

235.The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration.You executed the following command to startup the Automatic Storage Management (ASM) instance.SQL> STARTUP;Which two activities are performed during a successful start up operation? (Choose two.)A. Th...

665.Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)A. The ADR base keeps all diagnostic information in binary formatB. SQL*Plus provides the ADRI script, which can be used to work with ADRC. The ADR can be used for problem diagnosis only when the datab...

650.Which three tasks can be performed using a duplicate database? (Choose three.)A. Testing the backup and recovery proceduresB. Testing the upgrade of an Oracle database to a new releaseC. Testing the effect of an application changes on database performanceD. Continuously updating archive log ...

644.View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM).Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?A. Because the FRA disk ...

617.A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2'FAILGROUP controller2 DISK '/devices/diskb1', '/device...

99.View the Exhibit and examine the steps that you executed to create a database resource plan.Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?Exhibit:A. The pending area is auto...

675.Which two client requests are captured during database replay Capture? (Choose two)A. Flashback queriesB. Shared server requestsC. Login and logoff activities of sessionsD. Direct path load of data from external files by using utilities such as SQL *loaderE. Data definition language (DDL) a...

666.You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the tab...

212.Note the following parameters settings in your database:SGA_MAX_SIZE = 1024MSGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issued the following command to increase the value of DB_8K_CACHE_SIZE:SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;What would happen?A. It will fail be...

205.You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.Which statement about the result is true?A. The database instance starts, and Oracle sets the default value of SG...

156.What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes increasesC. The number of DBWR_TO_SLAVES increasesD. The rebalancing operation in an ASM instance completes more quickly, but can result in hig...

128.You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To ...

663.Which options would you consider while configuring a flash recovery area (fast recovery area in 11gRelease 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)A. Setting the FAST_START_MTTR_TARGET to set the mean time to recoverB. Setting the RECOVERY_PA...

602.On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.Which option must you use to check whether a flashback operation can recover the database to the specified time?A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC...