1Z0-052 Online Practice Questions and Answers

Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)

A. UNDO segments grow or shrink automatically

B. UNDO tablespaces are created and dropped automatically

C. UNDO segments are created and dropped automatically

D. UNDO tablespaces are brought ONLINE or OFFLINE as required

E. All transactions belonging to a single session use the same UNDO segment

Which is true about the Database Configuration Assistant (DBCA)?

A. It can register a database with Cloud Control and configure Database Control for the same database.

B. It can change the server mode from dedicated to shared and vice versa for an existing database.

C. It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.

D. It can create new database templates only from existing templates or databases.

Where is backup metadata stored for use by Recovery Manager (RMAN)?

A. in the SYSTEM tablespace

B. in the control file

C. in the SPFILE

D. in the SYSAUX tablespace

E. in the diagnostic destination files

You have decided to implement the principle of least privilege and separation of duties. Which two actions must you take? (Choose two.)

A. Assign different O/S groups to the OSOPER and OSDBA credentials

B. Grant SYSOPER to application schema owners

C. Assign the OSOPER and OSDBA groups to the Oracle software owner O/S account

D. Assign the DBA role to application schema owners

E. Grant access to the Oracle software owner O/S account to all database administrators

Your database instance is in the open state with uncommitted transactions.

You plan to execute these commands:

Which is true about the STARTUP command?

A. It performs an instance recovery before opening the database in read/write mode

B. It performs an instance recovery and leaves the database instance in mount state

C. It opens the database in read-only mode

D. It opens the database in read/write mode only if an spfile is used

Which command is used to display files that no longer conform to the backup retention policy?

A. CROSSCHECK BACKUP

B. SHOW DATAFILE BACKUP COPIES

C. LIST EXPIRED BACKUP

D. REPORT OBSOLETE

Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.

What would be your next step to improve performance?

A. Run the SQL Access Advisor

B. Run the memory Advisor for the SGA

C. Run the memory Advisor for the PGA

D. Run the memory advisor for the shared pool

E. Run the memory advisor for the buffer cache

View the Exhibit and examine the output.

Which two statements are true regarding the LISTENER2 listener? (Choose two.)

A. The ORCL instance is registered dynamically with the listener.

B. The ORCL instance is registered statically in the listener.ora file.

C. The number of current client connections handled by the service handler is two.

D. The total number of client connections handled so far by the service handler is two.

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.

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 and 2

B.

2 and 5

C.

1,3, and 4

D.

3,4 and 5

E.

1,2,3 and 4