ocp-052考试题库

Vendor: 1z0-052

Exam Code: Oracle Database 11g: Administration I

分卷: A（共73题）

1、You perform differential incremental level 1 backups of your database on each working day and level 0

backup on Sundays, to tape. Which two statements are true about differential incremental backups? (Choose

two.) A D

A. The backup performed on Sundays contains all the blocks that have ever been used in the

database.

backup.

2、

View the Exhibit to examine the output produced by the following query at three different times

since the database

instance started and has experienced workloads of different capacities:

SQL> SELECT substr(component, 0, 10) COMP, current_size CS,user_specified_size US

FROM v$memory_dynamic_components

WHERE current_size!=0;

What do you infer from this? C

A. The database instance is running with manual PGA management.

B. The database instance is running with manual shared memory management.

A. The database files are corrupted when the database is open.

B. The user has dropped an important table that needs to be recovered.

C. The archived redo log files are missing for which the backup is not available.

D. The database is not opening because the required database files are missing.

4、You have two tables with referential integrity enforced between them. You need to insert

data to the child table first because it is going to be a long transaction and data for the parent

table will be available in a later stage, which can be inserted as part of the same

transaction.View the Exhibit to examine the commands used to create tables.Which action

would you take to delay the referential integrity checking until the end of the transaction? A

A. Set the constraint to deferred before starting the transaction.

B. Alter the constraint to NOVALIDATE state before starting the transaction.

C. Enable the resumable mode for the session before starting the transaction.

D. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction.

5、Your database is open and the LISTENER listener is running. The new DBA of the system stop

the listener by using the command:

6

SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class

CHAR(20)) ON COMMIT PRESERVE ROWS;

Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction? A

7、Examine this command:

B. Rows will be lost upon session failure.

C. Rows are visible to all sessions logged in by the same user until the session that inserted the

rows terminates.

D. Rows are visible to all sessions logged in by all users granted the DBA role until the session that

inserted the rows terminates.

E. Rows will be lost upon session normal termination.

F. Rows are visible globally to all sessions logged in by any user until the session that inserted the

rows terminates.

8、In which of the scenarios will the DBA perform recovery? (Choose all that apply.) BE

9、 Note the following structures in your database server:

1. Extents

2. OS Blocks

3. Tablespace

4. Segments

5. Oracle Data Block

Which option has the correct arrangement of these structures from the smallest to the largest? A

3、Execute the ALTER DATABASE FLASHBACK OFF command.

4、Start up the instance and mount the database.

5、Execute the ALTER DATABASE FLASHBACK ON command.

6、Open the database.

Select the correct order in which these tasks need to be performed. A

A. 2, 1, 4, 3, 5, 6

B. 1, 4, 3, 2, 6, 5

C. 1, 4, 2, 6, 3, 5

D. 3, 2, 1, 4, 5, 6

D. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.

12、 Your database instance is started using the server parameter file (SPFILE). You executed a

command to change the value of the LOG_BUFFER initialization parameter:

ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;

What would be the outcome of this command? C

A. The command succeeds only if Automatic Memory Management is not enabled.

B. The command succeeds, but you need to restart the database for changes to take effect.

C. The command returns an error because the size of the redo log buffer cannot be changed

dynamically.

1、Shut down the instance, if not already done.

2、Copy one of the remaining control files to a new location.

3、Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the

control files.

4、Start up the database instance to the NOMOUNT stage.

5、Recover the database to the point of failure of the control file.

6、Open the database.

Identify the correct sequence of steps?