043-138
138. You want to enforce a company's business policy on several objects by using a single policy function. Which two types of policies canbe assigned to the policy_type argument in the dbms_rls.add_po...
043-137
137. You enabled block change tracking for faster incremental backupsin your database. Which background process writes to the change tracking file?A. RBALB. CKPTC. SMOND. PMONE. MMONF. CTWRG. DBWRAnsw...
043-136
136. You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason?A. None of the SYSAUX occupants can be relocated.B. The USER...
043-135
135. ExhibitOne the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that wa...
043-134
134. Consider the following scenario: You have a directory, data, under the disk group tdgroup A. You want to create an alias for one of the data files and you execute the following command:ALTER DISK...
032-133
133. Which six files are maintained in the Flash Recovery Area? (Choose six.)A. control fileB. RMAN filesC. password fileD. parameter fileE. flashback logsF. data file copiesG. core dump filesH. archi...
043-132
132. Which background process does Automatic Shared Memory Managementuse to coordinate the sizing of memory components?A. PMONB. SMONC. MMNLD. MMANE. MMONAnswer: DThe Automatic Shared Memory Managemen...
043-131
131. Which three methods can you use to run an Automatic Database Diagnostic Monitor (ADDM) analysis over a specific time period? (Choosethree.)A. Enterprise Manager GUIB. DBMS_TRACE package APIsC. DB...
043-130
130. You enabled the flashback logging feature, but you have not specified the location of the flash recovery area.Which location would be used as the default location for the flash recovery area?A. T...
043-129
129. Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files):CREATE TABLESPACE us...
043-128
128. A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure af...
043-127
127. In your test database, you have created the ORDERS table as an index-organized table (IOT). To facilitate faster querying, you have created a mapping table and a bitmap index on the ORDER_FILLED ...
043-126
126. Your database is functioning in ARCHIVELOG mode. In which two situations would you perform. a cancel-based recovery? (Choose two)A. You find that one of the redo log members in each redo log grou...
043-126
126. Your database is functioning in ARCHIVELOG mode. In which two situations would you perform. a cancel-based recovery? (Choose two)A. You find that one of the redo log members in each redo log grou...
选择
走技术路线也是条路,坚持走下去,一定会成功的。 你不喜欢的什么?死记硬背,对,我只是不喜欢死记硬背和强迫自己而已。其实学好技术并不是要死记硬背。记着。这是我们最后的合作。要不然,...
我的计划
公司还比较够意思,让我停薪留职了3个月了。这三个月我形成了大致的方向。赚钱 - 交朋友 &...
工作5年,想换工作
转眼毕业快5年了。不喜欢自己的工作。至于为什么不喜欢。因为它没让我感觉到意义。我是干BI的。说白了就是做报表。其实BI本身不是只是做报表。奈何我是做报表的。我想要不一样的生活,有激情的生...
用户需求分析
需求分析的困难。需求可能会产生变化。用户不了解数据仓库。长期项目,无法面面俱到。采访和协调会议是两个两个收集信息的方式。采访前调查,选择采访人。确定采访问题。日程安排。采访人准备。问题解答。开放性问题...
数据仓库系统的生命周期
数据仓库构建的风险。 项目发起者 不能报告成本和收益。客户方管理人员由于不想共享信息和害怕权利而不配合。解决:更好的评估成本和收益。数据仓库构建之前发布一个讲座。让所有人心理有底。 &nbs...
多维模型
这种方式的有点在于直观。简单。用户可以不动技术的情况下进行操作。进行切,上下滚,聚合操作。 y66y让你的数据仓库逐渐进化。