首页/ 题库 / [单选题]

Your database is的答案

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one
redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?()

单选题
2022-01-04 17:35
A、ALTER DATABASE DROP LOGFILE GROUP 1;
B、ALTER DATABASE CLEAR LOGFILE GROUP 1;
C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D、ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG
查看答案

正确答案
C

试题解析

标签: 1Z0-053
感兴趣题目
What is true about Unicast RPF in strict mode?()

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? ()(Choose two.)

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch?()

Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()  
The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?()
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?()

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.
Examine the following command and its output:
You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
Which data files will be backed up?()

Given the following RMAN commands,choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.()  
a. restore database 
b. recover database 
c. shutdown immediate 
d. startup 
e. restore archivelog all
f. alter database open 

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?()
You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN. Examine the following command and its output: You execute the following command: RMAN > BACKUP DATABASE PLUS ARCHIVELOG; Which data files will be backed up?()
Which mode of database shutdown requires an instance recovery at the time of the next database startup?()
相关题目
Client/server database system is no longer in use now.

I wonder if there is _____ university in your hometown.

You plan to execute the following command to perform a Flashback Database operation in your database:
SQL> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE -5/24);
Which two statements are true about this?()

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?()

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?()

One of your customers has deployed a Layer 3 gateway in the untrusted network. Which gateway mode is appropriate for this customer?()

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is jetting filled up very fast and it is running out of space. Your database flash recovery area is low on space and you have no more room on disk.
Proactively, which two options could you use to make more space available in the flash recovery?()

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.
Which statement about performing user-managed backups in a 24x7 environment is true?()

In your database, the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impact of this setting?()
In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
How much is the percent of air transportation in all modes? ()

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one
redo member. When you attempt to start the database, you receive the following errors:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'
You discover that the online redo log file of the current redo group is corrupted.
Which statement should you use to resolve this issue?()

You are maintaining your database in ARCHIVELOG mode. An important table, SCOTT.EMPLOYEE, is dropped and purged from the Recycle Bin on Monday at 2:00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9:00 P.M. on Sunday.  How will you recover the dropped table, SCOTT.EMPLOYEE?()
Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?()  

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?()

While working in setup mode, a configuration line is typed incorrectly. What should you do to exit setup mode, without executing or saving any of the mistakes you made?()

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of 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;
Which action should you perform immediately after using this command?()

Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:

Which statement should you use to resolve this issue?()

The FEC mode is for()from()station to two or more other stations when available.
广告位招租WX:84302438

免费的网站请分享给朋友吧