QUESTION 51
In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2.
What would this setting achieve?

A.    It degrades the run time and compiler performance.
B.    It provides better run time and compiler performance.
C.    It provides better optimization of the statement during parse time.
D.    It forces the rule based optimizer to be used for statement optimization.
E.    It provides better run time performance but slightly degraded compiler performance.
F.    It provides better run time performance but slightly degraded run time performance.

Answer: E

QUESTION 52
While planning to manage more than one database in your system, you perform the following activities:
1. Organize different categories of files into independent subdirectories.
2. Use consistent naming convention for database files.
3. Separate administrative information pertaining to each database.
Which option corresponds to the type of activities performed by you?

A.    Oracle Managed Files
B.    Oracle Grid Architecture
C.    Optimal Flexible Architecture
D.    Oracle database architecture

Answer: C

QUESTION 53
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.    host naming method
B.    local naming method
C.    external naming method
D.    directory naming method

Answer: B

QUESTION 54
Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

A.    The operation would fail if tbs_1 were a read-only tablespace.
B.    The operation would fail if tbs_1 were a read/write tablespace.
C.    The operation would fail if tbs_1 were the default tablespace for the database.
D.    If the above operation were successful, media recovery would be required to bring the tablespace online.
E.    If the above operation were successful, instance recovery would be required to bring the tablespace online.

Answer: D

QUESTION 55
You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

A.    Run the SQL Access Advisor.
B.    Run the SQL Tuning Advisor (STA).
C.    Run the Automatic Workload Repository (AWR) report.
D.    Run the Automatic Database Diagnostic Monitor (ADDM).

Answer: A

QUESTION 56
You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task?

A.    Upgrade the hardware/memory to accommodate the data.
B.    Load the data into your database by using the PARALLEL clause.
C.    Give analysts DBA privilege, so that they can query DBA_EXTERNAL_TABLES.
D.    Use an external table so you can have the metadata available in your database, but leave the
data in the operating system files.

Answer: D

QUESTION 57
A user receives the following error while executing a query:
ORA-01555: snapshot too old
Which two options can be the solutions to avoid such errors in future? (Choose two.)

A.    increase the size of redo log files
B.    increase the size of the undo tablespace
C.    increase the size of the Database Buffer Cache
D.    increase the size of the default temporary tablespace
E.    enable the retention guarantee for the undo tablespace

Answer: BE

QUESTION 59
You executed the following command to export the EMPLOYEES table from a remote machine:
$ EXPDP hr/[email protected]
   DUMPFILE=my_dir:exp_hr.log
   LOGFILE=data_pump_dir:log_hr.log
   TABLES=employees
What would be the outcome of this command?

A.    The command would execute successfully and the export dump file would be created in the destination
of the directory object MY_DIR.
B.    The command would execute successfully. But log file would not be created as DATA_PUMP_DIR
directory is only accessible to user with SYSDBA privilege.
C.    The command fails with an error because DATA_PUMP_DIR directory have higher precedence over
the per-file directory.
D.    The command fails with an error because no absolute path is specified for log file and dumpfile.

Answer: A

QUESTION 60
You execute the following command to audit the database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

A.    One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B.    One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.    One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.    One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

Answer: A

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader