We provide real 1Z0-055 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-055 Exam quickly & easily. The 1Z0-055 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-055 dumps pdf and vce product and material, you can easily pass the 1Z0-055 exam.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-055 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q61. You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)
A. The source database backup must be copied over the net for test database.
B. The source database must be run in ARCHIVELOG mode if the database is open.
C. The source database must be shut down cleanly if the database is in mounted state.
D. A net service name should be set up and a listener configured with the target as well as the source database.
Q62. Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
A. The plans can be manually loaded to the SQL plan baseline.
B. The plans in the SQL plan baseline are verified and accepted plans.
C. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D. The plan baselines are stored temporarily in the memory as long as the database instance is running.
E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
Q63. Evaluate the following function code:
CREATE FUNCTION get_dept_avg(dept_id NUMBER)
RESULT_CACHE RELIES_ON (EMPLOYEES)
SELECT AVG(SALARY)INTO avgsal
WHERE DEPARTMENT_ID = dept_id;
Which statement is true regarding the above function?
A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.
C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
Q64. What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
A. It can recommend partitioning only on tables that have at least 10,000 rows.
B. It cannot generate recommendations that support multiple workload queries.
C. It can recommend only B-tree indexes and not bitmap or function-based indexes.
D. It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
Q65. You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :
SQL> shutdown immediate;
What is the result of executing this command?
A. The ASM instance is shut down, but the other instances are still running.
B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
Q66. During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?
A. The installation terminates with an error.
B. The installation proceeds with the default value without warnings and errors.
C. The installation proceeds with the default value but it would not be an OFA-compliant database.
D. The installation proceeds with the default value but a message would be generated in the alert log file.
Q67. Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)
A. It can be used to back up all data on ASM disks.
B. It can be used to re-create the ASM disk group with its attributes.
C. It can be used to recover the damaged ASM disk group along with the data.
D. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
Q68. You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
A. ASM compatibility controls which features for the ASM will be enabled.
B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
D. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
Q69. Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)
A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots
Q70. View the Exhibit to examine the parameters set for your database instance.
You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:
SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, -
Which statement describes the consequence?
A. The command produces an error.
B. The calibration process runs successfully and populates all the bind variables.
C. The calibration process runs successfully but the latency time is not computed.
D. The calibration process runs successfully but only the latency time is computed.