1Z0-060 Exam Question 51

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:

The possible outcomes of this command and the actions to aggregate 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. Trace files may be aggregated by using the trcess utility.
5. Trace files may be aggregated by using the tkprof utility.
Identify the correct outcome and the action to aggregate the trace files.
  • 1Z0-060 Exam Question 52

    Which two statements are true about the RMAN validate database command?
  • 1Z0-060 Exam Question 53

    On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees
    Which two statements are true regarding the command?
  • 1Z0-060 Exam Question 54

    You Execute the Following command to create a password file in the database server:
    $ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12' Which two statements are true about the password file? (Choose two.)
  • 1Z0-060 Exam Question 55

    A database is stored in an Automatic Storage Management (ASM) disk group, DGROUP1, created with SQL:

    There is enough free space in the disk group for mirroring to be done.
    What happens if the CONTROLLER1 failure group becomes unavailable due to error or for maintenance?