OCP-2019年3月1Z0-053最新50道题OCP,2019年3月刚考，80%通过，oracle

文件名称: OCP-2019年3月1Z0-053最新50道题

所属分类: Oracle

开发工具:

文件大小: 440kb

下载次数: 0

上传时间: 2019-03-17

提供者: bornt******

下载 (440kb)

不能下载？报告错误

详细说明：OCP,2019年3月刚考，80%通过，oracle_11g_053最新50道题，c Configure the flash recovery area and set the LoG ARCHIVE MIN SUCCEED DEST parameter to 2 D) Set the OPTIONAL attribute for LOG ARCHIVE DEST n for the four destinations and set LOG ARCHIVE MIN SUCCEED DEST to 2. E)Set LOG ARCHIVE DEST and LOG ARCHIVE DUPLEX DEST to two chosen destinations and set LoG ARCHivE MIN SUCCEED DESt to null mandatory和 optiona mandatαry指定了填满的在线日志文件在可重用前必须成功归档到目的地, optiona指定在线日志文件可重用前,成功的归档到目的圯不是必须要求的。默认的是∞ optional log_ archive min succeed dest=n参数指定了在日志写进程覆盖在线日志文件前要保证至少n个目的地归档了日志。例如下面的 lag_ archive_ min succeed dest=2表明在覆盖在线日志文件之前至少有2个目的地一定要归档 8.One of your databases is in archive log mo de and registered in an rman catalog Which two can affect the RMAN recovery window? A)configuring backup optimization B)the frequency of catalog resynchronization C) using the fast reco very area D) using backup redundancy---它会覆盖恢复窗口的设置 E the value of control file record keep time 配置快速恢复区时,需要定义区域空间大小,也就是必须配置参数 DB RECOVERY FILE DEST SIZE。这个参数值确定了快速恢复区能使用的存储空间上限。如果定义了备份保留策璐, oracle会棖据策略判断哪些文件过期( absolete)进而删除,但只有在定义了备份保留策略时,αrace才会自动判断和删除。当快速恢复区空间使用率达到90%时,会触发自动删除。删除过程会在 alert文件中记录日志,但是如果没有空问可以释放,并且使用空间超过85%,就会记录一个 warning日志如果超过了97%,会记录一条 critical warning日志,这些日志内容可以从dba_ outstanding_alerts视图中看到。 9. You want to convert an existing database backup into an archival backup that will always be exempt from the RMan retention policy Which two conditions should be met for the backup to be converted successfully? A) It should be registered in a recovery catalog.-恢复目录少不了 B) The RESTORE PoINT clause should be used C) It should not reside in the fast reco very area--空间有限制 D The REstoRE PoinT clause should not be used E)It should reside in the fast recovery area F) It should not be registered in a reco very catalog 关键词: be exempt from免于 10.Which two are true about components of Oracle Resource Manager? A) A resource manager plan directive can restrict sessions in the same consumer。指令是共用 B)A resource manager plan directive specifes how resources should be allo cated amongst session in the same consumer group C) A resouce manager plan directive can specify resource allo cation rules for multiple consumer groups. 1 个 resouce管理器计划指令可以为多个消费者组揞定资源分配规则。 D) a resource plan contains directives that specify how resource should be allo cated amongst resource consumer groups.--不是如何在使用组中分配,而是总体分配 E)A resource consumer group can be managed differently in different resource manager plans 关键词: directive指令, resource consumer group使用组, amongst在.…之间,在……中 https://blogcsdn.net/dbafanming/article/details/6585296 RDMB根据当前活动资源计划中的一系列资源计划指令为资源使用组分配资源。资源计划和指令间有着一对多的关系,资源计划中不能包含两条相同的揞令。 11. One of your databases has resumable space allocation enabled Which four conditions will suspend a session performing DML in that database instance Such that they can resume later rather than throw an error? A) A query can not build a read consistent image of a block updated by a transaction that is already committed B)A transaction causes a tablespace to run out of space and autoextend is not enabled C)A transaction causes a table segment to reach maximum extents which is set to 750 D)A query can not build a read consistent image of a block updated by a transaction that is not yet committed E) Total undo space for a session exceeds the resource manager limit o F)A transaction causes an index segment to reach maximum extents which is set to 1000 G)A transaction reaches the session users tablespace space quota 关键词: suspend挂起,暂停 12. Which two are true about the creation, configuration, and use of an RMAN recovery catalog? A)The recovery catalog schema must be stored in a tablespace containing no other schemas )RESYNC CATALOG must be executed after registering each target database C) REGISTER DAT ABASE must be executed separately for each target database D) The recovery catalog database must be in ARCHIVELOG mode E)It cannot be created in any of the target databases. F) The recovery catalog owner must have the CREaTE SESSION privilege and the RECOVERY CATALOG OWNER role 关键词: separately单独的,分离的 of space. Which two could make space available in the flash recovery area?ow running out 13. You configured the fast recovery area for one of your databases but it is A) Reduce the RMan retention policy window or day count--太晚,不直接 B) Change the rman archived log deletion policy--太晚,不直接 C) Use OS commands to remove files from the fast reco very area D) Use the RMAN CROSSCHECK command to reclaim the archived log space 关键词: reclaim收回 14. A database is running In ARCHIVELOG mode You took a binary backup of the control fle Which two statements are true about reco very using the backup control file? A)You can perform only an incomplete reco very with a backup control file even If all the on line redo lo gs and archived lo gs are available B) You can only restore the control fle to its original lo cation.-须用户指定的 C) You can only restore the control file to the default lo cation.--须用户指定的 D) You must always RECOVER the database after restoring a backup control fle, even if no data fles have been resto red--先还原控制文件,再恢复数据库 E)You must open the database RESETLOGS after recovery using a backup control file 15. Which two statements are true about compressed backups in RMAN? A)The compression algorithm is auto matically selected by RMAN B)Media manager compression should be enabled when backing up to tape C) Compressed backups can only be written if using a media manager D) Binary compression adds some performance overhead when taking backups 16. Which initialization parameter(s)must be defned in the Oracle ASM instance parameter fle? A)only the ASM_DISKGROUPS parameter B)only the ASM_DISKSTRING parameter C) only the INSTANCE_TYPE parameter D the ASM DISKGROUP and ASM DISKsTRING parameters E)the INSTANCE_TYPE and the ASM_DISKGROUPS parameters 17. Examine these rman commands RMAN> CO NFIGURE DEFAULT DEVICE TYPE To disk RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;-备份成镜像副本 RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON Your database uses an spfile You issued this command: RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT Which three actions will occur? a) backup only of SPFILE content that has changed since the last backup B) backup of the entire SPFILE C) backup of archived lo gs D) backup of online lo gs E)backup of all used blocks only in all data files F) backup of all used and unused blocks in all data files--copy的文件(控制和数据)必须包含所有文件对数据库中所有数据文件和控制文件的以前的图像副本进行备份。通常由备份数据库包含的所有数据文件都将具有副本:如果没有,RMAN会发出错误。所有副本都不是由单个备份命令产生的。如果一个数据文件存在多个副本,那么 RMAN将备份最新的数据文件。 18. In which two situations must you open a database with resetloGs? A)after recovering from the loss of an aCTIVE redo log group B)after bringing a recovered user tablespace online C) after recovering from the loss of a cURRENT redo lo g group--和日志相关系 D) after performing a database point-in-time reco very和日志相关系 E) after recovering from the loss of a server parameter file 19. Identify two scenarios in which the RMAN CROSSCHECK command is useful A)To synchronize the actual fles on disk or in the media management catalog with the RMAN repository for which the backup was not taken using RMAN B)To update the RMAN repository if you delete archived redo logs with operation system commands C) To check that the o bolete backups are deleted from the repository records and from the disk。检查不出来。 D) To update outdated information about backups that disappeared from disk or tape or became corrupted inaccessible 〔 ROSSCHECK命令用户核对备份文件,以确保RMA资料庠与备份文件保持同步。当执行该命令时,如果RMAN资料戽记录的状态与实际备份文件不匹配,则会更新资料库里的状态使其与实际备份文件状态致:若备份文件处于 expired状态,那么说明该备份已失效,可以删除之; 关键词: actual真实的,现有的, outdated过期的 20. View the Exhibit to observe the error ORACLE Enterprise Manager 11g He bs P Database Control D时t&b围e PaLatine I laren otels LoModB A wYS ()Database Error ORA 03I urabe o ae 303 byt ot s aod momory(harod pocr "sELECT aaovnor Mme, a t taga ORA-04031: unable to allocat e 3936 byt es of share memery l share pool", SELECT advisor_name, las_', 'sga heap(1, 0)', kgism object bat ch, You receive the error regularly and have to shut down the database instance to overcome the error: Automatic Shared Memory Management is configured for the instance hat can you do to reduce the change of this error in the future? A)Set the PRE PAGE SGA parameter to true B)Lock the System Global Area(SGA)in memory C) Increase the value of SGA MAX SIZE D) Enable automatic memory management--共享内存的前提:自动内存必须开启 21. Which two are true about configuring the fast recovery area? A) DB RECOVERY FILE DEST must be set in order to use the LASHBACK DATABASE command必须设置恢复文件目录,以便使用 FLASHBACK数据库命令 B)USE_DB_RECOVERY_FILE_ DEST must be explicitly set to LOG_ARCHIVE_DEST_10. C) DB_FLASHBACK_RETENTION_TARGET must be set if defining a retention policy D) DB RECOVERY FILE DEST SIZE must be Set if DB RECOVERY FILE DEST is set E)Archive log destinations must be specified using LOG_ ARCHIVE_ DEST_ n parameters 22. Which three are true about the recycle bin in Oracle 11 g? a) Objects in the recycle bin are stored In the TEMp tablespace of the schema owner B) Objects in the recycle bin are stored in the same tablespace as they wore before they were dropped.回收站中的物品被储存在与它们被丢弃之前相同的表空间中。 C) More than one table originally called HR. EMPLOYEES may reside in the recycle bin D) a dropped table may always be flashed back from the recycle bin E)A dropped index may be flashed back from the recycle bin F) Spare occupied by objects in the recycle bin count against the quota of the schema owner 关键词spae多余的 23. Which three statements are true about Automatic Storage Management(ASM)in Grid infrastructure 1 1g R2? A)ASM load balances Disk Group content across a maximum of eight ASM disks in that Disk Group. B)ASM load balances Disk Group content across all ASM disks In that Disk Group C) ASM mirrors at the allo cation unit(au) level for Disk Groups with Normal Redundancy D) ASM lo ad balancing is optional when External Redundancy is set for a Disk Group E)An ASM file is always mirrored based on the redundancy attribute of the Disk Group containing that file F) ASM mirrors at the allocation unit(AU)level for Disk Groups with High Redundancy 24. How can an Oracle stored procedure be executed auto matically every Monday next month using Oracle Scheduler? A)Configure the stored procedure to be run in a scheduler program and specify the program in a scheduler job with the correct schedule parameters B)Configure the stored procedure to be run In a scheduler job and configure a scheduler pro gram and job In a scheduler schedule with the correct scheduler parameters C) Configure the stored procedure to be run in a scheduler schedule with the correc schedule parameters and then call the schedule In a scheduler program D) Confgure the stored procedure to be run In a scheduler pro gram and specify the schedule, program In a schedule, schedule with the correct schedule parameters E)Configure the stored procedure to be run in a scheduler schedule with the correct schedule parameters and specify the schedule In a scheduler Job 25. Your database is running in ARCHIVELOG mode. One of the data files, USERDATAO 1DBF, in the USERS tablespace is damaged and you need to recover the file until the point of failure The backup for the data file is available Which three files would be used in the user-managed recovery process performed by the database administrator(DBA)? A) the latest backup of only the damaged data file--只恢复单个数据库文件 B)the latest backup of all the data files In the USERS tablespace C) control file D) temporary fles of temporary tablespace E)redo lo gs 26. Examine the following scenario Database is running in ARCHIVELOG mode Complete consistent backup is taken every Sunday. On Tuesday the instance terminates abnormally because the disk on which control tles are located gets corrupted.--控制文件奔溃 The online redo lo g fles are available The hardware is repaired and the paths for control files are still valid. Which option would you use to perform the recovery of database till the po int of failure? A)Restore the latest whole backup, perform recovery using the UNTIL CANCEL o ption, and open the database with the RESETLOGS option B)Restore the latest backups control file, perform complete recovery, and open the database normally C) Restore the latest who le database backup, perform complete recovery, and open the database normally D)Restore the latest backup control fle, perform complete reco very using backup control file and open the database with the RESetloGs option 27. How can a dBa control a job's resource utilization using Oracle Job Scheduler? a) by using a job class to asso ciate the job with a resource consumer group that is managed by the current resource manager plan B) by using a window to associate the job with a resource consumer group that is managed by the current resource manager plan 通过使用窗口将工作与由当前资源管理器计划管理的资源消费者组相关联 c) by using a job chain to asso ciate the Job with a resource plan D) by using a job array to associate the job with a resource plan E)by using a file watcher to asso ciate the job with a resource plan 关键词: utilization利用 28. In one of your databases: You use Recovery Manager(RMAN)to perform incremental backups You have backups for the last 30 days The database is in NOARCHIVELOG mode One of its data fles is corrupt The online redo log fles are lost due to media failure. The instance is shut down Examine this list of step 1) Start up NomoUnt the database 2) Mount the database 3) Restore the control fle 4) Restore the database 5) Open the database RESETLOGS 6 Recover the database NOREDO 7 Recover the database 8) Start up moUNT the database Which is the list of required steps in the correct order to recover the database? A)8,4,7,5 B)1,2,3,4,6,5 C)8,4,6,5 D)8,3,2,4,6,5 E)1,3,2,4,6,5 29. View the Exhibit and examine the results of two queries executed In two user sessions from the same client What accounts for the formatting differences? A)The NLS LANG environment variable was changed on the database host before starting the second session B) The second session connected via the listener but the first session used a local connection C) The NLS_ LANG environment variable was changed on the client before starting the second session D) The database character set was changed before executing the second query E)The database national character set was changed before executing the second query 30. Using Recovery Manager(RMAN), you take image copies of a pro duction database's data fles. You then roll them forward at regular intervals An instance startup fails to o pen the database due to an error opening the USERS table space data fle. You must recover the data file using the image copy.--镜像副本 Examine this list of steps 1) Mount the database 2)Take the data file offline 3)Bring the tablespace online 4)Use the RMAN SWITCH TO command to switch to the image copy 5)Recover the datafile 6)Open the database 7)Use the RMAN RESTORE To command to switch to the image copy hat is the min imum sequence of steps in the correct sequence? A)1,2,6,4,5,3 B)2,7,5,3,6 C)1,2,7,5,3,6 D)2,6,4,5,3 )1,2,4,6,3 31. Which two are true about auto matic PGa memory management? A)PGA_AGGREGATE_ T ARGET cannot be configured if SGA_ TARGET is configured B)The PGA is auto-tuned whether or not PGA_AGGREGATE_ TAKGET is explicitly set C) PGA AGGREGATE TARGET cannot be configured if MEMORY TARGET is configured D) Memory is allocated separately for FGA_AGGREGATE_TARGET and SGA_TARGET E)PGA_ AGGREGATE_ TARGET always defaults to zero 32. Examine this recovery manager(RMAN) command: RUN SET UNTIL TIME2008-01-14:21:59:0 RESTORE DATABASE, RECOVER DATABASE The time specifed Is earlier than the most recent backup taken before the recovery, but older backups also exist. Which two actions will occur? A)All data files and the control file from the most recent backup prior to the recovery will be resto red B)All data files from the most recent backup prior to SET TIME will be restored.一先还原最近,再 set C) All data fles from the most recent backup will be restored D) Only the SYSTEM data file from the most recent backup will be restored E)All redo log data up to the set time will be applied F) All data flies, redo logs, and control files from the most recent backup prior to the reco very will be restored 关键词: pror优先的 33. The BOOKINGS table contains o line booking information. When a booking is confirmed the details are transferred to an archival table bookings hist and deleted from the BOOKINGS table Is no fixed time interval between each online booking and its confrmation Because sufficient space is not always available from the delete operations, the high-water mark(HWM)is mo ved up and many rows are insterted below the HWm of the table The BOOKINGS table has Automatic segments space management(ASSM)and row movement enabled. the table is accessible in 24x7 mode What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table? A)Move the BOoKINGS table to a different lo cation by using the ALTER table..move command B)Shrink the bookings table by using the alter table . shrink space command C) Perform export, drop, and import operations on the bookings table sequentially D) Deallo cate the space in the booking table by using the alter table .. deallo cate unused command 关键词: sufficient足够的 34. SQL> SHOW PARAMETER TARGET NAME TYPE VALUE Archive lag target integer Db flashback retention target integer 1440 Fast_start_io_target ge Fast start mttr target integer memory_max_target big integer 0 memory_target big integer

(系统自动生成,下载前可以参看下载内容)