QUESTION 41
After being hired as a database administrator, you find that there is only one database that is functional and that is being accessed by the applications. You want to create a replica of the database, to be used for testing purposes. What is the best method to create the replica?

A.    create a database by using CREATE DATABASE .. command and manually copy the data
B.    use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure
C.    use DBCA to create a template from the existing database to contain the database structure and then manually copy the data using Oracle Data Pump
D.    use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location

Answer: D

QUESTION 42
You are working on an online transaction processing (OLTP) system. You notice that a PL/SQL procedure got executed twice at 2:00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2:00 p.m.?

A.     Perform point-in-time recovery to 2: 00 p.m.
B.    Use Flashback Table feature to revert the changes.
C.    Restore the entire database from the recent backup and open it.
D.    Issue the rollback statement with system change number (SCN).

Answer: B

QUESTION 43
A user complains about getting this error after issuing a certain SQL statement: ORA-02393: exceeded call limit on CPU usage. Because of the error, the SQL statement gets aborted. What action would you take to increase the CPU usage limit in the subsequent sessions of the user?

A.    Modify the resource limit in the profile used by the user.
B.    Set the RESOURCE_LIMIT initialization parameter to FALSE.
C.    Increase the value of the SESSION_CACHED_CURSORS initialization parameter.
D.    Increase the value of the SESSION_MAX_OPEN_FILES initialization parameter.

Answer: A

QUESTION 44
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?

A.    Set the STATISTICS_LEVEL initialization parameter to ALL.
B.    Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
C.    Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
D.    Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid the automatic purging of the snapshots.

Answer: B

QUESTION 45
Which three statements are true regarding the fine-grained auditing (FGA)? (Choose three.)

A.    FGA is possible on SELECT statements only.
B.    The audit trail for FGA is stored in the FGA_LOG$ table.
C.    The audit trail for FGA is stored in the AUD_LOG$ table.
D.    FGA enables a SQL predicate to define when to audit an event.
E.    FGA audits DELETE statements only when audit columns are specified.
F.    FGA includes the SQL statement used by the user as part of the audit event entry.

Answer: BDF

QUESTION 46
You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time? (Choose two.)

A.    By multiplexing the control files
B.    By multiplexing the redo log files
C.    By decreasing the size of redo log files
D.    By configuring mean time to recover (MTTR) to a lower value
E.    By setting the UNDO_RETENTION parameter to a higher value

Answer: CD

QUESTION 47
The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?

A.    The instance would hang.
B.    The instance needs to be shut down.
C.    The instance would be in the open state.
D.    The instance would abort in such cases.
E.    The instance would be in the open and invalid state.
F.    The instance would in the open state, but all the background processes will be restarted.

Answer: D

QUESTION 48
In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?

A.    The trace file
B.    The fixed views
C.    The data dictionary views
D.    The operating system log fields
E.    The dynamic performance views.

Answer: E

QUESTION 49
You have set the retention period for Automatic Repository (AWR) statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics? (Choose two)

A.    use enterprise manager
B.    use DBMS_SQL package
C.    use DBMS_AWR package
D.    use PRVT_WORKLOAD package
E.    query the AWR snapshot repository objects
F.    use DBMS_WORKLOAD_REPOSITORY package

Answer: AF

QUESTION 50
You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation. Which advisory component would you refer to, in order to determine the appropriate indexes?

A.    Memory Advisors
B.    Segment Advisors
C.    SQL Tuning and Access Advisors
D.    Automated Workload Repository (AWR)
E.    Automatic Database Diagnostic Monitor (ADDM)

Answer: C

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