-
You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?（） (Choose two).
A . The backup as copy can only be taken to disk
B . The backup as copy can only be taken to tape
C . Backup can be performed only when the instance is shutdown
D . Backup will constitute all used and unused blocks in the database
-
Most of the Windows 2000 Professional clients on your network use the TCP/IP Protocol to communicate with Server. You want to increase network performance. Where do you change the binding order of your protocols？ （）
A . On the Windows 2000 Server， set TCP/IP for the Server service at the top.
B . On the Windows 2000 Professional computers， set TCP/IP for the Workstation service at the top.
C . On the Windows 2000 Server， set TCP/IP for the Workstation service at the top.
D . On the Windows 2000 Professional computers， set TCP/IP for the Server service at the top.
-
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?（）
A . The backup as copy can only be taken to disk
B . The backup as copy can only be taken to tape
C . Backup can be performed only when the instance is shutdown
D . Backup will constitute all used and unused blocks in the database
-
You are tuning RMAN to optimize performance.You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?（）
A . Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B . Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C . Use compression when performing tape backups
D . Configure multiple SBT channel
-
You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
A . create baseline metrics for today’s performance
B . write the current database metrics to a database table and create a trigger to compare with future database statistics
C . write the current database metrics to a flat file and create an operating script to compare with future database statistics
D . write the current database metrics to a database table and create a procedure to compare with future database statistics
E . write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistic
-
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）
A . control file
B . password file
C . listener controller file
D . control file and password file
-
You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）
A . CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；
B . CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；
C . CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；
D . CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；
-
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this？（）
A . Set the UNDO_RETENTION parameter to AUTO.
B . Create an initial undo segment in undotablespace.
C . Set the UNDO_RETENTION parameter to 900 or more
D . Set the initialization parameter UNDO_MANAGEMENT to AUTO
E . Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
-
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）
A . Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B . Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C . Use compression when performing tape backups
D . Configure multiple SBT channel
-
You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）
A . Every SQL statement in the STS is considered only once for execution.
B . The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
C . The execution plan and execution statistics are computed for each SQL statement in the STS.
D . The effects of DDL and DML are considered to produce the execution plan and execution statistics.
-
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
A . backup of offline tablespaces
B . backup of readonly tablespaces
C . backup of systemcritical tablespaces
D . backup of online， locally managed tablespaces
E . backup of read/write dictionarymanaged tablespace
-
You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）
A . NOCHECKSUM
B . MAXCORRUPT
C . CHECK LOGICAL
D . BACKUP INCREMENTAL
E . CONFIGURE DEVICE TYPE ... PARALLELISM
-
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.
-
You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes. Which action will you perform to check the data blocks？（）
A . Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
B . Use the ANALYZE utility.
C . Use the DBVERIFY utility.
D . Use the DBMS_REPAIR package.
-
You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）
A . Only the SET command must be within a RUN block.
B . All commands should be executed at the RMAN prompt.
C . All three commands must be within a single RUN block.
D . Only the RESTORE and RECOVER commands must be within a single RUN block.
-
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
A . Backup of offline tablespaces.
B . Backup of read-only tablespaces.
C . Backup of system-critical tablespaces.
D . Backup of online， locally managed tablespaces.
E . Backup of read/write dictionary-managed tablespaces.
-
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？（）
A . Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.
B . Just back up the database datafiles without shutting down the database.
C . You will have to wait until you can shut down the database to perform the backup.
D . Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.
E . Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backu
-
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started？（）
A . Creating the parse tree of the statement
B . Writing the modified data blocks to the data files
C . Writing the modified data to the archived redo log files
D . Updating the control file to indicate the most recent checkpoint
E . Updating the data file header to indicate the most recent checkpoint
F . Reading the blocks to database buffer cache if they are not already there
-
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）
A . The backup as copy can only be taken to disk
B . The backup as copy can only be taken to tape
C . Backup can be performed only when the instance is shutdown
D . Backup will constitute all used and unused blocks in the database
-
You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation？（）
A . You must enable the row movement on the SCOTT.EMP table.
B . You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
C . You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
D . You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
-
You want to perform the following operations for the DATA ASM disk group:
https://assets.asklib.com/images/image2/2018080211341517506.jpg
Which command accomplishes these tasks?（）
A . ALTER DISKGROUP data CHECK;
B . ALTER DISKGROUP data CHECK DISK;
C . ALTER DISKGROUP data CHECK FILE;
D . ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1
-
You want to use Windows 2000 backup to perform a weekly backup of the user data on a Windows 2000 Professional computer. You want to ensure that the registry， boot files and COM plus objects are also backed up. What should you do？（）
A . Configure the Windows backup to backup the system partition.
B . Configure the Windows backup to backup the System State Data.
C . Create a script written in MS Visual Basic scripting addition language to run rdisk.exe/s before the back up starts.
D . Create a batch file to run rdisk.exe/s before the backup starts.
-
You are preparing the supporting network infrastructure for the upgrade to Exchange Server 2003. You want to accomplish this upgrade by using the minimum amount of administrative effort.Which two actions should you perform？（）
A . Run the setup.exe /domainprep command on a domain controller in the prod.testking.com domain
B . Run the setup.exe /domainprep command on a domain controller in the app.testking.com domain
C . Run the setup-exe /domainprep command on a domain controller in the testking.com domain
D . Log on to the domain by using a user account that is a member of the Domain Admins group
E . Log on to the domain by using a user account that is a member of the Schema Admins grou
-
If you want to appreciate the highest level of theatrical performances in English speaking world, you can go to_______.
-
You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode.The following steps must be performed in the correct sequence to do this:Choose the correct sequence.（）
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17133996/81fcc055aa2594a8ac7bbd62b7b620ac.jpg' />
A. 4, 1, 3, 2, 5
B. 4, 3, 1, 2, 5
C. 2, 4, 3, 5, 1
D. 4, 2, 5, 3, 1
