CUUG内部OCP题库解析-052-文档11
25页1、CUUG内部OCP题库解析-052-文档11题库新特点:oracle 11g版本的ocp认证考试题库,来自cuug整理,考试题大部分都在这里能找到,如果想考ocp认证可以参考这些文档。下面的题是(052考试-第11个文档)里的一些考题。其他题找相关文档,或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档11 7/17/19十.Initialization parameter70. which is true about initialization parameter administration?A) Some Dynamic parameter values can be modied to affect only onesessionB) Dynamic parameters, when modied, always revert to their originalvalues after the database instance is restartedC) Static parameter values can be
2、changed in the sple only by using the alter system command with scope=sple when the database is closedD) Static parameter values can be changed for the current instance by using alter system command with scope=memoryAnswer:A(验证过)71. You want to use the ALTER SYSTEM statement with SCOPE=MEMORYto change an initialization parameter value.Which is true?A) It can be used only if a ple is used.B) The change occurs immediately in memory for static parameters but it isnot persistent afterinstance restar
3、t.C) The change occurs immediate in memory for dynamic parameters but it isnot persistent afterinstance restart.D) In can be used only if an sple is used.Answer:C72. which three statements are true about initialization parameters and les? A) An idle instance must start with a PFILE.B) Session modiable initialization parameters can only be changed by a user with the DBA role.C) The ALTER SYSTEM command can be used to change parametervalues for an instance startedusing a PFILE.D) An SPFILE can be
4、created from an idle instance.E) Session modiable initialization parameters can only be changed onceper session.F) The ALTER SYSTEM command can be used to change parametervalues for an instance startedusing an SPFILEG) System modiable initialization parameters can only be changed by the SYS user.Answer:DFG十一.Backup73. Table EMP resides in the USERS tablespace. Examine this command:SQL DROP TABLE emp PURGE;Which two methods would you use to recover EMP? A) Flashback Table.B) re-creating the table
《CUUG内部OCP题库解析-052-文档11》由会员j***分享,可在线阅读,更多相关《CUUG内部OCP题库解析-052-文档11》请在金锄头文库上搜索。
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页