随笔分类 -  ocp-command

上一页 1 2
052-38
摘要：To make audit information more productive, the DBA executes the following command before starting an audit operation:SQL> ALTER SYSTEM SET AUDIT_TRAIL 阅读全文
posted @ 2017-12-05 16:39 巴啦啦大魔王 阅读(80) 评论(0) 推荐(0)
052-37
摘要：You execute the following command to audit database activities:SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of 阅读全文
posted @ 2017-12-05 16:30 巴啦啦大魔王 阅读(96) 评论(0) 推荐(0)
053-504&213
摘要：View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you exec 阅读全文
posted @ 2017-11-16 14:52 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
053-271
摘要：Examine the output of the query that you executed to list the objects in the recycle bin : You verified that no table named SALES_TAB exists in the sc 阅读全文
posted @ 2017-11-16 14:12 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
053-212
摘要：Note the following parameters settings in your database:SGA_MAX_SIZE = 1024M SGA_TARGET = 700MDB_8K_CACHE_SIZE = 124MLOG_BUFFER = 200MYou issued the f 阅读全文
posted @ 2017-11-16 14:05 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
053-669
摘要：User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash b 阅读全文
posted @ 2017-11-16 13:48 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
053-623
摘要：You issued the following commands to configure setting in RMAN;RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sb 阅读全文
posted @ 2017-11-15 17:16 巴啦啦大魔王 阅读(162) 评论(0) 推荐(0)
053-96
摘要：Examine the following command:SQL> ALTER TABLE booking SHRINK SPACE COMPACT;Which activity is performed when the preceding command is executed?A. The 阅读全文
posted @ 2017-11-15 15:22 巴啦啦大魔王 阅读(144) 评论(0) 推荐(0)
053-706
摘要：You execute the following command to set the redundancy retention policy in Recovery Manager(RMAN):RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;Id 阅读全文
posted @ 2017-11-15 14:09 巴啦啦大魔王 阅读(102) 评论(0) 推荐(0)
053-701
摘要：A user receives the following error while performing a large volume of inserts into a table: The issue is resolved by increasing the space quota on th 阅读全文
posted @ 2017-11-15 13:55 巴啦啦大魔王 阅读(157) 评论(0) 推荐(0)
053-687
摘要：Users are connected to a database instance that is using Automatic Storage Management (ASM).The DBA executes the command as follows to shut down the A 阅读全文
posted @ 2017-11-15 13:26 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0)
053-372
摘要：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 巴啦啦大魔王 阅读(84) 评论(0) 推荐(0)
053-540
摘要：Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?A. ADD DIRECTORYB. DROP DISKC. RESI 阅读全文
posted @ 2017-11-08 13:31 巴啦啦大魔王 阅读(193) 评论(0) 推荐(0)
053-539
摘要：How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it hasalready completed?A. Issue the ALTER DISKGROUP ... ADD DISK comma 阅读全文
posted @ 2017-11-08 13:24 巴啦啦大魔王 阅读(135) 评论(0) 推荐(0)
053-534
摘要：How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?A. Issue the ALTER DISKGROUP ... ADD DISK comm 阅读全文
posted @ 2017-11-07 17:26 巴啦啦大魔王 阅读(116) 评论(0) 推荐(0)

上一页 1 2