A．at timesB．at one timeC．for a timeD．at a time

A. The database must be opened in restricted mode.

B. The database must be configured to run in ARCHIVELOG mode.

C. The tablespaces are required to be in backup mode before taking the backup.

D. The tablespaces are required to be in read-only mode before taking the backup

, a big filetablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each.Which method would accomplish the task quickly and efficiently？（）

A. parallel image copy backup

B. backup with MAXPIECESIZE configured for the channel

C. parallel backup with MAXPIECESIZE configured for the channel

D. intrafile parallel backup

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.

of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command:RMAN> BACKUPSECTION SIZE 300M TABLESPACE users;Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）

A. The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.

B. The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.

C. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.

D. The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1

You？work？in？a？company？which？is？named？Wiikigo？Corp.？The？company？uses？SQL？Server？2008.？You？are？the？administrator？of？the？company？database.？Now？you？are？in？charge？of？a？SQL？Server？2008？instance.？There？is？a？database？named？DB1？in？the？instance.？In？the？database,？a？small？percentage？of？data？is？modified？everyday.？Ever？day？in？the？morning,？you？have？to？create？a？read-only？copy？of？the？database？for？reporting？purposes？and？make？sure？that？you？use？as？little？disk？space？as？possible.

In？the？options？below,？which？strategy？should？you？use？（）？？

A. You？should？use？database？snapshots？

B. You？should？use？database？backup？and？restore？

C. You？should？use？database？backup？and？restore？along？with？compression？

D. You？should？use？schema-bound？views？in？a？read-only？database.？The？database？resides？on？the？same instance.

mation from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

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.

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

A. Reregistering the target database in recovery catalog

B. Transporting the new tablespaces to the recovery catalog database

C. Syncronizing the recovery catalog with the target database control file

D. Performing a fresh backup of the target database to include the new data files in the catalog database

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature？（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING