CUUG内部OCP题库解析-052-文档11
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 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 restart.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 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 and reinserting the rows.C) performing a tablespace point in time recovery of USERS.D) Flashback Transaction Backout.E) Flashback Drop.Answer：BC74. 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 MOUNTstate.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 IMMEDIATEshutdown has been performed and the backup is taken before the database is reopened.Answer：BE75. Which four are true about consistent database backups?A) They can only be taken using O/S utilities if the database is in mountstate.B) They can only be taken using RMAN when the database is in mountstate.C) They can be taken using O/S utilities.D) They can only be taken using RMAN when the database instance isshut 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：CEFG76. Which three can be used to schedule automated backups of thedatabase?A) a cron jobB) Enterprise Manager Database ControlC) DBMS_SCHEDULERD) DBMS_BACKUP_RESTOREE) expdp F) RMANAnswer：ABC77. Which four can be used to schedule automated backups of anOracle database?A) data Guard B) DBMS_JOBC) Enterprise ManagerD) anacron jobsE) cron jobsF) Automatic Storage Management (ASM)Answer：BCDE78. 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*PLUSC) Enterprise Manager Cloud ControlD) The Database Conguration Assistant(DBCA) E) the DBMS_SCHEDULER packageAnswer：CE79. 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 takesplace. 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 FRAB) B) No archivelogs are generated.C) The archivelog entries are made in the diagnostic destination andwhen space is available, newarchivelog are generated.D) All active sessions are disconnected and their transactions rolledback. E) Obsolete backups are automatically deleted and new archivelogs aregenerated.Answer：E（验证过）80. In which two cases is a consistent database backup created ?A) when the RMAN BACKUP AS COPY command is used while thedatabase is openB) when the RMAN BACKUP command is used while the database is OPENREAD ONLYC) when the RMAN BACKUP AS COPY command is used while thedatabase is OPEN RESTRICTEDD) when the RMAN BACKUP command is used while the database is MOUN
