1Z0-053 Free Practice Test

- (Topic 2)
How is block-change tracking enabled?

1. A. With alter database enable block change tracking
2. B. With alter system enable block change tracking
3. C. With an init.ora parameter change
4. D. With an spfile parameter change

Correct Answer: A

- (Topic 13)
View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?
Exhibit:

1. A. The text alert log file will be available in Diag Trace
2. B. A copy alert log file will be kept in Diag Incident for every incident.
3. C. The XML version of the alert log file will be available in Diag Trace.
4. D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.

Correct Answer: A

C:\Users\albo\Desktop\1-1.jpg
alert, The XML-formatted alert log cdump, Core files
incident, Multiple subdirectories, where each subdirectory is named for a particular incident, and where each contains dumps pertaining only to that incident
trace, Background and server process trace files, SQL trace files, and the text-formatted alert log
(others), Other subdirectories of ADR home, which store incident packages, health monitor reports, and other information

- (Topic 5)
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?

1. A. Database Datafiles
2. B. Database Control Files
3. C. Online redo logs
4. D. Archived redo logs
5. E. The database SPFILE
6. F. None of the above, all these files are backed up.

Correct Answer: C

- (Topic 13)
Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

1. A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
2. B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
3. C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
4. D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

Correct Answer: BD
You can run SQL Repair Advisor through the EM Support Workbench when an incident raised.
Or You run the SQL Repair Advisor by creating and executing a diagnostic task using the DBMS_SQLDIAG. CREATE_DIAGNOSIS_TASK and DBMS_SQLDIAG. respectively. The SQL Repair Advisor first reproduces the critical error and then tries to produce a workaround in the form of SQL patch.

- (Topic 14)
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory management features?

1. A. Automatic PGA Memory Management
2. B. Automatic SGA Memory Management
3. C. Automatic Shared Memory Management
4. D. Automatic Memory Management
5. E. Manual SGA Memory Management
6. F. None of the above

Correct Answer: D