随笔分类 -  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 阅读全文
posted @ 2017-12-12 16:55 巴啦啦大魔王 阅读(191) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-12-08 11:16 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要:The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity che 阅读全文
posted @ 2017-12-01 10:13 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
摘要:A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message: Which is the recommended sequ 阅读全文
posted @ 2017-11-16 14:59 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
摘要:In Recovery Manager (RMAN), you are taking image copies of the datafiles of your productiondatabase and rolling them forward as regular intervals. You 阅读全文
posted @ 2017-11-16 14:25 巴啦啦大魔王 阅读(94) 评论(0) 推荐(0)
摘要:You want to configure the Flashback Database feature and retain flashback logs for three days.Presently the database is open and configured in ARCHIVE 阅读全文
posted @ 2017-11-16 13:35 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
摘要:The database is currently open and the temp03.dbf tempfile belonging to the default temporarytablespace TEMP has been corrupted. What steps should you 阅读全文
posted @ 2017-11-16 13:28 巴啦啦大魔王 阅读(174) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-16 13:25 巴啦啦大魔王 阅读(166) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 15:46 巴啦啦大魔王 阅读(113) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 15:44 巴啦啦大魔王 阅读(125) 评论(0) 推荐(0)
摘要:Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup 阅读全文
posted @ 2017-11-15 15:00 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-15 13:39 巴啦啦大魔王 阅读(572) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-14 18:31 巴啦啦大魔王 阅读(105) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-14 10:19 巴啦啦大魔王 阅读(74) 评论(0) 推荐(0)
摘要:Choose the correct order to package and upload data for an incident to Oracle Support.A. Schedule, create new package, view manifest, view contentsB. 阅读全文
posted @ 2017-11-13 18:12 巴啦啦大魔王 阅读(118) 评论(0) 推荐(0)
摘要:When performing a full database disaster recovery with RMAN, in what order would you executethese steps?A. Restore the control file from autobackups.B 阅读全文
posted @ 2017-11-13 10:35 巴啦啦大魔王 阅读(93) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 16:34 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:21 巴啦啦大魔王 阅读(89) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 15:07 巴啦啦大魔王 阅读(114) 评论(0) 推荐(0)
摘要: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 阅读全文
posted @ 2017-11-10 14:23 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)