The safer , easier way to help you pass any IT exams.
Answer: ACD
22. Identify the logical structure that will never have more than one data segment created for it. A.external table B.partitioned table C.partitioned index D.nonclustered table E.global temporary table Answer: D
23. Note the following structures in your database server: 1: Extents 2: OS Blocks 3: Tablespace 4: Segments 5: Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest? 安排；排列；整理
database-->tablespace-->segment-->extent-->oracle data block
A.2, 5, 1, 4, 3 B.1, 2, 3, 4, 5 C.5, 2, 1, 3, 4 D.2, 1, 5, 4, 3 Answer: A
24. Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.)
across
穿过；横穿；跨过；跨越
A.An extent cannot spread across data files.
传播，散布；展开；
一个数据文件只能属于一个表空间。
而数据文件和extent也是一对一的，即是说数据文件不能夸区，但可以夸段。
B.A segment cannot spread across data files. C.A data file can belong to only one tablespace. D.A data file can have only one segment created in it.
E.A data block can spread across multiple data files as it can consist of multiple operating system (OS)
11 / 86
The safer , easier way to help you pass any IT exams.
blocks. Answer: AC
25. Which three operations require undo data? (Choose three.) A.committing a transaction B.flashing back a transaction C.recovering a failed transaction D.running a read-consistent query
E.changing a tablespace status from READ ONLY to READ WRITE Answer: BCD
26. Which two statements are true regarding undo tablespaces? (Choose two.) A.The database can have more than one undo tablespace.
B.The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management. C.Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their
vt. 使缩小，使收缩
担当；充当
assigned transactions.
D.An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up. Answer: AC
27. Which two statements are true regarding transactions in an Oracle database? (Choose two.) A.Multiple transactions can use the same undo segment. B.A transaction is assigned an undo segment when it is started.
C.More than one transaction cannot share the same extent in the undo tablespace.
D.The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used. Answer: AB
28. View the Exhibit and examine the undo tablespace attributes.
12 / 86
The safer , easier way to help you pass any IT exams.
Your database instance is experiencing a large volume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full with transactions and no transaction was committed more than one hour ago. The database has two more undo tablespaces. What happens to the new DML operations in this scenario? A.The DML commands will fail.
B.The undo data generated by the DML is stored in one of the two other undo tablespaces. C.The undo data generated by the DML will overwrite the extents that contain committed undo data.
vt. 重写；
D.The undo data generated by the DML is stored in the SYSTEM undo segment of the SYSTEM tablespace. Answer: A
29. Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this command have on the database? n. 影响；效果；作用
A.The extents in the undo tablespace retain data until the next full database backup.
vt. 保持；雇；记住
B.The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes.
900 seconds/60=15 minutes
C.The extents containing committed data in the undo tablespace are not overwritten until the instance is
vt. 重写；覆写；重叠写在…上面
shut down.
D.The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Area before being overwritten. Answer: B
30. In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value? A.when the data file of the undo tablespace is autoextensible
13 / 86
The safer , easier way to help you pass any IT exams.
B.when there are more than one undo tablespaces available in the database C.when the undo tablespace is of a fixed size and retention guarantee is not enabled D.when the undo tablespace is autoextensible and retention guarantee is not enabled Answer: C
31. Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?
A.It is the time period after which the undo data becomes obsolete. n. 周期，期间；时期
adj. 废弃的；老式的；过时的
B.It is the time period after which the committed undo data would be transferred to a temporary tablespace.
C.It is the minimum time period up to which the committed undo data would be retained if free undo space is available.
D.It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency. Answer: C
32. Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.
n. 能力；容量；资格，地位；生产力
Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo n. 因素；要素；
vt. 估计，估量；判断，评价
tablespace? (Choose two.)
A.the retention period to support flashback B.the expected length of the longest-running query
adj. 预期的；预料的 v. 预期；盼望（expect的过去分词）
C.the number of undo tablespaces in the database
D.the size of the Flash Recovery Area for the database instance Answer: AB
33. Some non-DBA users in your database have been granted ANY TABLE system privileges and they
vt. 授予；允许；承认
are able to access data dictionary base tables. You decide to restrict their access to data dictionary
vt. 限制；约束；限定
objects.
14 / 86
The safer , easier way to help you pass any IT exams.
Which method would you adopt to achieve this objective? A.Revoke the RESOURCE role from the users. vt. 撤回，取消；废除
vt. 采取；接受；收养；正式通过 vi. 采取；过继
07_DICTIONARY_ACCESSIBILITY=false时： SELECT ANY TABLE权限允许你访问除了SYS下的所有视图或表。 EXECUTE ANY PROCEDURE权限允许你访问除了SYS下的所有存储过程。 B.Set the value of the OS_ROLES parameter to TRUE.
C.Use Database Resource Manager to restrict user access to objects. D.Grant ANY TABLE system privileges again without ADMIN OPTION.
E.Set the value of the O7_DICTIONARY_ACCESSIBILITY parameter to FALSE. Answer: E
07_DICTIONARY_ACCESSIBILITY 控制对系统权限的限制：
TRUE 有相应系统权限，允许访问SYS下的对象。
FALSE 确保拥有可以访问任何对象的系统权限，但不可以访问SYS下的对象
log in 注册；请求联机；登录，登入
34. A user, who is authenticated externally, logs in to a remote machine and connects to the database v. 已认证；已验证（authenticate的过去分词）
instance. What action would you take to ensure that a user cannot connect to the database instance by
adv. 仅仅，只不过；只是
merely logging in to a remote machine? A.Set REMOTE_OS_ROLES to FALSE. B.Set the OS_ROLES parameter to FALSE.
C.Set the REMOTE_OS_AUTHENT parameter to FALSE.
REMOTE_OS_AUTHENT指定远程客户端是否使用OS_AUTHENT_PREFIX参数的值来授权
D.Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE. Answer: C
参数名有误，应为REMOTE_LOGIN_PASSWORDFILE，指定Oracle是否检查口令文件35. You executed the command to create a password file in the database server: $ orapwd file=orapworcl entries=5 ignorecase=N
Which statement describes the purpose of the above password file? A.It records usernames and passwords of users when granted the DBA role. B.It contains usernames and passwords of users for whom auditing is enabled. C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups. Answer: C
36. In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALES table during the last few days. You
adj. 可疑的；暧昧的；无把握的；半信半疑的
are able to track users, actions taken, and the time of the action for this particular period but the changes adj. 特别的；详细的；
15 / 86
OCP题库及模拟考试2
