Online Access Free 1Z0-072 Exam Questions

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

• A.V$SESSION_EVENT
• B.V$SYSTEM_EVENT
• C.V$SESSION_WAIT_CLASS
• D.V$SESSION_WAIT
• E.V$SESSION

Which two are true about RETENTION GUARANTEE? (Choose two.)

• A.It is a tablespace attribute.
• B.It prevents out-of-space errors.
• C.It prevents FLASHBACK DATABASE operation failure.
• D.It prevents "Snapshot too old" errors.
• E.It is a static parameter.

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

Which two actions are performed? (Choose two.)

• A.The control file is read.
• B.The Oracle background processes are started.
• C.The alert log records the execution details.
• D.The online redo logs are opened.
• E.The initialization parameter file is read.
• F.The online data files are opened.

Which two functions are performed by a listener?

• A.verifying the service name in an incoming user request
• B.returning the results of processing from the server process to the user process
• C.connecting a user process to a server process
• D.maintaining the connection to a client's user process until the user request is completed
• E.verifying a user's authentication credentials
• F.creating a user session in the System Global Area (SGA)

Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.
Examine these steps:
1. Shut down the database instance.
2. Modify the parameter in the spfile with scope = SPFILE.
3. Modify the parameter in a pfile.
4. Use the spfile to create a pfile.
5. Use the pfile to create a spfile.
6. Modify the parameter in the spfile with scope = BOTH.
7. Start up the database instance.
Which are the minimum required steps in the correct order?

• A.1, 2, 7
• B.6, 1, 7
• C.1, 4, 3, 5, 7
• D.1, 7, 2
• E.2, 1, 7