半夏泻心汤的君药是（）

A. set Flash Recovery Area

B. enable Flashback logging

C. create FLASHBACK tablespace

D. start the database in the ARCHIVELOG mode

E. start the database in the NOARCHIVELOG mode

A. The database must have multiplexed redo logs for the flashback to succeed.

B. The database must be MOUNTED for the flashback to succeed.

C. The database must use block change tracking for the flashback to succeed.

D. The database must be opened in restricted mode for the flashback to succeed.

E. The database must be opened with the RESETLOGS option after the flashback is complete.

F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema？（）

A. Only 1

B. Only 2

C. Only 3

D. 3 and 1

E. 1 and 2

A. The database must have multiplexed redo log files

B. The database must be in the MOUNT state to execute the command

C. The database must be in the NOMOUNT state to execute the command

D. The database must be opened in RESTRICTED mode before this operation

E. The database must be opened with the RESETLOGS option after the flashback operation

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command？（）

A. Restore the backup control file and open the database with RESETLOGS option.

B. Perform point-in-time recovery because flashback cannot be performed again on this table

C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

A. Flashback logs are written sequentially, and are archived.

B. Flashback Database uses a restored control file to recover a database.

C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.

D. Flashback Database can recover a database to the state that it was in before a reset logs operation.

E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F. Flashback logs are used to restore to the blocks‘ before images, and then the redo data may be used to roll forward to the desired flashback time.

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table.Before executing the FLASHBACK TABLE command, thesystem change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that thetable is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command？（）

A. Restore the backup control file and open the database with RESETLOGS option.

B. Perform point-in-time recovery because flashback cannot be performed again on this table

C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571

D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

However, the existing SQL server computers in your office are configured to use the

SQL_Latin1_General_CP1_CI_AS collation.

You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

What should you do？

A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.

The data must be available at all times. Interruptions in data connectivity should not last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers.

How should you configure the database？

A．Configure the database on the two servers as a SQL Server 2000 cluster.

B．Configure the database on one server, and then configure a standby database on the second server.

C．Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized.

D．Configure the database as a federated database, and then partition half the data on each server.

A. Enable supplemental logging for the database.

B. Specify undo retention guarantee for the database

C. Create Flashback Data Archive in the tablespace where the tables are stored.

D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables