摘要：
2014年11月20日,星期四 更新1. 示例1declare/* type card_rec_type is record ( dn_no channel.dn_no%type, channel_id channel.channel_id%type); type nested_card_type is table of card_rec_type; card... 阅读全文
摘要：
511.You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance: LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATOR... 阅读全文
摘要：
70.You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in... 阅读全文
摘要：
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 BasicFile LOB chunks. B. It returns space... 阅读全文
摘要：
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 can be done at the table level or partiti... 阅读全文
摘要：
3.Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA... 阅读全文
摘要：
6.You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog s... 阅读全文
摘要：
5.Examine the section of the Health Check report given below: DBMS_HM.GET_RUN_REPORT('HM_RUN_1061') Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode : R... 阅读全文
摘要：
4.Which three components does the Scheduler use for managing tasks within the Oracle environment? (Choose three.) A. a job B. a program C. a schedule D. a PL/SQL procedure A... 阅读全文
摘要：
2.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideratio... 阅读全文