Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP (1z1-034) Free Practice Test

Question 1

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. SQL Tuning Advisor

B. Active Session History report

C. SQL Performance Analyzer

D. AWR Compare Periods report

Correct Answer: B

Question 2

You are working on a database that was created using Oracle Database 10g, the default tablespace type property was not changed. You execute the following statement to create a tablespace, mytbs: CREATE TABLESAPCE mythbs DATAFILE '/u1/data/mytbs.dbf' SIZE 100M; Which two statements are correct regarding the mytbs tablespace? (Choose two)

A. It is a smallfile tablespace.

B. It is a bigfile tablespace (BFT).

C. It is a dictionary-managed tablespace.

D. It is a locally managed tablespace.

E. It is a default bigfile tablespace.

Correct Answer: A,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which perquisite must be met before accomplishing the backup?

A. Provide a password for the encryption.

B. No setup is required as it is a default encryption method.

C. Set up an Oracle wallet for the encryption.

D. Both Oracle wallet and password must be set up for the encryption.

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

You executed the following command In Recovery Manager {RMAN):
RMAN>REPORTNEEDBACKUPdays 3;
What is the output of this command?

A. a list of files that require a backup within three days

B. a list of files requiring more than 3 days of archive logs to apply

C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

D. a list of files for which a backup has already been performed in the last three days and which is required tobe backed up again based on the high number of transactions performed on them

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

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 only the data files that contain the dropped tables.

C. Restore the backup of all the data files.

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

Correct Answer: C

Question 6

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MMDD. The default format of which two data types would be affected by this setting?

A. TIMESTAMP WITH LOCAL TIME ZONE

B. INTERVAL YEAR TO MONTH

C. TIMESTAMP

D. INTERVAL DAY TO SECOND

E. DATE

Correct Answer: A,C

Question 7

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?

A. Backup can be performed only when the instance is shutdown

B. The backup as copy can only be taken to tape

C. The backup as copy can only be taken to disk

D. Backup will constitute all used and unused blocks in the database

Correct Answer: C,D

Question 8

SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS
704
SQL> ALTER TABLE altb SHRINK SPACE COMPACT;
Table altered.
SQL> SELECT blocks FROM user_segments WHERE segment_name=*ALTB*;
BLOCKS
704
View the Exhibit and examine the output and commands executed on the ALTB table.
Why does the number of blocks for the table remain the same after the shrink operation?

A. because the table did not contain migrated or chained rows

B. because the row IDs remain the same for all rows during the shrink operation

C. because the high-water mark (HWM) did not move due to the compact option that is used in the shrink operation

D. because the progress of the shrink operation is not saved in the bitmap blocks of the table

Correct Answer: C

Question 9

Which two statements are true about a job chain? (Choose two.)

A. The jobs in a job chain cannot have more than one dependency.

B. A job chain can contain a nested chain of jobs.

C. The jobs in a job chain can be executed only by using the events generated by the Scheduler

D. A job of the CHAIN type can be run using event-based or time-based schedules.

Correct Answer: B,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP (1z1-034) Free Practice Test