Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 231:

  Which is true about enabling AUTOEXTEND for data files?

  A. It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablespace have autoextend enabled.

  B. It can be enabled only for data files in non-OMF tablespaces.

  C. It can be enabled only for data files only in smallfile tablespaces.

  D. It can be enabled only for data files only in biglfile tablespaces.

  E. It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.

  Correct Answer: E

• Question 232:

  Evaluate the following code:

  

  Which naming method creates the above code?

  A. Local naming

  B. External naming

  C. Directory naming

  D. Easy connect naming

  Correct Answer: A

• Question 233:

  The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

  

  Which statement is true regarding the archived redo log files?

  A. It will be created on the local file system in the location specified LOG_ARCHIVE_DEST_1 parameter.

  B. It will be created only in the flash recovery area (fast recovery area).

  C. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.

  D. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.

  Correct Answer: A

• Question 234:

  In which three situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose three.)

  A. If a table is not in a cluster

  B. If a table has an active trigger

  C. If a table has an encrypted column

  D. If a table has a VARCHAR2 column in it

  E. If a table has a referential integrity constraint defined on it

  Correct Answer: BCE

• Question 235:

  Which two are true about the Archive (ARCn) processes? (Choose two.)

  A. They are enabled only when the database is in ARCHIVELOG mode

  B. They create archivelogs after every log switch

  C. They are used during instance recovery

  D. They automatically delete obsolete archive logs to make space for new archive logs

  E. They archive redo directly from the redo log buffer

  Correct Answer: AD

• Question 236:

  In your database:

  SGA_TARGET = 270M

  PGA_AGGREGATE_TARGET = 90M

  The MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not configured.

  You execute the command:

  ALTER SYSTEM SET MEMORY_TARGET = 400M;

  What is the outcome and why?

  A. The execution fails because SGA_TARGET and PGA_AGGREGATE_TARGET are already configured

  B. The execution is successful and automatic memory management is enabled

  C. The execution is successful but does not enable automatic memory management because the MEMORY_MAX_TARGET parameter must be configured to a value greater than MEMORY_TARGET

  D. The execution fails because the MEMORY_MAX_TARGET parameter must be configured to 400M before configuring the MEMORY_TARGET parameter

  Correct Answer: B

• Question 237:

  The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled.

  TBS1 and TBS2 are the only user-defined tablespaces in ORCL.

  USER1.EMP is a table in TBS1.

  Examine these commands: From which files are modified blocks backed up?

  

  A. SYSTEM, SYSAUX, UNDO, and TBS1 only

  B. SYSTEM and SYSAUX only

  C. SYSTEM, SYSAUX, UNDO, and TBS2 only

  D. SYSTEM, SYSAUX and UNDO only

  E. SYSTEM, SYSAUX, UNDO, TEMP, TBS1 and TBS2

  Correct Answer: A

• Question 238:

  For which requirement should you configure shared servers?

  A. accommodating an increasing number of users who run analytical queries in a DSS environment with limited memory

  B. submitting backup jobs at regular, 24-hour intervals in an OLTP environment with limited memory

  C. using Recovery Manager (RMAN) to recover a database

  D. performing bulk-load operations in a DSS environment with limited memory

  E. accommodating an increasing number of users who run short-duration, infrequent queries in an OLTP environment with limited memory

  Correct Answer: C

• Question 239:

  When would you use memory advisors?

  A. to get a recommendation whether Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) should be implemented.

  B. to determine the impact of adding or reducing memory on DB Time

  C. to generate memory-related alerts when memory demand exceeds a specified percentage

  D. to determine the impact of adding memory on hard parse count

  E. to determine the impact of adding memory on logical and physical reads

  Correct Answer: B

• Question 240:

  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

  Correct Answer: AD