Question 76
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE ('SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1.The command fails because a module name is not specified.
2.A trace file is created for each session that is running the SRV1 service.
3.An aggregated trace file is created for all the sessions that are running the SRV1 service.
4.The trace files may be aggregated by using the trcess utility.
5.The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE ('SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1.The command fails because a module name is not specified.
2.A trace file is created for each session that is running the SRV1 service.
3.An aggregated trace file is created for all the sessions that are running the SRV1 service.
4.The trace files may be aggregated by using the trcess utility.
5.The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?
Question 77
Which three statements are true about Oracle Data Pump export and import operations?
Question 78
Which two are prerequisites for performing a flashback transaction? (Choose two.)
Question 79
Which two statements are true when row archival management is enabled?
Question 80
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:

What is the result?

What is the result?
