It is more faster and easier to pass the Oracle 1Z0-052 exam by using Breathing Oracle Oracle Database 11g: Administration I questuins and answers. Immediate access to the Update 1Z0-052 Exam and find the same core area 1Z0-052 questions with professionally verified answers, then PASS your exam with a high score now.

2021 Jan 1Z0-052 exam

Q61. You notice that the performance of the database has degraded because of frequent checkpoints.

Which two actions resolve the issue? (Choose two.)

A. Disable automatic checkpoint tuning

B. Check the size of the redo log file size and increase the size if it is small

C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group

Answer: BC


Q62. You executed the following command to perform a backup of the USERS tablespace:

SQL> ALTER TABLESPACE users BEGIN BACKUP;

ALTER TABLESPACE users BEGIN BACKUP

*

ERROR at line 1:

ORA-01123: cannot start online backup; media recovery not enabled

What could be the reason for this error?

A. The MTTR Advisor is disabled.

B. The database is in NOARCHIVELOG mode.

C. The tablespace is already in backup mode.

D. The Flash Recovery Area is not configured.

Answer: B


Q63. You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.

View the Exhibit and check the commands executed.

What is the location of the alert_orcl.log file?

A. ORACLE_HOME/dbs

B. ORACEL_HOME/rdbms

C. /u01/app/oracle/admin/orcl/adump

D. /u01/app/oracle/flash_recovery_area

E. ORACLE_BASE/diag/rdbms/orcl/alert

F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

Answer: F


Q64. A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

Which are the two possible solutions to enable SMITH to query the data in V$SESSION? (Choose two.)

A. granting SELECT privilege to SMITH on V$SESSION

B. granting SELECT privilege to SMITH on V_$SESSION

C. asking the user SMITH to run the catalog.sql script

D. granting SELECT privilege to SMITH on V$FIXED_TABLES

E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

F. creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

Answer: BF


Q65. 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.

Answer: AB


Latest 1Z0-052 practice test:

Q66. Which of these is true about undo tablespace?

A. Undo tablespace is a temporary tablespace

B. Undo tablespace has only one datafile

C. Undotablespace has a datafile which is reused in cyclic manner

Answer: A


Q67. In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.

What would you do to automate this configuration for the memory components with change in mode of working?

A. Set the SGA_TARGET initialization parameter to zero.

B. Set the PRE_PAGE_SGA initialization parameter to TRUE.

C. Set the MEMORY_MAX_TARGET initialization parameter to zero.

D. Set the SGA_TARGET initialization parameter to a nonzero value.

Answer: D


Q68. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?

A. Use the external table population.

B. Use the Oracle Data Pump export and import utility.

C. Use the conventional path data load of the SQL*Loader utility.

D. Use the INSERT INTO...SELECT command to load the data.

Answer: C


Q69. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

A. When the data file of the undo tablespace is autoextensible

B. When there are more than one undo tablespace available in the database

C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

D. When the undo tablespace is autoextensible and retention guarantee is not enabled

Answer: C


Q70. You executed this command to create a temporary table:

SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (

startdate DATE,

enddate DATE,

class CHAR(20)

) ON COMMIT PRESERVE ROWS;

Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction?

A. The rows stay in the table only until session termination

B. The rows stay in the table only until the next transaction starts on the table

C. The rows are visible to all current sessions after the transaction in committed

D. The rows stay available for subsequent sessions after the transaction is committed

Answer: A