Guaranteed 1Z0-053 Study Guides 2021

NEW QUESTION 1
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? (Choose two.)

• A. An entry is created in the alert log file and the database instance continues to function normally
• B. The log switch hangs occur for transactions until free space is available in the flash recovery area
• C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
• D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Answer: BC

NEW QUESTION 2
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:
SQL> SELECT * FROM sales;
Which process would retrieve the result from the database and return it to the client program?

• A. User process
• B. Server process
• C. System Monitor (SMON)
• D. Process Monitor (PMON)
• E. Checkpoint process (CKPT)

Answer: B

NEW QUESTION 3
You executed the following commands:
SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS',
'PUBLISH','false');
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');
Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

• A. The statistics are stored in the pending statistics table in the data dictionary.
• B. The statistics are treated as the current statistics by the optimizer for all sessions.
• C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
• D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Answer: A

NEW QUESTION 4
You are managing a 24*7 database. The backup strategy for the database is to perform user-managed backups.
Identify two prerequisites to perform the backups. (Choose two.)

• A. The database must be opened in restricted mode.
• B. The database must be configured to run in ARCHIVELOG mode.
• C. The tablespaces are required to be in backup mode before taking the backup.
• D. The tablespaces are required to be in read-only mode before taking the backup

Answer: BC

NEW QUESTION 5
View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command? Exhibit:

• A. The command performs the recovery and closes the failures.
• B. The command only displays the advice and the RMAN script required for repair.
• C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.
• D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Answer: C

NEW QUESTION 6
Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all
that apply.)

• A. A single SQL statement provided by a user
• B. An existing SQL Tuning Set (STS)
• C. A preprocessed Database Replay workload
• D. A schema name
• E. SQL statement identified in EM as using excessive resources

Answer: CD

NEW QUESTION 7
In which two aspects does hot patching differ from conventional patching? (Choose two.)

• A. It consumes more memory compared with conventional patching.
• B. It can be installed and uninstalled via OPatch unlike conventional patching.
• C. It takes more time to install or uninstall compared with conventional patching.
• D. It does not require down time to apply or remove unlike conventional patching.
• E. It is not persistent across instance startup and shutdown unlike conventional patching.

Answer: AD

NEW QUESTION 8
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?

• A. alter tablespace DAVE_TBS backup mode;
• B. alter tablespace DAVE_TBS start backup;
• C. alter tablespace DAVE_TBS begin backup;
• D. alter tablespace DAVE_TBS backup begin;
• E. alter tablespace DAVE_TBS backup;

Answer: C

NEW QUESTION 9
You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?

• A. A different procedure is required to restore a database from compressed backups
• B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
• C. Using this command to create backups minimizes the bandwidth consumed
• D. Using this command to create backups improves the performance of the backup process

Answer: C

NEW QUESTION 10
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?

• A. The SGA Tuning Advisor
• B. The SQL Access Advisor
• C. The SQL Tuning Advisor
• D. The Memory Advisor

Answer: C

Explanation: The SQL Access Advisor allows the DBA to gather global recommendations for a workload. The SQL Tuning advisor is more granular, tuning a single statement.
The main functions of the SQL Access advisor is to recommend missing indexes and materialized views, but a comprehensive task analysis will also create SQL Profiles that can be used within the SQL Tuning advisor. The DBA defines the SQL used in the SQL Access Advisor task, and can choose current SQL, a user-defined set of SQL, a historical workload, or a hypothetical workload.
A hypothetical workload is very useful because the DBA need-only specify the tables that participate in the queries, and the SQL Access Advisor gathers the appropriate SQL statements to create the workload. The SQL Tuning Advisor (STA) is primarily designed to replace the manual tuning of SQL statements and speed up the overall SQL tuning process. The SQL Tuning Advisor studies poorly executing SQL statements and evaluates resource consumption in terms of CPU, I/O, and temporary space.
The SQL Tuning Advisor (STA) works with the Automatic Tuning Optimizer (ATO) to analyze historical SQL workload using data from the AWR, and it generates recommendations for new indexes and materialized views that will reduce the disk I/O
associated with troublesome SQL statements.
http://www.dba-oracle.com/oracle10g_tuning/t_sql_tuning_advisor.htm

NEW QUESTION 11
Which two statements about workload capture and replay operations are true? (Choose two.)

• A. The clients must be created manually on the test machines to perform more realistic testing.
• B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
• C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
• D. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

Answer: CD

NEW QUESTION 12
Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

• A. An ASM instance mounts an ASM control file
• B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
• C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
• D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Answer: CD

NEW QUESTION 13
To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?

• A. RESUMABLE_SPACE_TIME
• B. RESUMABLE_SPACE
• C. RESUMABLE_TIME
• D. RESUMABLE_TIMEOUT
• E. TIME_RESUMABLE

Answer: D

NEW QUESTION 14
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

• A. It does not allow you to change the moving window size.
• B. Adaptive threshold functionalities use it by default to compute statistics.
• C. It is created by default with the window size being equal to the AWR retention time.
• D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

Answer: BC

Explanation: A moving window baseline corresponds to all AWR data that exists within the AWR retention period. This is useful when using adaptive thresholds because the database can use AWR data in the entire AWR retention period to compute metric threshold values. Oracle Database automatically maintains a system-defined moving window baseline. The
default window size for the system-defined moving window baseline is the current AWR retention period, which by default is 8 days. If you are planning to use adaptive thresholds, consider using a larger moving window—such as 30 days—to accurately compute threshold values. You can resize the moving window baseline by changing the number of days in the moving window to a value that is equal to or less than the number of days in the AWR retention period. Therefore, to increase the size of a moving window, you must first increase the AWR retention period accordingly.

NEW QUESTION 15
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.
Which option must you use to check whether a flashback operation can recover the database to the specified time?

• A. Check the alert log file
• B. Query the V$FLASHBACK_DATABASE_LOG view
• C. Query the V$RECOVERY_FILE_DEST_SIZE view
• D. Query the V$FLASHBACK_DATABASE_STAT view
• E. Check the value assigned for the UNDO_RETENTION parameter

Answer: B

Explanation: To query the V$FLASHBACK_DATABASE_LOG to get the lowest SCN or the nearest TIMESTAMP to decide the recovery possibility.

NEW QUESTION 16
What information does the report schema command not provide? (Choose all that apply.)

• A. Size of the datafiles
• B. Size of the tempfiles
• C. Date of last backup for datafiles and tempfiles
• D. Filenames for each datafile
• E. Checkpoint SCN associated with the last RMAN backup

Answer: CE

NEW QUESTION 17
Which of the following options describes Segment Shrink?

• A. Reclaims space above and below the high-water mark without using additional space
• B. Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation
• C. Deallocates space above the high-water mark that is currently not in use
• D. None of the above

Answer: A