Online Access Free 1Z0-048 Practice Test

Which CREATE SEQUENCE option is the most scalable?

• A.NOCACHE NOORDER
• B.CACHE NOORDER
• C.CACHE ORDER
• D.NOCACHE ORDER

You are running a two-instance database with six redo log groups defined and decide to add a third thread to support a third database instance on the third node of the cluster. Which three commands would you issue to achieve this using command line administration? (Choose three.)

• A.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;
• B.ALTER DATABASE ENABLE THREAD 3;
• C.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;
• D.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
• E.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
• F.ALTER SYSTEM ENABLE THREAD 3;

Your company has certain standard practices for technology and you are configuring ASM disk groups for your four-node RAC cluster. The company guidelines suggest that there is one disk group for the flash recovery area that is shared by all databases and a separate disk group for the database area of all databases. Which three exceptions exist that may require you to create additional disk groups? (Choose three.)

• A.There are partitioned tables where the older partitions are in read-only tablespaces and seldom accessed, but the more recent partitions are frequently accessed.
• B.Some database instances are shut down every night while others are always running.
• C.There are large nonpartitioned tables accessed frequently using indexes.
• D.The disk farm has different disk models with different characteristics and ages.
• E.Applications using the databases have different Service-Level Agreements for response time and throughput.
• F.The retention policy for backups are different for different databases.
• G.Some databases operate in ARCHIVELOGMODE and others in NOARCHIVELOGMODE.

You have a four-node cluster with instances RDBD1, RDBD2, RDBD3, and RDBD4. While evaluating statspack reports, you find nq: TX- index contention on page one under the category op 5 Timed Events.
Further study finds an unusually high number of c buffer busy waits in the Wait Events section.
Checking the Instance Activity Stats section, you see an unusually high value for eaf Node Splits.
Using v$segment_statistics, you identify that the top segment with c buffer busy waits is the index products_pk, which obtains the primary key from a sequence. You wish to present alternative solutions to the team to help reduce contention.
Which three actions would you recommend to reduce the overheads? (Choose three.)

• A.Re-create the table using a natural key instead of a surrogate key.
• B.Increase the sequence cache size if retaining the sequence.
• C.Re-create the index as a global hash partitioned index.
• D.Set _lm_msg_batch_size to a higher value.
• E.Set fast_start_mttr_target to a higher value.
• F.Encourage shorter transactions.

You are implementing a three-node RAC setup in your company. You have already performed these tasks:
1) Hardware and OS configuration 2) Cluster file system installation 3) Clusterware installation You executed the following command in one of the nodes: cluvfy stage -pre dbinst -n all
What is the reason for executing this command?

• A.to check if the ORACLEJHOME environmental variable is set to a correct value or not before the database installation
• B.to check whether the dbinst directory is available on all the nodes
• C.to check for node connectivity and Clusterware integrity
• D.to check for the existence of Oracle database software installation files in the /stage directory on all the nodes