最新的Oracle 1z1-034免費考試真題

問題1

memory_target big integer 808M
pga_aggregate_target big integer 0
sga_target big integer 0
SQL> SHOW PARAMETER SGA_MAX_SIZE
NAME TYPE VALUE
sga_max_size big integer 808M
Which statement is correct about the database?

A. SGA_TARGET are set.

B. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set.

C. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and

D. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set.

E. Automatic memory management is enabled and, as per the policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup.

正確答案: E

問題2

The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?

A. Password file

B. Archived log files required to perform recovery

C. Newly created tablespace which is not backed up

D. Inactive online redo log file

E. Control files

正確答案: B,E

說明：（僅 Fast2test 成員可見）

問題3

Examine the following RMAN script:
RMAN> run {
debug on;
allocate channel c1 type disk;
backup datafile 5;
}
Which statement describes the purpose of the script?

A. The data file is checked for physical corruption and backed up if found clean.

B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

C. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

D. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

正確答案: C

問題4

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.
What would you suggest to analyze this performance problem for the user?

A. Active Session History report

B. SQL Tuning Advisor

C. SQL Performance Analyzer

D. AWR Compare Periods report

正確答案: A

問題5

Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

A. flashback query

B. all DDL statements having bind variables

C. logging in and logging out of sessions

D. direct path load of data from external files

E. distributed transactions

正確答案: B,C

問題6

Your database is running in ARCHIVELOG mode. You have been taking backups of all the data files and control files regularly.
You are informed that some important tables in the BILLING tablespace have been dropped on February 28, 2007 at 10.30 AM and must be recovered.
You decide to perform an incomplete recovery using the following command:
SQL> RECOVER DATABASE UNTIL TIME '2007-02-28:10:15:00';
Identify the files that must be restored to recover the missing tables successfully.

A. Restore the backup of all the data files belonging to the tablespace containing the dropped tables.

B. Restore the backup of all the data files and the control file.

C. Restore the backup of all the data files.

D. Restore the backup of only the data files that contain the dropped tables.

正確答案: C

問題7

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

A. Each nested plan gets a proportion of the CPU resources assigned to its parent group.

B. The plans can be nested up to four levels.

C. Nested plans control only the degree of parallelism and I/O requests

D. Nested plans only control resources used by recursive SQL

E. Only one nested subplan is allowed per parent plan

正確答案: A

問題8

Given below are RMAN commands to enable backup optimization and set the retention policy:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday. Viewthe Exhibit to examine the operations performed by using RMAN. Which two statements are true about the backup of the USERS tablespace? (Choose two.)

A. It will be backed up as a part of database backup on Tuesday.

B. It will not be backed up as a part of database backup on Wednesday.

C. It will be backed up as a part of database backup on Friday.

D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

正確答案: A,D

說明：（僅 Fast2test 成員可見）

最新的Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z1-034免費考試真題

聯系我們

站內鏈接

最新更新