巴啦啦大魔王

2017年12月5日

摘要： Which two statements are true regarding undo tablespaces? (Choose two.)A.The database can have more than one undo tablespace.B.The UNDO_TABLESPACE par 阅读全文

posted @ 2017-12-05 14:35 巴啦啦大魔王阅读(97) 评论(0) 推荐(0) 编辑

052-25

摘要： Which three operations require undo data? (Choose three.)A.committing a transactionB.flashing back a transaction – 回退操作C.recovering a failed transacti 阅读全文

posted @ 2017-12-05 14:32 巴啦啦大魔王阅读(89) 评论(0) 推荐(0) 编辑

052-24

摘要： Which two statements correctly describe the relation between a data file and the logical databasestructures? (Choose two.)A.An extent cannot spread ac 阅读全文

posted @ 2017-12-05 14:28 巴啦啦大魔王阅读(127) 评论(0) 推荐(0) 编辑

2017年12月4日

oracle 检查字符中数据类型函数&存储过程

摘要： dump函数用来判断字符串中的字符类型是属于number或者string 存储过程函数阅读全文

posted @ 2017-12-04 17:19 巴啦啦大魔王阅读(1291) 评论(0) 推荐(0) 编辑

2017年12月1日

052-22

摘要： Identify the logical structure that will never have more than one data segment created for it.A.external tableB.partitioned tableC.partitioned indexD. 阅读全文

posted @ 2017-12-01 16:44 巴啦啦大魔王阅读(107) 评论(0) 推荐(0) 编辑

052-20

摘要： You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is r 阅读全文

posted @ 2017-12-01 16:06 巴啦啦大魔王阅读(105) 评论(0) 推荐(0) 编辑

052-16&17

摘要： 16.Note the following functionalities of various background processes:1: Record the checkpoint information in data file headers.--CKPT2: Perform recov 阅读全文

posted @ 2017-12-01 14:23 巴啦啦大魔王阅读(198) 评论(0) 推荐(0) 编辑

052-15

摘要： Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)A. Shared SQL Area will be allocated in the shared poolB. Share 阅读全文

posted @ 2017-12-01 13:31 巴啦啦大魔王阅读(106) 评论(0) 推荐(0) 编辑

052-14

摘要： These are points that describe the contents of different memory components:1: Descriptive information or metadata about schema objects that are querie 阅读全文

posted @ 2017-12-01 13:13 巴啦啦大魔王阅读(140) 评论(0) 推荐(0) 编辑

052-13

摘要： You have executed this command to change the size of the database buffer cache:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582;System altered.To verify th 阅读全文

posted @ 2017-12-01 12:07 巴啦啦大魔王阅读(122) 评论(0) 推荐(0) 编辑

公告