Breathing 1Z0-053 Dumps Questions 2021

NEW QUESTION 1
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

• A. V$VALID_NLS_VALUES
• B. NLS_VALID_VALUES
• C. NLS_VALUE_OPTIONS
• D. V$NLS_VALUE_OPTIONS
• E. V$NLS_VALID_VALUES

Answer: E

NEW QUESTION 2
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

• A. SORT_AREA_SIZE
• B. HASH_AREA_SIZE
• C. BITMAP_MERGE_AREA_SIZE
• D. CREATE_BITMAP_AREA_SIZE
• E. PGA_AGGREGATE_TARGET

Answer: ABCD

NEW QUESTION 3
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode? (Choose all that apply.)

• A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
• B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
• C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
• D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

Answer: CD

NEW QUESTION 4
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

• A. Alert log file
• B. Archived redo log files
• C. Control file autobackups
• D. Server Parameter file (SPFILE)
• E. Recovery Manager (RMAN) backup piece

Answer: BCE

NEW QUESTION 5
Every resource plan must contain an allocation to which consumer group?

• A. LOW_GROUP
• B. SYS_GROUP
• C. DEFAULT_GROUP
• D. BASE_GROUP
• E. OTHER_GROUPS

Answer: E

NEW QUESTION 6
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?

• A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
• B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
• C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
• D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

Answer: C

NEW QUESTION 7
If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

• A. The next time you back up the database when you are also connected to the recovery catalog and the target database
• B. The next time you are connected to the target database and the recovery catalog database and issue the resync command
• C. The next time you connect RMAN to just the recovery catalog
• D. The next time you connect to the recovery catalog and the target database with RMAN
• E. Connecting to the recovery catalog and issuing the resync all databases command

Answer: AB

Explanation: Deciding When to Resynchronize the Recovery Catalog
RMAN automatically resynchronizes the recovery catalog when
✑ RMAN is connected to a target database and recovery catalog
✑ And you have executed RMAN commands.
Thus, you should not need to manually run the RESYNC CATALOG command very often.

NEW QUESTION 8
Which command will result in a trace file being created with the create controlfile command contained in it?

• A. alter database backup controlfile;
• B. alter database backup controlfile to trace;
• C. alter database controlfile backup;
• D. alter database controlfile backup to '/ora01/oracle/ctrl_backup.ctl';
• E. alter database begin controlfile backup;

Answer: B

Explanation: ALTER DATABASE BACKUP CONTROLFILE TO TRACE
Specify TO TRACE if you want Oracle Database to write SQL statements to a trace file rather than making a physical backup of the control file. You can use SQL statements written to the trace file to start up the database, re-create the control file, and recover and open the database appropriately, based on the created control file. If you issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement while block change tracking is enabled, then the resulting trace file will contain a command to reenable block change tracking.
The trace file will also include ALTER DATABASE REGISTER LOGFILE statements for existing logfiles that reside in the current archivelog destinations. This will implicitly create database incarnation records for the branches of redo to which the logfiles apply.
You can copy the statements from the trace file into a script file, edit the statements as necessary, and use the script if all copies of the control file are lost (or to change the size of the control file).

NEW QUESTION 9
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?

• A. NLS_SORT = BINARY
• B. NLS_SORT = BINARY_AI
• C. NLS_SORT = BINARY_CI
• D. NLS_SORT = BINARY_AI_CI
• E. Binary sorts are case insensitive and accent insensitive by default.

Answer: B

NEW QUESTION 10
Which dependent object will get invalidated even if it is not affected by the table redefinition?

• A. packages
• B. triggers
• C. synonyms
• D. views

Answer: B

Explanation: Results of the Redefinition Process
The following are the end results of the redefinition process:
The original table is redefined with the columns, indexes, constraints, grants, triggers, and statistics of the interim table.
Dependent objects that were registered, either explicitly using REGISTER_DEPENDENT_OBJECT or implicitly using COPY_TABLE_DEPENDENTS, are renamed automatically so that dependent object names on the redefined table are the same as before redefinition.
Note:
If no registration is done or no automatic copying is done, then you must manually rename the dependent objects.
The referential constraints involving the interim table now involve the redefined table and
are enabled.
✑ Any indexes, triggers, materialized view logs, grants, and constraints defined on the original table (prior to redefinition) are transferred to the interim table and are dropped when the user drops the interim table. Any referential constraints involving the original table before the redefinition now involve the interim table and are disabled.
✑ Some PL/SQL objects, views, synonyms, and other table-dependent objects may become invalidated. Only those objects that depend on elements of the table that were changed are invalidated. For example, if a PL/SQL procedure queries only columns of the redefined table that were unchanged by the redefinition, the procedure remains valid. See "Managing Object Dependencies" for more information about schema object dependencies.

NEW QUESTION 11
Which of the following are included in a transportable tablespace set? (Choose all that apply.)

• A. The datafiles that make up a self-contained group of tablespaces required for copy
• B. The system tablespace
• C. An export of the tablespace metadata
• D. The spfile
• E. All of the above

Answer: AC

NEW QUESTION 12
Which command would correctly start a TSPITR of the USERS tablespace?

• A. Option A
• B. Option B
• C. Option C
• D. Option D
• E. Option E

Answer: E

Explanation: Topic 10, Monitoring and Tuning RMAN

NEW QUESTION 13
You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?
1. Take the datafiles that were lost offline.
2. startup mount the database
3. Issue the alter database open command.
4. Restore the datafiles that were lost
5. Recover the datafiles with the recover datafile command.
6. Bring the datafiles back online.
7. Recover the database with the recover database command.

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

Answer: B

NEW QUESTION 14
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

• A. The plan baselines can be evolved over time to produce better performance.
• B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
• C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
• D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

Answer: AC

Explanation: Purpose of SQL Plan Baselines
Common scenarios where SQL plan management can improve or preserve SQL performance include:
A database upgrade that installs a new optimizer version usually results in plan changes for a small percentage of SQL statements. Most of these plan changes result in either no performance change or improvement. However, some plan changes may cause performance regressions. SQL plan baselines significantly minimize potential regressions resulting from an upgrade.
Ongoing system and data changes can impact plans for some SQL statements, potentially causing performance regressions. SQL plan baselines help minimize performance regressions and stabilize SQL performance.
Deployment of new application modules means introducing new SQL statements into the database. The application software may use appropriate SQL execution plans developed in a standard test configuration for the new statements. If the system configuration is significantly different from the test configuration, then the database can evolve SQL plan baselines over time to produce better performance.

NEW QUESTION 15
You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose.
What are the prerequisites for performing the active database duplication? (Choose all that apply.)

• A. The source database backup must be copied over the net for test database.
• B. The source database must be run in ARCHIVELOG mode if the database is open.
• C. The source database must be shut down cleanly if the database is in mounted state.
• D. A net service name should be set up and a listener configured with the target as well as the source database.

Answer: BCD

Explanation: To ensure that the source database is in the proper state:
1. If the source database instance is not mounted or open, then mount or open it.
2. If you are performing active database duplication, then ensure that the following additional requirements are met:
If the source database is open, then archiving must be enabled.
If the source database is not open, then the database does not require instance recovery. (Tips: does not require instance recovery, means you cannot shutdown the source database with abort option, you need to shutdown it cleanly.)
Starting RMAN and Connecting to Databases:
In this task, you must start the RMAN client and connect to the database instances required by the duplication technique chosen in "Step 1: Choosing a Duplication Technique". The RMAN client can be located on any host so long as it can connect to the necessary databases over the network.

NEW QUESTION 16
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

• A. Automatic PGA Memory Management
• B. Automatic SGA Memory Management
• C. Automatic Shared Memory Management
• D. Automatic Memory Management
• E. Manual SGA Memory Management
• F. None of the above

Answer: C

NEW QUESTION 17
You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically.
Which action would you perform to achieve this?

• A. Edit the automatic maintenance window group configuration.
• B. Set the CURSOR_SHARING parameter to EXACT for the database instance.
• C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.
• D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.

Answer: C