ocp 1Z0053 最近题库.docx

1、ocp 1Z0053 最近题库681. The environmental variable ORACLE-BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). View the Exhibit and note the various parameters set in your database. What will be the location of the ADR base?A. It is set to ORA

2、CLE-BASE.B. It is set to ORACLE_HOME/log.C. It is set to /u01/app/oracle/admin/orcl/adump.D. It is set to /u01/app/oracle/flash_recovery_area.682. Identify the scenarios in which the RMAN CROSSCHECR command is useful. (Choose all that apply.)A. To check that the obsolete backups are deleted from the

3、 repository records and from the disk.B. To update the RMAN repository if you delete archived redo logs with operating system commands.C. To update outdated information about backups that disappeared from disk or tape or became corrupted and inaccessible.D. To synchronize the actual files on disk or

4、 in the media management catalog with the RMAN repository for which the backup was not taken using RMAN.683. Your production database it functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the pro

5、duction database to anther host , SHOST2, for testing new applications.After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?A. Restoring the control file from the backup by using the NOCA

6、TALOG option to restore, and recovering the data filesB. Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the locationC. Restoring the server parameter file from the backup by using the recovery catalog to restore, and recovering the data filesD. Res

7、toring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.684. 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 i

8、mportant 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 miss

9、ing tables successfully.A. Restore the backup of all the data files.B. Restore the backup of all the data files and the control file.C. Restore the backup of only the data files that contain the dropped tables.D. Restore the backup of all the data files belonging to the tablespace containing the dro

10、pped tables.685. In your test database:-You are using Recovery Manager (RMAN) to perform incremental backups of your test database-The test database is running in NOARCHIVELOG mode-One of the data files is corrupted-All online redo log files are lost because of a media failureWhich option must you c

11、onsider in this scenario?A. Configuring the database in ARCHVIELOG mode and then using incremental backup to recover the databaseB. Using incremental backup to recover the damaged data file and then manually creating the online redo log filesC. Creating a new test database because the database is no

12、t recoverable due to the fact that the database is configured in NOARCHIVELOG modeD. Using incremental backups to recover the database by using the RECOVER DATABASE NOREDO command and then using the RESETLOGS option to open the database. 686. You execute the following FLASHBACK TABLE command:Which t

13、wo statements are correct?(Choose two.)A. The EMP table that was dropped by mistake earlier is restored.B. The FLASHBACK TABLE statement is executed as a single transaction.C. The FLASHBACK TABLE statement does not maintain existing indexes on the EMP table.D. The changes made to the EMP table since

14、 the specified time are undone if no constraint is violated during flashback. 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 sale after the shrink operation?A. Because the table did not contain migrated or chaine

15、d rowsB. Because the row IDs remain the same for all rows during the shrink operationC. Because the progress of the shrink operation is not saved in the bitmap blocks of the tableD. Because the high-water mark (HWM) did not move due to the COMPACT option that is used in the shrink operation687. User

16、s are connected to a database instance that is using Automatic Storage Management (ASM). The DBA executes the command as follows to shut down the ASM instance:SQL SHUTDOWN IMMEDIATE;What happens to the database instance?A. It shuts down long with the ASM instance.B. It is aborted and the ASM instanc

17、e shuts down normally.C. It stays open and SHUTDOWN command for the ASM instance fails. D. It shuts down only after all pending transactions are completed and the ASM instance waits for this before shutting down.688. Which two statements are true about the compressed backups in RMAN? (Choose two.)A.

18、 Compressed backups can only be taken on the tape drives.B. The binary compression creates some performance overhead during backup operation.C. The ZLIB compression algorithm can be used only if the COMPATIBLE initialization parameter is set to 11.1.0.D. The media manager compression for the tape dr

19、ive should be enabled for taking compressed backups on the tape. 689. View the Exhibit and examine the RMAN commands.Which statement describes the effect of a backup retention policy on the backup of a backup set?A. Either all the copies of a backup set are obsolete or none of them are as per the re

20、tention policy.B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.C. The copies of the backup will be reported as obsolete under a recovery window-based backup retention policy.D. All the copies of the backup set are counted as one instance of a

21、 backup and will deleted in backup set exceeds the redundancy-based backup retention policy.690. The database users regularly complain about the difficulty in performing transactions. On investigation, you find that some users perform long-running transactions that consume huge amounts of space in t

22、he undo tablespace, which caused the problem. You want to control the usage of the undo tablespace only for these user sessions and you do not want these sessions to perform long-running operations. How would you achieve this?A. Implement a profile for the users.B. Implement external roles for the u

23、sers.C. Set the threshold for the undo tablespace.D. Implement a Database Resource Manager plan.691. You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache contains the ideal workload for analysis. You want to analyze only a few

24、most resource-intensive statements.What must you do to receive recommendations on efficient use of indexes and materialized views to improve query performance?A. Run the SQL Access Advisor.B. Run the SQ; Tuning Advisor (STA).C. Run the Automatic Workload Repository (AWR) report.D. Run the Automatic

25、Database Diagnostic Monitor (ADDM).692. Your company wants to upgrade the production database to a Real Application Clusters (RAC) environment. You set up the best RAC database and want to replay a recorded workload captured from the production database on the test machine.The following steps may be

26、 used to replay the database workload:1) Preprocess the captured workload2) Restart the database in RESTRICTED mode.3) Set up Replay Clients.4) Restore the test database to the point when the capture started.5) Remap connections.Which is the correct sequence of the required steps?A. 1, 4, 3, 5B. 1,

27、4, 5, 3C. 2, 1, 5, 3, 4D. 1, 2, 4, 5, 3693. Which two statements are true about an image copy backup? (Choose two.)A. It may only be taken to disk.B. It will contain only the used blocks.C. It will contain all used and unused blocks.D. It can be performed on disk as well as on tape. 694. As part of

28、archiving the historical data, you want to transfer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online. The source and target databases use the same compatibility level and character sets. View the Exhibit and exam

29、ine the features in the source and target database.Which of the following steps are required to transport a tablespace from the database to the target database:1. Make the tablespace read-only at the source database.2. Export metadata from the source database.3. Convert data filed by using Recovery

30、Manager (RMAN).4. Transfer the dump file and data filed to the target machine.5. Import metadata at the target database.6. Make the tablespace read/write at the target database.A. 2, 4, and 5B. All the stepsC. 2, 3, 4 and 5D. 1, 2, 4, 5 and 6695. Identify two options that Oracle recommends while con

31、figuring the backup and recovery environment for your recovery catalog. (Choose two.)A. configuring control fileautobackup to be ONB. backing up data filed only and not the archived redo log filesC. running the recovery catalog database in NOARCHIVELOG mode.D. setting the retention policy to a REDUN

32、DANCY value greater than 1E. backing up the recovery catalog to the same disk as that of the target database696. Examine the following command for RMAN backup:Which statement Is true regarding the approach in the command?A. The RMAN multiplexing level is 4.B. It is the use of asynchronous I/O by RMAN.C. It is a case of parallelization of the backup set.D. It is an implementation of a multisection backup.697. Which statement is true about