CUUG内部OCP题库解析-053-文档7
22页1、CUUG内部OCP题库解析-053-文档7题库新特点:oracle 11g版本的ocp 053认证考试是所有这几科里数量最多的考试了,cuug整理了近期的053考题,并进行了讲解。下面的题是(053考试-第7个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档2 7/17/1966.Which two initialization parameters would you set to enableAutomatic Shared Memory Management? (Choose two.)A. set SHARED_POOL_SIZE to zero B. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALLAnswer: CE67.On which
2、 two database objects can the VERSIONS clause of theFlashback Versions Query be used? (Choose two.)A. fixed tables B. heap tablesC. external tables D. temporary tablesE. Index-Organized Tables (IOTs) Answer: BE68.You have three temporary tablespace groups named G1, G2, and G3 inyour database. You are creating a new temporary tablespace as follows:CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE/u1/data/temp1.dbf SIZE 10M TABLESPACE GROUP ;Which statement regarding the above command is correct?A. It wi
3、ll create the tablespace TEMP1 in group G1.B. It will create the tablespace TEMP1 in group G3.C. It will not add the tablespace TEMP1 to any group.D. It will create the tablespace TEMP1 in the default group.Answer: C69.The EMP table exists in your schema. You want to execute thefollowing query: SELECT ename, salFROM empAS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL 6 MINUTE)WHERE ename = ALLEN;What are the minimum requirements for the statement to executesuccessfully? (Choose all that apply)A.ARCHIVEL
4、OG mode must be enabledB.Row Movement must be enabled for the tableC.FLASHBACK must be set to ON for the databaseD.The UNDO_MANAGEMENT parameter must be set to AUTOE.The UNDO_RETENTION parameter must be set appropriatelyAnswer: DE70.You executed the following SQL statement to shrink the EMPLOYEEStable segment stored in the EXAMPLE tablespace:ALTER TABLE employees SHRINK SPACE CASCADE;Which statement is correct in this scenario?A. The EMPLOYEES table will be changed to read-only mode during thesh
《CUUG内部OCP题库解析-053-文档7》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-053-文档7》请在金锄头文库上搜索。
CUUG内部OCP题库解析-052-文档2
CUUG内部OCP题库解析-053-文档2
CUUG内部OCP题库解析-052-文档12
CUUG内部OCP题库解析-052-文档10
CUUG内部OCP题库解析-052-文档11
CUUG内部OCP题库解析-053-文档6
CUUG内部OCP题库解析-052-文档9
CUUG内部OCP题库解析-071-文档5
CUUG内部OCP题库解析-071-文档2
CUUG内部OCP题库解析-052-文档4
CUUG内部OCP题库解析-071-文档4
CUUG内部OCP题库解析-052-文档8
CUUG内部OCP题库解析-052-文档5
CUUG内部OCP题库解析-071-文档1
CUUG内部OCP题库解析-053-文档4
CUUG内部OCP题库解析-053-文档7
CUUG内部OCP题库解析-071-文档6
CUUG内部OCP题库解析-071-文档3
CUUG内部OCP题库解析-052-文档6
CUUG内部OCP题库解析-053-文档5
2023-06-30 7页
2022-09-15 93页
2022-06-04 27页
2022-04-25 3页
2022-03-24 7页
2022-03-24 7页
2022-03-24 8页
2022-03-24 4页
2022-03-24 43页
2022-03-24 7页