-
编辑 删除
043-066
66. Which two statements are correct regarding the Oracle Flashback Drop feature? (Choose two.)A. Recycle bin exists for the tables only in non-SYSTEM, locally managed tablespaces.B. You can flash...
-
编辑 删除
043-065
65. You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided, which approacwould you take to solve the problem?A. flash back the databaseB...
-
编辑 删除
043-064
64. These are the details about V$FLASHBACK_DATABASE_STAT:SQL> DESC v$FLASHBACK_DATABASE_STATName Null TypeBEGIN_TIME DATEEND_TIME DATEFLASHBACK_DATA NUMBERDB_DATA NUMBERREDO_DATA NUMBERESTIMATED_FLAS...
-
编辑 删除
043-063
63. You were recently hired by Certkiller .com as a database administrator. You are asked to find out whether the currently functional listener process, named L1, has been password protected or not. Y...
-
编辑 删除
043-062
62. When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUPcommand? (Choose four.)A. data fileB. password fileC. archivelog fileD. tempo...
-
编辑 删除
043-061
61. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the ...
-
编辑 删除
043-060
60. You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command:RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;When a backup...
-
编辑 删除
043-058
59. The warning and critical threshold values have been set to 85% and 97%, respectively, for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be ...
-
编辑 删除
043-058
59. The warning and critical threshold values have been set to 85% and 97%, respectively, for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be ...
-
编辑 删除
043-058
58. ExhibitUsing Database Control, you have scheduled a job to shrink the TRANStable residing on the TT tablespace. The job would run at 5:00 p.m. every Friday. When you examine the space usage of the...
-
编辑 删除
043-057
57. You executed the following command in Recovery Manager (RMAN):RMAN> RESTORE CONTROLFILE;Which operation must you perform. before this command is executed?A. back up the control file to traceB. bri...
-
编辑 删除
043-055
55. You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives:Consumer group SALES with CPU_P1as 60 and DEGREE_OF_PARALLELISM as 4.Consumer...
-
编辑 删除
043-055
55. You have created a resource plan, PROD_DB_PLAN, with the following consumer groups with the respective plan directives:Consumer group SALES with CPU_P1as 60 and DEGREE_OF_PARALLELISM as 4.Consumer...
-
编辑 删除
043-054
54. You find that the execution time of reports in your datawarehouseapplication is significantly high. You suspect the lack of indexes tobe the reason for the degradation in performance. Which adviso...
-
编辑 删除
043-053
53. There was media failure and you need to check the data files forany block corruption. Which option would you use to create a report on any corruptions found within the database?A. the DBNEWID ...
-
编辑 删除
043-51
51. You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze? ...
-
编辑 删除
数据仓库的进化历史
1.最开始只是在操作型数据库的基础之上建立的数据仓库。直接在操作型数据源做各种olap和报表应用。一点也没有分离。如果分析应用多的话，会给操作型数据库带来很大压力，而且也不好捕获历史信息。2.后来发展处专门的...
-
编辑 删除
操作型数据库和数据仓库的区别
操作型数据库：面对很多用户，并发事务很多。多是插入，更新操作。对数据的插入，更新性能要求更高，因此数据多是规范化的，规范化是指冗余度比较少。字段都拆开了。往往针对当前数据。数据仓库：往往面对比较少的用...
-
编辑 删除
043-050
50. You are managing an Oracle Database 10g database that uses OracleManaged Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking ...
-
编辑 删除
043-049
49. You execute the following command to enable a session in resumable mode:SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;What is the impact of a timeout on the statements being suspended?A. The stat...
