Free Oracle 1z1-062 Exam Dumps Questions & Answers

You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases both have their instances running.
Which two statements are true? (Choose two.)

• A.All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
• B.The crsctl start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
• C.All database listeners running from the database home are automatically added to the Oracle Restart configuration.
• D.Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.
• E.The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.

Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

• A.SQL Tuning Advisor
• B.Automatic Database Diagnostic Monitor (ADDM)
• C.SQL Access Advisor
• D.Automatic Workload Repository (AWR) report
• E.SQL Performance Analyzer

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

• A.shutting down the database instance that is being upgraded
• B.copying the listener.ora file to the new ORACLE_HOME
• C.executing the catctl.pl script to run the upgrade processes in parallel
• D.running the Pre-Upgrade Information Tool

You want to load data from a large file into your database without causing an overhead on the SGA.
Which tool would you use.

• A.SQL*Loader with a direct data path
• B.external table
• C.Enterprise Manager Database Express
• D.SQL*Loader with a conventional data path
• E.Oracle data Pump

Which three statements are true about checkpointing? (Choose three.)

• A.It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.
• B.It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
• C.Frequent thread checkpoints can degrade database performance.
• D.It ensures that all dirty buffers are written to data files during consistent shutdown.
• E.It reduces the time required for recovery in case of an instance failure.