1z1-034 무료 덤프문제 온라인 액세스

Which data dictionary view would you query to find the name of the default permanent tablespace of the database?

• A.DBA_TABLESPACE_GROUPS
• B.DBA_TABLESPACES
• C.DATABASE_PROPERTIES
• D.DBA_STORED_SETTINGS
• E.DBA_DIRECTORIES
• F.DICTIONARY

Examine the parameter settings in your database.

Which statement is correct about the database?

• A.Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
• B.The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET andSGA_TARGET are set.
• C.The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set.
• D.Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

Which three tasks can be performed using a duplicate database? (Choose three.)

• A.Testing the effect of an application changes on database performance
• B.Testing the backup and recovery procedures
• C.Continuously updating archive log files from the target database to support failover
• D.Testing the upgrade of an Oracle database to a new release

You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;
SQL> EXECUTE DBMS_STATS. SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false');
SQL> EXECUTE DBMS_STATS. GATHER_TABLE_STATS ('SH' , 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

• A.The statistics are treated as the current statistics by the optimizer for all sessions.
• B.The statistics are treated as the current statistics by the optimizer for the current sessions only.
• C.The statistics are stored in the pending statistics table in the data dictionary.
• D.The statistics are temporary and used by the optimizer for all sessions until this session terminates.

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

• A.The number of DBWR_TO_SLAVES increases
• B.The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/Ooverhead
• C.The number of DBWR processes increases
• D.The number of ASMB processes increases