OCP-083 110题.pdf
5墨值下载
考试科目：1Z0-083
题目解答：
题目制作：
考试题量：85
通过分数：57%
考试预约联系：
1、Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and
later releases?
A)Space is only reclaimed when there is space pressure in the Fast Recovery Area(FRA)
B)Space is always reclaimed automatically when the retention period for Flashback logs is
lowered
C)Space might be reclaimed proactively before space pressure occurs
D)Space is always reclaimed proactively before space pressure occurs
E) Space might be reclaimed automatically when the retention period for Flashback logs is
lowered
答案: CE
2、Which two are true about server-generated alerts?
A)Stateless alerts can be cleared manually
B)Stateless alerts are automatically cleared after one day.
C)Stateful alerts are purged automatically from the alert history after one day
D)Stateless alerts can be purged manually from the alert history.
E) Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
答案: AD
3、Which three are true about upgrading Oracle Grid Infrastructure?
A)The newer version is installed in a separate Oracle Grid Infrastructure home on the same server
as the existing version
B)A direct upgrade can be performed only from the immediately preceding Oracle Grid
Infrastructure version
C) The upgrade process will automatically install all mandatory patches for the current version of
Oracle Grid Infrastructure
D) Only the grid user can perform the upgrade
E) Existing Oracle Database instances must be shut down before starting the upgrade
F）An existing Oracle base can be used.
答案: AEF
4、Which two are true about the Program Global Area(PGA)and its management in an Oracle
database instance?
A)PGA AGGREGATE LIMII is a hard limit on the PGA size for any one session
B)The entire PGA is located in the System Global Area(SGA)when using shared servers
C)The private SQL area(UGA)is located in the System Global Area(SGA)when using shared
servers
D)Sorts and Hash Joins use PGA memory.
E) The private SQL area(UGA)is located in the System Global Area(SGA)when using dedicated
servers
答案: CD
5、You plan to perform cross-platform PDB transport using XTTS.
Which two are true?
A)A backup of the PDB must exist, taken using the BACKUP command with the ro PLATFORM
clause
B) The source PDB can be in MOUNT or OPEN state
C)The source PDB must be in MOUNT state.
D) The source PDB must not be an application root.
E) Automatic conversion of endianess occurs.
F) The source and target platforms must have the same endianess
答案: AF
6、Which two are true about the automatic execution of operating system scripts when performing
silent mode installation starting from Oracle Database 19c?
A) The installer will prompt for the root or sudo password
B)Silent install always runs operating scripts automatically.
C) The response file can specify the root or sudo password
D)The response file must contain the root or sudo password
E) The response file can specify the path of the sudo program
答案: AE
7 、Which three actions will add a resource to an Oracle Restart configuration?
A)creating a database service using Oracle Database Configuration Assistant(DBCA)
B)creating a disk group using the CREATE DISKGROUP SQL statement
C) creating a database using the CREATE DATABASE SQL statement
D)creating an Oracle Database service by modifying the SERVICE NAMES parameter
E)creating an Oracle Automatic Storage Management(AM)instance with ASM Configuration
Assistant(ASMCA)
F ) creating a database service using DBMS SERVICE CREATE SERVICE
答案: ABE
8、How do you configure a CDB for local undo mode?
A)Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace
Execute AI TER DAMBASE LOCAL UNDO ON in each PDB. and then restart the CDB instance
B)Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE
LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.
C) Open the CDB instance in upgrade mode. In CDB&ROOT, execute ALTER DATABASE
LOCAL UNDO ON, and then restart the CDB instance
D) Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL
UNDO ON and then change the CDB to read/write mode
of 30
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论