1Z0-053 Free Practice Test

- (Topic 6)
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
While copying the file to the backup destination a power outage caused the instance to terminate abnormally.
Which statement is true about the next database startup and the USERS tablespace?

1. A. The database will open, and the tablespace automatically comes out of the backup mode.
2. B. The database will be mounted, and recovery must be performed on the USERS tablespace.
3. C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
4. D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

Correct Answer: C

- (Topic 2)
Which RMAN backup command is used to create the block-change tracking file?

1. A. alter database create block change tracking file
2. B. alter database enable block change file
3. C. alter database enable block change tracking using file '/ora01/opt/block_change_tracking.fil'
4. D. alter system enable block change tracking using file '/ora01/opt/block_ change_tracking.fil'
5. E. alter system block change tracking on

Correct Answer: C

- (Topic 15)
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?

1. A. The SGA Tuning Advisor
2. B. The SQL Access Advisor
3. C. The SQL Tuning Advisor
4. D. The Memory Advisor

Correct Answer: C
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

- (Topic 14)
Which statement about Automatic Memory Management with Oracle 11g is true?

1. A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
2. B. Oracle can reallocate memory between the SGA and PGA automatically as needed.
3. C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
4. D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

Correct Answer: B

- (Topic 5)
Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?
7. shutdown immediate from RMAN
8. Log into RMAN
9. startup mount from RMAN 10.backup database
11. alter database open
12. backup database plus archivelog delete input

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

Correct Answer: E
Backing Up a Database in NOARCHIVELOG Mode
If a database runs in NOARCHIVELOG mode, then the only valid database backup is a consistent backup. For the backup to be consistent, the database must be mounted after a consistent shutdown. No recovery is required after restoring the backup.
To make a consistent database backup:
1. Start RMAN and connect to a target database.
2. Shut down the database consistently and then mount it.
For example, enter the following commands to guarantee that the database is in a consistent state for a backup:
RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP FORCE DBA; RMAN> SHUTDOWN IMMEDIATE; RMAN> STARTUP MOUNT;
3. Run the BACKUP DATABASE command.
For example, enter the following command at the RMAN prompt to back up the database to the default backup device:
RMAN> BACKUP DATABASE;
The following variation of the command creates image copy backups of all data files in the database:
RMAN> BACKUP AS COPY DATABASE;
4. Open the database and resume normal operations. The following command opens the database:
RMAN> ALTER DATABASE OPEN;