1z0-064 試験問題を無料オンラインアクセス

You observe that queries are performing poorly on the SALES_RECORDS table in your database. On investigation, you find that at the end of each day the contents of the SALES_RECORDS table are moved to the SALES_HISTORY table. The delete operations cause the table to be sparsely populated.
The SALES_RECORDS table is created in a tablespace using Automatic Segment Space Management (ASSM) and row movement is enabled. The table must be accessible 24x7.
Which two tasks would you recommend to improve the performance? (Choose two.)

• A.Move the SALES_RECORDS table to a tablespace by using manual segment space management.
• B.Move the SALES_RECORDS table to a different location by using the ALTER TABLE...MOVE command.
• C.Reorganize the SALES_RECORDS table online by using the DBMS_REDEFINITION package.
• D.Perform EXPORT, DROP, and IMPORT operations on the SALES_RECORDS table.
• E.Shrink the SALES_RECORDS table by using the ALTER TABLE...SHRINK SPACE command.
• F.Deallocate the space in the SALES_RECORDS table by using the ALTER TABLE...DEALLOCATE UNUSED command.

Your database supports multiple applications. The applications run on the middle tier and use connection for connecting to the database.
You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities.
What action must you perform to achieve this?

• A.Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.
• B.Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.
• C.Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.
• D.Create services for the applications and set a relative priority by assigning them to application users.

Which two statements are true about Active Session History (ASH)? (Choose two.)

• A.An ASH report can be used to identify the service that may be the cause of a transient performance problem.
• B.ASH samples data from V$SESSION every second.
• C.ASH contains sampled data from all sessions that are connected to a database instance at any given moment.
• D.The Data Sample size available in an ASH report is dynamic and, at any given moment, is directly related to the amount of work being performed.

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 disabling Automatic Memory Management, setting SGA_TARGET to 96G, and setting the required memory that you want to set for SGA
• 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 setting the value of the DB_FLASH_CACHE_SIZE parameter to 64G, 32G
• E.by configuring the DB_FLASH_CACHE_SIZE parameter and making sure that all flash devices are of the same size

You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%.
Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)

• A.the alert log
• B.Oracle Enterprise Manager Cloud Control
• C.DBA_ALERT_HISTORY
• D.DBA_THRESHOLDS
• E.DBA_ACTIVE_SESSION_HISTORY
• F.DBA_OUTSTANDING_ALERTS