Free Oracle 1Z0-052 Exam Dumps Questions & Answers

In which situation would you use static database registration for a listener?

• A.  When DBAs need to connect remotely to start up the database instance
• B.  When multiple databases are to be registered with the listener
• C.  When users need to connect the database instance using the host naming method
• D.  When the database instance that is to be registered with the listener is configured in shared server mode

View the Exhibit and examine the privileges granted to the SL_REP user.

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr; Which statement describes the outcome of the command?

• A.  The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table
• B.  The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION
• C.  The command executes successfully
• D.  The command produces an error because the EMP table is owned by SCOTT

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

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

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

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

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

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