Online Access Free 1z0-064 Exam Questions

Examine the query and its execution plan:

Explained.


Which two interpretations are correct?

• A.Id 3 is the first step executed.
• B.Id 4 is the second step executed.
• C.The Id 0 step indicates the cost of the entire plan.
• D.The SORT UNIQUE operation applies only the CUST_MAIN table.

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 configuring the DB_FLASH_CACHE_SIZE parameter and making sure that all flash devices are of the same size
• C.by setting the value of the DB_FLASH_CACHE_SIZE parameter to 8G
• D.by setting the DB_FLASH_CACHE_SIZE parameter to 86G and the MEMORY_TARGET parameter to 112G
• E.by setting the value of the DB_FLASH_CACHE_SIZE parameter to 64G, 32G

Your database supports an OLTP system.
Examine the parameter values configured in your database:

The CUSTOMERS table contains 8,000 rows. The CUST_ID column is the primary key and the COUNTRY_ID column contains only three possible values: 1111, 2222, and 3333.
You execute the commands:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','CUSTOMERS');
PL/SQL procedure successfully completed.
SQL> CREATE INDEX COUNTRY_IDX ON CUSTOMERS (COUNTRY_ID);
Index created.
You then perform a series of INSERT, UPDATE, and DELETE operations on the table.
View the Exhibit to examine the query and its execution plan.

Which three options would improve the performance of the query? (Choose three.)

• A.creating a histogram on the COUNTRY_ID column
• B.regathering statistics on the CUSTOMERS table
• C.increasing the size of the PGA
• D.creating a bitmap index on the COUNTRY_ID column
• E.creating a SQL profile
• F.creating a KEEP cache

Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)

• A.ADDM runs in Partial mode to analyze any hung database issues.
• B.Real-Time ADDM is automatically invoked by ADDM at the end of every hour.
• C.ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted.
• D.Real-Time ADDM can proactively detect and diagnose transient performance issues that last for a few seconds.

You execute this query twice in a session:

Then you query V$SQL_SHARED_CURSOR for details about child cursors as shown.

Which two statements are true? (Choose two.)

• A.A subsequent execution of the query in this session will undergo a hard parse.
• B.No statistics were collected during the first execution of the query.
• C.A subsequent execution of the query in this session is likely to undergo a soft parse.
• D.The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query.
• E.The second execution of the query was hard parsed because the estimated cardinality was inaccurate.