随笔分类 -  ocp-其他

1 2 3 4 5 ··· 7 下一页
051-48
摘要：Which two statements are true regarding indexes? (Choose two.)A. They can be created on tables and clusters.B. They can be created on tables and simpl 阅读全文
posted @ 2018-01-02 16:27 巴啦啦大魔王 阅读(144) 评论(0) 推荐(0)
053-11
摘要：View the Exhibit to examine the metrics with a threshold. Which statement is true regarding the Number of Transactions (per second) metric? A. Oracle 阅读全文
posted @ 2017-12-20 16:54 巴啦啦大魔王 阅读(112) 评论(0) 推荐(0)
053-9
摘要：Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?A. It returns space usage of only Basic 阅读全文
posted @ 2017-12-18 18:25 巴啦啦大魔王 阅读(150) 评论(0) 推荐(0)
053-8
摘要：Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?A. It cannot be done in parallel. B. It c 阅读全文
posted @ 2017-12-18 18:09 巴啦啦大魔王 阅读(143) 评论(0) 推荐(0)
053-1
摘要：1.While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new S 阅读全文
posted @ 2017-12-18 17:04 巴啦啦大魔王 阅读(129) 评论(0) 推荐(0)
052-188
摘要：You receive complaints from users regarding the high waiting time for their transactions. On investigation, you find that some users are not committin 阅读全文
posted @ 2017-12-15 14:51 巴啦啦大魔王 阅读(159) 评论(0) 推荐(0)
052-187
摘要：Which two statements describe good practices for an application developer to reduce locking conflicts in Oracle database? (Choose two.)A.Avoid coding 阅读全文
posted @ 2017-12-15 14:48 巴啦啦大魔王 阅读(107) 评论(0) 推荐(0)
052-186
摘要：User A executes the following command to drop a large table in your database:SQL> DROP TABLE trans;While the drop table operation is in progress, user 阅读全文
posted @ 2017-12-15 14:41 巴啦啦大魔王 阅读(134) 评论(0) 推荐(0)
052-185
摘要：User SCOTT executes the following command on the EMP table but has not issued COMMIT,ROLLBACK, or any data definition language (DDL) command:SQL> SELE 阅读全文
posted @ 2017-12-15 14:38 巴啦啦大魔王 阅读(138) 评论(0) 推荐(0)
052-184
摘要：You suspect unauthorized data manipulation language (DML) operations on a particular table. Youwant to track users who are performing the transactions 阅读全文
posted @ 2017-12-15 14:31 巴啦啦大魔王 阅读(108) 评论(0) 推荐(0)
052-183
摘要：The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on theprocedure to many database users:CREATE OR REPLACE PROCE 阅读全文
posted @ 2017-12-15 14:26 巴啦啦大魔王 阅读(155) 评论(0) 推荐(0)
052-182
摘要：Which two statements are true regarding a PL/SQL package body? (Choose two.)A.It cannot be created without a package specification.B.It cannot invoke 阅读全文
posted @ 2017-12-15 13:54 巴啦啦大魔王 阅读(101) 评论(0) 推荐(0)
052-180
摘要：User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and f 阅读全文
posted @ 2017-12-15 13:46 巴啦啦大魔王 阅读(161) 评论(0) 推荐(0)
052-177
摘要：Which three statements are correct about temporary tables? (Choose three.)A.Indexes and views can be created on temporary tables.B.Both the data and t 阅读全文
posted @ 2017-12-15 11:28 巴啦啦大魔王 阅读(123) 评论(0) 推荐(0)
052-176
摘要：You executed this command to create a temporary table:SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20 阅读全文
posted @ 2017-12-15 11:24 巴啦啦大魔王 阅读(103) 评论(0) 推荐(0)
052-175
摘要：What can you achieve by implementing reverse key index?A.Reverse the bytes of each column indexed including the row ID.B.Store a bitmap for each key v 阅读全文
posted @ 2017-12-15 11:21 巴啦啦大魔王 阅读(140) 评论(0) 推荐(0)
052-174
摘要：Which two statements are true regarding B-tree index? (Choose two.)A.The leaf blocks in the index are doubly linked.B.The leaf node stores a bitmap fo 阅读全文
posted @ 2017-12-15 11:13 巴啦啦大魔王 阅读(127) 评论(0) 推荐(0)
052-173
摘要：Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?A.An update in a leaf row takes pl 阅读全文
posted @ 2017-12-15 11:10 巴啦啦大魔王 阅读(145) 评论(0) 推荐(0)
052-172
摘要：The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table:ERROR at line 1:ORA-00060: deadlock detected 阅读全文
posted @ 2017-12-15 11:05 巴啦啦大魔王 阅读(188) 评论(0) 推荐(0)
052-171
摘要：View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. 阅读全文
posted @ 2017-12-15 10:49 巴啦啦大魔王 阅读(182) 评论(0) 推荐(0)

1 2 3 4 5 ··· 7 下一页