1z0-043
单选题You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMAN>BACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to s
题目
Start the database in the MOUNT stage.
Back up the control file to trace.
Set the DBID
Issue the RECOVER DATABASE command.
参考答案和解析
相似问题和答案
第1题：
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）
- A、 by using the RMAN utility
- B、 by using the export/import utility
- C、 by using the ALTER DATABASE command
- D、 by enabling the change tracking feature
正确答案:C
第2题：
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）
- A、 SQL Tuning Advisor
- B、 Undo Advisor
- C、 ADDM
- D、 Memory Advisor
正确答案:D
第3题：
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）
A. They execute and create a virtual catalog for pre-Oracle 11g clients.
B. They produce an error because PROD1 and PROD2 databases belong to the older version.
C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
D. They produce an error because you need to connect to the target database to execute this packaged procedure.
第4题：
You are maintaining subscriptions in an Oracle database. Which property of that subscription allowsyou to update it?（）
- A、Phase
- B、Status
- C、Source Type
- D、Rule Function
- E、Customization Level
正确答案:E
第5题：
You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting？（）
- A、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.
- B、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.
- C、 The SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.
- D、 The SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
正确答案:A
第6题：
You are working as a DBA at NetFx Corporation. You discover that the SCOTT schema is deleted by mistake. You decide to flash the database back to the time when the schema existed. Which view will you query to determine the estimated size of the flashback data that you require for your current target retention？（）
- A、 V$FLASHBACK_DATABASE_LOG
- B、 V$FLASHBACK_DATABASE_STAT
- C、 V$DATABASE
- D、 V$UNDOSTAT
正确答案:A
第7题：
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）
- A、 V$DATABASE
- B、 V$FLASHBACK_DATABASE_STAT
- C、 V$FLASHBACK_DATABASE_LOG
- D、 V$RECOVERY_FILE_DEST
正确答案:B
第8题：
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）
- A、 control file
- B、 all datafiles
- C、 password file
- D、 online redo log file
- E、 archive redo log file
- F、 server parameter file
- G、 only the SYSTEM datafile
正确答案:A,B,F
第9题：
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）
- A、 0
- B、 1
- C、 NONE
- D、 DEFAULT
正确答案:A
第10题：
You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
- A、 redo log files
- B、 password file
- C、 control file
- D、 change tracking file
正确答案:D