Oracle 1Z0-052 dumps - 100% Pass Guarantee!

Your database is configured in archivelog mode.

The USERS01 tablespace is currently online.

You are required to take the tablespace offline.

Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

A. either the NORMAL or the IMMEDIATE clause

B. only the IMMEDIATE clause

C. either the NORMAL or the TEMPORARY clause

D. only the TEMPORARY clause

E. only the NORMAL clause

Which is true about external tables?

A. The ORACLE_DATAPUMP access driver can be used to load data into external tables

B. They do not support partitioning

C. Segments are allocated for external tables

D. DML operations may be performed on external tables

E. They may have indexes

You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer

(OUI) shows the message that says one of the product-specific prerequisite checks has failed:

Checking available swap space requirements ...

Expected result: 1512MB

Actual Result: 1018MB

Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the

required swap space.

What happens to the installation in this situation?

A. It can be continued.

B. It resizes the swap space automatically when you proceed further.

C. It can be continued, but the instance cannot be started without increasing the swap space.

D. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.

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

A. Listeners use only the TCP/IP protocol.

B. Multiple listener processes can run simultaneously on a host.

C. Multiple database instances can be registered with a single listener.

D. The listener-related errors can be traced only at the administrative level.

E. Only one database instance can be registered with a single listener at any time.

You are managing an Oracle Database 11g database running in ARCHIVELOG mode. The Flash Recovery Area is specified as the destination for the archived redo log files. You notice this warning in the alert log file:

ORA19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.

What would you do to reclaim the used space in the Flash Recovery Area? (Choose two.)

A. Back up the Flash Recovery Area.

B. Decrease the retention time for the database backup and flashback log files.

C. Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.

D. Manually delete all the expired backup sets from the Flash Recovery Area by using operating system (OS) commands.