搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;<br /> Which action should you perform immediately after using this command?（）

A、You should perform a log switch

B、You should make a backup of the database

C、You should switch the database to the NONARCHIVELOG mode

D、You should shut down the database instance and perform a complete database recovery

查看正确答案
更多“ The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;<br /> Which action should you perform immediately after using this command?（）”相关的问题
第1题
[多选题] You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

A、The source database backup must be copied over the net for test database.  B、The source database must be run in ARCHIVELOG mode if the database is open.  C、The source database must be shut down cleanly if the database is in mounted state.  D、A net service name should be set up and a listener configured with the target as well as the source database.  

点击查看答案
第2题
[单选题] Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: Which statement is true about the duplicate database in this scenario?（）

A、It contains data till the last backup  B、It contains all data from target database until the current time  C、It contains all data from only the committed transactions in the target database  D、It contains all data except that which is used by the transactions in the current online redo file of target database  

点击查看答案
第3题
[单选题] The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL > CONNECT scott/tiger@orcl What could be the reason for this?（）

A、The listener is not running on the database node.  B、The TNS_ADMIN environment variable is set to the wrong value.  C、The orcl.oracle.com database service is not registered with the listener.  D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.  E、The listener is running on a different port.  

点击查看答案
第4题
[单选题] Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.  B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.  C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.  D、If you restart the database, the database will not be opened.  

点击查看答案
第5题
[单选题] Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A、The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.  B、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.  C、If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.  D、If you restart the database, the database will not be opened.  

点击查看答案
第6题
[] Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（） Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option wo

A、A. Restore the latest whole backup, perform complete recovery, and open the database normally  B、B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.  C、C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.  D、D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.  

点击查看答案
第7题
[单选题] The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）

A、Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles  B、Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS  C、Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile  D、Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.  

点击查看答案
第8题
[多选题] Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; \ } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)

A、The data files of the read-only tablespaces in the target database are not duplicated  B、The read-only tablespaces in the target database are still defined in new the database  C、The read-only tablespaces in the target database are changed to online after duplication  D、The data files of the read-only tablespaces in the target database get duplicated  E、The read-only tablespaces in the target database are not defined in the new database  

点击查看答案
第9题
[] The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?（）

A、A. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles  B、B. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS  C、C. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile  D、D. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.  

点击查看答案
第10题
[多选题] A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）

A、Disabling connections from named pipes or socket files (depending on the operating system of the server)  B、Enabling and using SSL for connections to the Mysql database  C、Installing Mysql on the application server, and running the database and application on the same server  D、Starting the server with – bind- address=0.0.0.0 specified  E、Running the server with – skip-networking specified  F、Limiting logins to originate from the application server or the server's subnet'  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服