摘要：
Which of the following are correct about block media recovery? (Choose all that apply.) A. Physical and logical block corruption is recorded automatic 阅读全文
posted @ 2017-11-13 18:33
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
Which of the following methods can be used to detect block corruption?A. ANALYZE operationsB. dbvC. SQL queries that access the potentially corrupt bl 阅读全文
posted @ 2017-11-13 18:27
巴啦啦大魔王
阅读(134)
评论(0)
推荐(0)
摘要：
Which of the following is not an advantage of block media recovery (BMR)?A. Reduced MTTR.B. Datafiles remain offline while corrupt blocks are repaired 阅读全文
posted @ 2017-11-13 18:20
巴啦啦大魔王
阅读(120)
评论(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)
摘要：
Which of the following tasks does the tool Incident Packaging Service (IPS) perform?A. Cleans up the ADR by deleting files not associated with an inci 阅读全文
posted @ 2017-11-13 18:08
巴啦啦大魔王
阅读(104)
评论(0)
推荐(0)
摘要：
Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)A. View long-running SQL workloadsB. View problem d 阅读全文
posted @ 2017-11-13 18:03
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要：
Which of these formats represents the correct hierarchy for the ADR?A. <diagnostic_dest>/rdbms/diag/<dbname>/<instname>B. <diagnostic_dest>/diag/rdbms 阅读全文
posted @ 2017-11-13 18:00
巴啦啦大魔王
阅读(119)
评论(0)
推荐(0)
摘要：
Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?A.The default value is the value of the environment v 阅读全文
posted @ 2017-11-13 17:54
巴啦啦大魔王
阅读(128)
评论(0)
推荐(0)
摘要：
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository? 阅读全文
posted @ 2017-11-13 17:52
巴啦啦大魔王
阅读(145)
评论(0)
推荐(0)
摘要：
To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?A. TRUNCATE the archive table.B. 阅读全文
posted @ 2017-11-13 17:46
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)A. Tablespace nameB. Storage quotaC. R 阅读全文
posted @ 2017-11-13 17:42
巴啦啦大魔王
阅读(66)
评论(0)
推荐(0)
摘要：
Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)A. SCNB. TimestampC. Named recovery pointD. Transaction 阅读全文
posted @ 2017-11-13 17:33
巴啦啦大魔王
阅读(96)
评论(0)
推荐(0)
摘要：
The _______ writes the Flashback Database logs in the flash recovery area.A. FLSHB. FLDBC. RVWRD. RVRWE. FBDA The Flashback Database architecture cons 阅读全文
posted @ 2017-11-13 17:02
巴啦啦大魔王
阅读(112)
评论(0)
推荐(0)
摘要：
Flashback Database relies on which technologies to recover to a point in time?A. Flashback Data ArchiveB. Flashback logs in the flash recovery areaC. 阅读全文
posted @ 2017-11-13 16:52
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
Which method could be utilized to identify both DML operations and the SQL statements needed toundo those operations for a specific schema owner? (Cho 阅读全文
posted @ 2017-11-13 16:47
巴啦啦大魔王
阅读(99)
评论(0)
推荐(0)
摘要：
You have just performed a FLASHBACK TABLE operation using the following command:flashback table employees to scn 123456;The employees table has trigge 阅读全文
posted @ 2017-11-13 15:56
巴啦啦大魔王
阅读(136)
评论(0)
推荐(0)
摘要：
Which of the following statements is true regarding implementing a Flashback Table recovery?A. An SCN is never used to perform a Flashback Table recov 阅读全文
posted @ 2017-11-13 15:52
巴啦啦大魔王
阅读(203)
评论(0)
推荐(0)
摘要：
Which of the following statements is true regarding the VERSIONS BETWEEN clause?A. The VERSIONS BETWEEN clause may be used in DML statements.B. The VE 阅读全文
posted @ 2017-11-13 15:43
巴啦啦大魔王
阅读(124)
评论(0)
推荐(0)
摘要：
At the request of a user, you issue the following command to restore a dropped table: flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop; 阅读全文
posted @ 2017-11-13 15:39
巴啦啦大魔王
阅读(112)
评论(0)
推荐(0)
摘要：
Which of the following can be used in conjunction with a Flashback Versions Query to filter the results?(Choose all that apply.)A. A range of SCN valu 阅读全文
posted @ 2017-11-13 15:32
巴啦啦大魔王
阅读(109)
评论(0)
推荐(0)
摘要：
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?A. XIDB. VERSIONS_PKC. VERSIONS_XIDD. VERSIONS_UNIQUE 阅读全文
posted @ 2017-11-13 15:29
巴啦啦大魔王
阅读(84)
评论(0)
推荐(0)
摘要：
Which of the following statements best describes Flashback Versions Query?A. Flashback Versions Query is used to make changes to multiple versions of 阅读全文
posted @ 2017-11-13 15:27
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
Users notify you that their application is failing every time they try to add new records. Because ofpoor application design, the actual ORA error mes 阅读全文
posted @ 2017-11-13 15:22
巴啦啦大魔王
阅读(213)
评论(0)
推荐(0)
摘要：
In order to perform Flashback Transaction Query operations, which of these steps are required?(Choose all that apply.)A. Ensure that database is runni 阅读全文
posted @ 2017-11-13 15:16
巴啦啦大魔王
阅读(115)
评论(0)
推荐(0)
摘要：
AUM has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. Yo 阅读全文
posted @ 2017-11-13 15:12
巴啦啦大魔王
阅读(78)
评论(0)
推荐(0)
摘要：
A user named Arren is executing this query:select table_name, operation, undo_sql fromflashback_transaction_query t,(select versions_xid as xidfrom em 阅读全文
posted @ 2017-11-13 15:06
巴啦啦大魔王
阅读(94)
评论(0)
推荐(0)
摘要：
Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes)on multiple rows of data in multiple tables. The m 阅读全文
posted @ 2017-11-13 15:03
巴啦啦大魔王
阅读(90)
评论(0)
推荐(0)
摘要：
Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)A. The Recycle Bin is a physical storage area for droppe 阅读全文
posted @ 2017-11-13 14:56
巴啦啦大魔王
阅读(111)
评论(0)
推荐(0)
摘要：
Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)A. Flashback QueryB. Flashback DropC. Flashback TableD. Fla 阅读全文
posted @ 2017-11-13 14:53
巴啦啦大魔王
阅读(129)
评论(0)
推荐(0)
摘要：
Which command do you use to generate a report of database incarnations?A. list incarnation of databaseB. report incarnation of databaseC. list databas 阅读全文
posted @ 2017-11-13 14:43
巴啦啦大魔王
阅读(85)
评论(0)
推荐(0)
摘要：
In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?A. The datafiles have an ONLINE status.B. The datafiles 阅读全文
posted @ 2017-11-13 14:40
巴啦啦大魔王
阅读(103)
评论(0)
推荐(0)
摘要：
Why should you back up a duplicated tablespace after a TSPITR is complete?A. The tablespace cannot be duplicated or restored to any point in time afte 阅读全文
posted @ 2017-11-13 14:35
巴啦啦大魔王
阅读(121)
评论(0)
推荐(0)
摘要：
Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?A. The SGA Tuning AdvisorB. The SQL Acce 阅读全文
posted @ 2017-11-13 14:19
巴啦啦大魔王
阅读(168)
评论(0)
推荐(0)
摘要：
When issuing the duplicate database command, you use the parameterDB_FILE_NAME_CONVERT. For what purpose do you use this parameter?A. To indicate the 阅读全文
posted @ 2017-11-13 14:13
巴啦啦大魔王
阅读(109)
评论(0)
推荐(0)
摘要：
Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object inthat tablespace has a foreign key constraint owned by 阅读全文
posted @ 2017-11-13 14:09
巴啦啦大魔王
阅读(100)
评论(0)
推荐(0)
摘要：
If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?A. TS_OBJECTS_TO_BE_DROP 阅读全文
posted @ 2017-11-13 14:01
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
Which of the following restrictions are not true with respect to tablespace point-in-time recovery?(Choose all that apply.)A. The target database must 阅读全文
posted @ 2017-11-13 13:57
巴啦啦大魔王
阅读(94)
评论(0)
推荐(0)
摘要：
When running the tablespace point-in-time commandrecover tablespace usersuntil time ,,10/06/2008:22:42:00 auxiliary destination ,,c:\oracle\auxiliary; 阅读全文
posted @ 2017-11-13 13:38
巴啦啦大魔王
阅读(133)
评论(0)
推荐(0)
摘要：
True or false: you can perform an active database duplication when the database is inNOARCHIVELOG mode.A. TrueB. False 阅读全文
posted @ 2017-11-13 13:35
巴啦啦大魔王
阅读(98)
评论(0)
推荐(0)
摘要：
导出一个表(如果有分区则每个分区)100行记录exp test/123@132.26.60.80:1521/orcl1 file=F:\dmp\tab1.dmp log=F:\dmp\tab1.log tables=(tab1) query=\"where rownum<101\" 接着是批量导出， 阅读全文
posted @ 2017-11-13 12:34
巴啦啦大魔王
阅读(206)
评论(0)
推荐(0)
摘要：
Which command would correctly start a TSPITR of the USERS tablespace?A. recover tablespace users until time '10/06/2008:22:42:00' auxiliary 'c:\oracle 阅读全文
posted @ 2017-11-13 10:47
巴啦啦大魔王
阅读(120)
评论(0)
推荐(0)
摘要：
When performing a database duplication, which duplicate database parameter would you set toensure that the online redo logs are created in the correct 阅读全文
posted @ 2017-11-13 10:39
巴啦啦大魔王
阅读(69)
评论(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)
摘要：
What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?A. TS_CHEC 阅读全文
posted @ 2017-11-13 10:32
巴啦啦大魔王
阅读(125)
评论(0)
推荐(0)
摘要：
What command is used to reset a database to a previous incarnation?A. reset incarnationB. incarnation resetC. reset database to incarnationD. reset da 阅读全文
posted @ 2017-11-13 10:27
巴啦啦大魔王
阅读(65)
评论(0)
推荐(0)
摘要：
How many database instances are used during a database-duplication process?A. OneB. TwoC. ThreeD. FourE. Five The first is be the target database,and 阅读全文
posted @ 2017-11-13 10:25
巴啦啦大魔王
阅读(92)
评论(0)
推荐(0)
摘要：
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?A. Set oracle_sid=orcl rman tar 阅读全文
posted @ 2017-11-13 10:23
巴啦啦大魔王
阅读(83)
评论(0)
推荐(0)
摘要：
When youre performing active database duplication, a backup of what kind is required?A. A current RMAN backup-set backup is required.B. No backup is r 阅读全文
posted @ 2017-11-13 10:17
巴啦啦大魔王
阅读(96)
评论(0)
推荐(0)
摘要：
Which command is used to begin a tablespace point-in-time recovery?A. Restore tablespaceB. Recover tablespaceC. Tablespace recoverD. Recover to timeE. 阅读全文
posted @ 2017-11-13 10:14
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
摘要：
True or false: tablespace point-in-time recovery is possible only with RMAN.A. TrueB. False Tablespace point-in-time recovery has been done in Oracle 阅读全文
posted @ 2017-11-13 10:11
巴啦啦大魔王
阅读(108)
评论(0)
推荐(0)
浙公网安备 33010602011771号