PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)
BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2
QUESTION 7
You recently joined a new team administering a database. You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job. You decide that performance problems are caused by a misconfiguration of factors affecting full table scans. Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)
A. value of DB_FILE_MULTIBLOCK_READ_COUNT
B. storing query results in the result cache
C. setting of the DISK_ASYNC_IO parameter to TRUE
D. setting of the OPTIMIZER_MODE parameter to ALL_ROWS
E. use of parallel queries
F. block size of the tablespaces in which the tables being scanned are stored
G. value of the OPTIMIZER_DYNAMIC_SAMPLING parameter
Answer: ACF
QUESTION 8
Examine an extract from a PGA Memory Advisory for your database:
Which two inferences are correct? (Choose two.)
A. Automatic management of PGA memory is disabled.
B. The current PGA size requires the use of a temporary tablespace for sorting operations.
C. The current PGA size is sufficient and does not require the memory manager to allocate more memory.
D. PGA size should be increased at least four times its current size for significant improvement in performance and disk space management.
Answer: BD
QUESTION 9
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. Change the default CURSOR_SHARING value to FORCE.
C. Execute the query with the same DEPARTMENT_ID value multiple times.
D. Create an index on the DEPARTMENT_ID column.
E. Gather statistics for the index.
F. Regather statistics on the table.
Answer: CD
QUESTION 10
For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace. You want to control the usage of the UNDO tablespace only for these user sessions. How would you avoid the issue from repeating in future? (Choose the best answer.)
A. Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.
B. Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.
C. Set the threshold for UNDO tablespace usage for the users.
D. Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.
Answer: D
QUESTION 11
Examine the parameters set for your database instance:
You are asked by a developer to create a table for an application with these requirements:
– The table will be used for a DSS application.
– High volume bulk loads will be performed.
– The table will be used to store archival data on which large full-table scans (FTS) will be performed.
Which attributes are the best for the tablespace in which this table should be created? (Choose the best answer.)
A. Create it in a locally managed tablespace with ASSM enabled and assign a high value for the PCTFREE attribute.
B. Create it in a locally managed tablespace with manual segment space management.
C. Create it in a locally managed tablespace with a bigger nonstandard block size and ASSM enabled.
D. Create it in locally managed tablespace with ASSM enabled and an additional freelist.
Answer: D
QUESTION 12
Examine the parameters set for your database instance:
You upgrade your database to Oracle Database 12c. The database supports a mixed workload and works with different workloads at different times. You notice in an ADDM report that the shared pool is inadequately sized. You resize the shared pool by decreasing the sizes of other pools, which results in inadequate sizes for other pools. You want to automate the sizing of SGA components. Which two actions should you perform? (Choose two.)
A. Set the SGA_TARGET parameter equal to SGA_MAX_SIZE.
B. Set the SGA_TARGET parameter to the sum of DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE.
C. Set the MEMORY_MAX_TARGET parameter to the sum of DB_CACHE_SIZE, SHARED_POOL, and LARGE_POOL_SIZE.
D. Set DB_CACHE_SIZE,SHARED_POOL, and LARGE_POOL_SIZE to their minimum required values.
E. Set the PGA_AGGREGATE_TARGET parameter to 0 and the SGA_TARGET parameter to 1.5G.
Answer: AD
PassLeader now are offering 100% pass ensure 1Z0-064 dumps! All 1Z0-064 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-064 VCE dumps and PDF dumps: https://www.passleader.com/1z0-064.html (90 Q&As)
BTW: Download PassLeader 1Z0-064 dumps from Google Drive for free: https://drive.google.com/open?id=1ZJ8IAgupu8ZxjCosUsnrIai3zsPlhNd2