1
Oracle 19c OCP 062-新增题库 要考的尽快
免费下载
5.! Examine the details of the uncompressed,non-partitioned heap table CITIES.
!
Examine the command:!
SQL>ALTER TABLE cities SHRINK SPACE COMPACT;!
What must you do before executing it?!
A)! Make sure that row movement is disabled!
B)! Disable any constraints on the table.!
C)! Make sure that row movement is enabled.!
D)! Make any invisible indexes on the table visible.!
E)! Make all indexes on the table invisible. !
答案：C!
解释：参考53题，段收缩前，保证表空间是ASSM，且启⽤了⾏移动!
!
9.! A database runs in NOARCHTVELOG mode.!
Backup scheduling for this database must be automated before upgrading to a new
version of the database.!
Which two tools or utilities can do this?!
A)! SOL Developer!
B) ! Database upgrade Assistant (DBUA)!
C)! Oracle Enterprise Manager Cloud Control!
D) ! Oracle Enterprise Manager Database Express(EM Express)!
E)! Database Configuration Assistant (DBCA)!
答案：BC!
解释： DBUA在12的版本中加⼊特性，可以选择在升级的过程中执⾏RMAN备份。!
!
12.! You must create a table, DAILY_ORDERS, for a DSS application.!
Data should be compressed when using direct-path INSERT!
The table will also be used for occasional Dss queries.!
Load performance is critical!
Which compression option satisfies these requirements?!
A)! COLUMN STORE COMPRESS FOR QUERY HIGH!
B)! ROW STORE COMPRESS ADVANCED!
c) ! COLUNN STORE COMPRESS FOR QUERY LOW!
D)! COLUNN STORE COMPRESS FOR ARCHIVE HIGH!
E)! COLUNN STORE COMPRESS FOR ARCHIVE LOW!
答案：B!
!
13.!
!
Now examine these steps!
1) STARTUP NOMOUNT!
2) STARTUP MOUNT!
3) STARTUP FORCE!
4）ALTER DATABASE ARCHIVELOG!
5) ALTER DATABASE MOUNT;!
6) ALTER DATABASE OPWEN RESETLOGS!
7) SHUTDOWN IMMEDIATE!
8) ALTER DATABASE OPEN;!
Identify the required steps in the correct order to change the database to run in
ARCHIBELOG mode.!
A) 7,1,4,5,6!
B) 7,2,4,8!
C) 3,4,8!
D) 7,2,4,6!
E) 3,4,6!
答案：B!
!
39.! A database runs in ARCHIVELOG mode.!
Daily full database backups are taken with RMAN which is configured to perform control
file autobackup.!
The control file and redo log files are multi-plexed!
In which two cases is media recovery required?!
A)! loss of one copy of the control file!
B)! loss of all inactive online redo log group members!
C)! loss of data files that belong to the SYSAUX tablespace!
D) ! physical corruption of data!
E) ! loss of a data file that belongs to the active undo tablespace!
答案：AC CD!
!
47.! Examine these configuration details:!
1.! A Fast Recovery Area(FRA)has been specified for a database.!
2.! The database instance is in ARCHIVELOG mode!
3.! The default location for archived redo log files is the FRA.!
Which two types of files are removed automatically due to space pressure in the FRA?!
A) ! obsolete spfiles!
B) ! Mirrored copies of online logs!
C) ! expired RMAN database backup sets!
D) ! flashback logs!
E) ! expired RMAN image copies!
F) ! obsolete RMAN database backup sets!
答案：AF!
解释：expired是本来RMAN以为存在但是实际上在磁盘或者磁带上已经被删除了的⽂件。!
!
56.! Examine this configuration for one of your databases:!
1.! UNDO_RETENTION parameter is 1000!
2.! retention is not guaranteed!
3.! the undo tablespace is fixed size.!
Which two statements are true?!
A) Inactive undo is retained for at least 1000 seconds if free undo space is available.!
B) Active undo is retained for only for 1000 seconds.!
C) ! Expired undo is retained for 1000 seconds even if transactions fail due to lack of
space in the undo tablespace.!
D) ! Inactive undo is retained for 1000 seconds even if transactions fail due to lack of
space in the undo tablespace.!
E)! Active undo never becomes expired.!
答案：AE!
!
60. !You must upgrade your Oracle 11g Database to Oracle 12c R2.!
Which method can you use?!
A) ! Use Enterprise Manager Express.!
of 55
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论