OCP最新考试题库解析之052考试原题-11-20180817

052题库解析,最新题库 052-题库解析-11-20180817,052 题库解析,CUUG真诚奉献,题库新特点：, 最新052题库，按知识点分门别类，方便大家学习 每周五晚8点-直播地址：ke.qq.com/course/326223 ocp考试讨论群：836361015 验证：ocp CUUG整理，官网：www.cuug.com,十.Initialization parameter 70. which is true about initialization parameter administration?,A) Some Dynamic parameter values can be modied to affect only one session B) Dynamic parameters, when modied, always revert to their original values after the database instance is restarted C) Static parameter values can be changed in the sple only by using the alter system command with scope=sple when the database is closed D) Static parameter values can be changed for the current instance by using alter system command with scope=memory,Answer：A（验证过）,71. You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to 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 is not persistent after,instance restart.,C) The change occurs immediate in memory for dynamic parameters but it is not persistent after instance restart. D) In can be used only if an sple is used.,Answer：C,72. 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 parameter values for an instance started,using a PFILE.,D) An SPFILE can be created from an idle instance. E) Session modiable initialization parameters can only be changed once per session. F) The ALTER SYSTEM command can be used to change parameter values for an instance started,using an SPFILE,G) System modiable initialization parameters can only be changed by the SYS user.,Answer：DFG,十一.Backup,73. 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 and reinserting the rows. C) performing a tablespace point in time recovery of USERS. D) Flashback Transaction Backout.,E) Flashback Drop.,Answer：BC,74. Which two are true about consistent database backups? A) They can only be taken by using RMAN commands. B) They can only be taken by using RMAN when the database is in MOUNT state. C) They can only be taken when a RECOVERY CATALOG is used. D) They can only be taken if the database is in ARCHIVELOG mode. E) They can only be taken if a NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.,Answer：BE,75. Which four are true about consistent database backups? A) They can only be taken using O/S utilities if the database is in mount state. B) They can only be taken using RMAN when the database is in mount state. C) They can be taken using O/S utilities. D) They can only be taken using RMAN when the database instance is shut down.,E) They can be taken if the database is in archivelog mode. F) They can be taken by using rman commands. G) They can be taken if the database is in noarchivelog mode.,Answer：CEFG,76. Which three can be used to schedule automated backups of the database? A) a cron job B) Enterprise Manager Database Control C) DBMS_SCHEDULER D) DBMS_BACKUP_RESTORE E) expdp,F) RMAN,Answer：ABC,77. Which four can be used to schedule automated backups of an Oracle database? A) data Guard B) DBMS_JOB C) Enterprise Manager D) anacron jobs E) cron jobs,F) Automatic Storage Management (ASM),Answer：BCDE,78. Which two tools or utilities can be used to congure and schedule on- line database backups to run automatically? A) the RMAN command line utility B) SQL*PLUS C) Enterprise Manager Cloud Control,D) The Database Conguration Assistant(DBCA) E) the DBMS_SCHEDULER package,Answer：CE,79. Your database is open in ARCHIVELOG mode. LOG_ARCHIVE_DEST is set to Fast Recovery Area (FRA) and it is 100% full when a log switch takes place. No alternative or optional archive destinations are dened. What is the outcome?,A) All active sessions hang until the database administrator (DBA) makes space available in the FRA B) B) No archivelogs are generated. C) The archivelog entries are made in the diagnostic destination and when space is available, new archivelog are generated. D) All active sessions are disconnected and their transactions rolled back. E) Obsolete backups are automatically deleted and new archivelogs are generated.,Answer：E（验证过）,80. In which two cases is a consistent database backup created ? A) when the RMAN BACKUP AS COPY command is used while the database is open B) when the RMAN BACKUP command is used while the database is OPEN READ ONLY C) when the RMAN BACKUP AS COPY command is used while the database is OPEN RESTRICTED D) when the RMAN BACKUP command is used while the database is MOUNTED,E) when O/S commands are used to copy database les after a database instance is shut down normally,Answer：DE,81