随笔分类 -  ocp-parameter

1 2 3 下一页
053-28
摘要：You have a range-partitioned table in your database. Each partition in the table contains thesales data for a quarter. The partition related to the cu 阅读全文
posted @ 2018-01-05 18:20 巴啦啦大魔王 阅读(124) 评论(0) 推荐(0)
052-166
摘要：View the Exhibit and examine the setting for a table. Which statement is true about the PCTFREE setting for the table?A.It sets the minimum percentage 阅读全文
posted @ 2017-12-14 18:11 巴啦啦大魔王 阅读(110) 评论(0) 推荐(0)
052-162
摘要：You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile.Some user sessions are currently connected 阅读全文
posted @ 2017-12-14 17:56 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
052-161
摘要：In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for thes 阅读全文
posted @ 2017-12-14 17:53 巴啦啦大魔王 阅读(130) 评论(0) 推荐(0)
052-153
摘要：The database instance has the following parameter setting:OS_AUTHENT_PREFIX = OPS$OS_ROLES = FALSEREMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSETIME 阅读全文
posted @ 2017-12-14 14:40 巴啦啦大魔王 阅读(180) 评论(0) 推荐(0)
052-147
摘要：View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block s 阅读全文
posted @ 2017-12-14 13:47 巴啦啦大魔王 阅读(157) 评论(0) 推荐(0)
052-125
摘要：You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location 阅读全文
posted @ 2017-12-12 17:26 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-124
摘要：You executed the following commands to find the location of the alert log file:SQL> SHOW PARAMETER BACKGROUND_DUMP_DESTNAME TYPE VALUE background_dump 阅读全文
posted @ 2017-12-12 17:15 巴啦啦大魔王 阅读(131) 评论(0) 推荐(0)
052-117
摘要：View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not autom 阅读全文
posted @ 2017-12-12 15:49 巴啦啦大魔王 阅读(149) 评论(0) 推荐(0)
052-116
摘要：Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initializatio 阅读全文
posted @ 2017-12-12 15:41 巴啦啦大魔王 阅读(125) 评论(0) 推荐(0)
052-64
摘要：Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)A.The MTTR advisor wi 阅读全文
posted @ 2017-12-07 18:14 巴啦啦大魔王 阅读(92) 评论(0) 推荐(0)
052-63
摘要：Examine the values for the following initialization parameters:FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0Which two will be the implications 阅读全文
posted @ 2017-12-07 18:08 巴啦啦大魔王 阅读(88) 评论(0) 推荐(0)
052-51
摘要：In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the syst 阅读全文
posted @ 2017-12-07 14:18 巴啦啦大魔王 阅读(181) 评论(0) 推荐(0)
052-34
摘要：A user, who is authenticated externally, logs in to a remote machine and connects to the databaseinstance. What action would you take to ensure that a 阅读全文
posted @ 2017-12-05 15:16 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-33
摘要：Some non-DBA users in your database have been granted ANY TABLE system privileges and theyare able to access data dictionary base tables. You decide t 阅读全文
posted @ 2017-12-05 15:12 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
053-102
摘要：Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/ 阅读全文
posted @ 2017-11-16 17:06 巴啦啦大魔王 阅读(98) 评论(0) 推荐(0)
053-208
摘要：You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level? 阅读全文
posted @ 2017-11-16 17:00 巴啦啦大魔王 阅读(99) 评论(0) 推荐(0)
053-211
摘要：You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable 阅读全文
posted @ 2017-11-16 16:59 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0)
053-275
摘要：You have enabled resumable space allocation in your database by setting theRESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements a 阅读全文
posted @ 2017-11-16 16:31 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0)
053-204
摘要：You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when youperform tape backups. Which action should you take?A. Set th 阅读全文
posted @ 2017-11-16 16:20 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)

1 2 3 下一页