随笔分类 - ocp操作排序类
摘要:You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occur when a database instance is started and database
阅读全文
摘要:You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Fla
阅读全文
摘要:The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity che
阅读全文
摘要:A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message: Which is the recommended sequ
阅读全文
摘要:In Recovery Manager (RMAN), you are taking image copies of the datafiles of your productiondatabase and rolling them forward as regular intervals. You
阅读全文
摘要:You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVE
阅读全文
摘要:The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you
阅读全文
摘要:You are using Recovery Manager (RMAN) with a recovery catalog to back up your productiondatabase. The backups and the archived redo log files are copi
阅读全文
摘要:You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that
阅读全文
摘要:While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options t
阅读全文
摘要:Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup
阅读全文
摘要:Your company wants to upgrade the production database to a Real Application Clusters (RAC)environment. You set up the best RAC database and want to re
阅读全文
摘要:NLS parameters can be set using the five methods listed. Put the methods in order from highest tolowest according to Oracles order of precedence:A. De
阅读全文
摘要:To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?A. EM Database home page, Software and Supp
阅读全文
摘要:Choose the correct order to package and upload data for an incident to Oracle Support.A. Schedule, create new package, view manifest, view contentsB.
阅读全文
摘要:When performing a full database disaster recovery with RMAN, in what order would you executethese steps?A. Restore the control file from autobackups.B
阅读全文
摘要:David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the contr
阅读全文
摘要:What is the correct order of the following commands if you wanted to restore datafile 4, which wasaccidentally removed from the file system?A. sql 'al
阅读全文
摘要:You need to restore your database back to 9/30/2008 at 18:00. In what order would you run thefollowing commands to compete this task?A. restore contro
阅读全文
摘要:Given a complete loss of your database, in what order would you need to perform the followingRMAN operations to restore it?A. restore controlfileB. re
阅读全文
浙公网安备 33010602011771号