1Z0-052 무료 덤프문제 온라인 액세스

Which are three of the various resources that must be accessible to keep a database open?

• A.all members of a redo log group
• B.SYSTEM tablespace
• C.control file
• D.spfile
• E.SYSAUX tablespace

Your DB_RECOVERY_FILE_DEST_SIZE is 8G.
Currently, 5G of the space is used of which 4G consists of obsolete backups.
You execute this command:
SQL> ALTER SYSTEM SET db_recovery_fle_dest_size=2G;
What is the outcome?

• A.It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameter.
• B.It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backups.
• C.It fails because the new size is less than 5G.
• D.It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.
• E.It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups.

These are points that describe the contents of different memory components:
1: Descriptive information or metadata about schema objects that are queried by using SQL statements
2: The runtime area for data manipulation language (DML) or data definition language (DDL) statements
3 : Results of SQL queries and PL/SQL functions
4 : Executable forms of SQL cursors, PL/SQL programs, and Java classes
5 : The information necessary to reconstruct changes made to the database by a transaction Which of these will be stored in the Shared Pool if the necessary configurations are done?

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

The tnsnames.ora file has an entry for the service alias ORCL as follows:
ORCL
( DESCRIPTION
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?

• A.The DEFAULT_DOMAIN parameter is set to a wrong value in the sqlnet.ora file.
• B.The TNS_ADMIN environmental variable is set to a wrong value.
• C.The listener is not running on the database node.
• D.The orcl.oracle.com database service is not registered with the listener.

A database instance was terminated due to a lost data file and has not been restarted.
You wish to restore database availability by using the Data Recovery Advisor.
Examine this list of RMAN commands:

What are the minimum required commands and in what order must they be executed to achieve this?

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