Online Access Free 1Z0-052 Practice Test

Which two statements are true regarding listeners? (Choose two.)

• A.The listener-related errors can be traced only at the administrative level.
• B.Only one database instance can be registered with a single listener at any time.
• C.Listeners use only the TCP/IP protocol.
• D.Multiple listener processes can run simultaneously on a host.
• E.Multiple database instances can be registered with a single listener.

The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?

• A.Inactive and current redo log files are required to accomplish recovery
• B.All redo log entries after the last checkpoint are applied from redo log files to data files
• C.All redo log entries recorded in the current log file until the checkpoint position are applied to data files
• D.Online and archived redo files are required to accomplish instance recovery

You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are read.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data files are checked for consistency.
7 . Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

• A.7, 1, 5, 2, 3, 6 step 4 is not required
• B.1, 2, 3, 5, 6, 4; step 7 is not required
• C.1, 5, 7, 2, 3, 6; step 4 is not required
• D.7, 1, 5, 2, 3, 6, 4

Examine the commands executed in the following sequence:

Which statement is true about the above commands?

• A.Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.
• B.The commands execute successfully.
• C.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
• D.Command 5 produces an error because a role cannot be granted to another role.
• E.Command 6 produces an error because of circular role grant.

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components WHERE current_size!=0; What do you infer from this?
Exhibit:

• A.The database instance has the MEMORY_TARGET value set to a nonzero value.
• B.All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
• C.The database instance is running with manual shared memory management.
• D.The database instance is running with manual PGA management.