-
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
A . The database is in mount state.
B . One of the tablespaces is offline.
C . One of the tablespaces is read only.
D . The database operates in ARCHIEVELOG mode.
E . The database operates in NOARCHIEVELOG mode.
-
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
-
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 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.
-
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?（）
A . Compare Period ADDM report
B . AWR Compare Period report
C . Active Session History (ASH) report
D . Taking a new snapshot and comparing it with a preserved snapshot
-
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
-
Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）
A . The database is in mount state.
B . One of the tablespaces is offline.
C . One of the tablespaces is read only.
D . The database operates in ARCHIEVELOG mode.
E . The database operates in NOARCHIEVELOG mode.
-
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
-
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 want to perform a backup of your database to tape. Which backup format can you use？（）
A . backup set only
B . image copy only
C . only user-managed backup
D . both image copy and backup set
E . only incremental image copy backu
-
You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）
A . Hot backup
B . Online backup
C . consistent backup
D . incremental backup
E . inconsistent backu
-
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 work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？ （）
A . Hot backup
B . Online backup
C . consistent backup
D . incremental backup
E . inconsistent backu
-
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 are in the world, when you walk in to our hotel we want you to have best lodgin
A．A.Wherever
B．B.Whoever
C．C.Whatever
D．D.Whenever
-
If you want to eat Chinese food, you will go to the restaurant in（）
A．Fairview Hotel
B．First Hotel
C．Orchard Hotel
D．Osaka Hotel
-
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
