Free Oracle 1Z0-042 Exam Dumps Questions & Answers

View the Exhibit and examine the output. Which statement describes the conclusion?

• A.  The dictionary cache is consuming more space than the library cache.
• B.  Preparing indexes on the tables used in the SQL statements would improve the library cache performance.
• C.  The shared pool size should be increased to accommodate the SQL statements.
• D.  The users should use bind variables instead of literals in the query.

The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index?

• A.  The index becomes invalid after the update.
• B.  The leaf block containing the row to be updated is marked as invalid.
• C.  An update in a leaf row takes place.
• D.  A row in the leaf block of the index for the key value is deleted and inserted.

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

• A.  external naming method
• B.  local naming method
• C.  directory naming method
• D.  host naming method

Your database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups? (Choose three.)

• A.  The backups would be possible only if the database is running in ARCHIVELOG mode.
• B.  The backups would be possible only if the database is running in NOARCHIVELOG mode.
• C.  The backups would be inconsistent.
• D.  The backups would be consistent.
• E.  The backups need to be restored and database has to be recovered in case of a media failure.
• F.  The backups need not be restored during recovery in case of a media failure.

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?

• A.  use the Oracle Data Pump export and import utility
• B.  use the external table population
• C.  use the conventional path data load of SQL*Loader utility
• D.  use the direct path data load of Oracle export and import utility