Online Access Free 1z0-064 Exam Questions

Examine the structure of the EMPLOYEES table.

EMPLOYEE_ID is the primary key. No other indexes exist on this table.
View the Exhibit to examine the commands and their output.

Which two actions should you perform to make the cursor bind aware? (Choose two.)

• A.Create a histogram on the DEPARTMENT_ID column.
• B.Execute the query with the same DEPARTMENT_ID value multiple times.
• C.Gather statistics for the index.
• D.Regather statistics on the table.
• E.Create an index on the DEPARTMENT_ID column.
• F.Change the default CURSOR_SHARING value to FORCE.

You want to enable the Database Smart Flash Cache feature on your database. For this purpose, you configure two flash devices: /dev/sdj and /dev/sdk, with sizes of 64 GB and 32 GB, respectively.
Examine the parameters set for your database instance:

How would you make sure that the database uses these devices for Database Smart Flash Cache?

• A.by setting the value of the DB_FLASH_CACHE_SIZE parameter to 64G, 32G
• B.by setting the DB_FLASH_CACHE_SIZE parameter to 86G and the MEMORY_TARGET parameter to 112G
• C.by setting the value of the DB_FLASH_CACHE_SIZE parameter to 8G
• D.by configuring the DB_FLASH_CACHE_SIZE parameter and making sure that all flash devices are of the same size
• E.by disabling Automatic Memory Management, setting SGA_TARGET to 96G, and setting the required memory that you want to set for SGA

You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads.
Which action would you take to achieve this? (Choose the best answer.)

• A.Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.
• B.Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.
• C.Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.
• D.Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.

Which two statements are true about viewing the details of Real-Time Database Operations? (Choose two.)

• A.When the SQL statement that is being monitored is executing, V$SQL_MONITOR is refreshed once every minute. After the execution ends, the monitoring information in V$SQL_MONITOR is deleted immediately.
• B.Oracle Enterprise Manager Cloud Control can be used to view running database operations.
• C.In V$SQL_MONITOR monitoring, statistics are cumulative over several executions of the SQL statement that is being monitored in a session.
• D.SQL Developer can be used to view running database operations.
• E.Oracle Enterprise Manager Database Express can be used to view running database operations.

You want to generate statistics for new objects added to an OLTP application without affecting old statistics and the sessions that currently use them.
Which two tasks would you perform to test the new statistics? (Choose two.)

• A.Set the STALE_PERCENT statistics preference to zero and then gather statistics.
• B.Set the NO_INVALIDATE statistics preference to FALSE and gather statistics without affecting old statistics.
• C.Set the PUBLISH statistics preference to FALSE and then gather statistics.
• D.Use the DBMS_STATS.PUBLISH_PENDING_STATS procedure to make pending statistics the current statistics.
• E.Set the OPTIMIZER_USE_PENDING_STATISTICS initialization parameter to TRUE for the session.