The safer , easier way to help you pass any IT exams.
Exam : 1Z0-052
Title
Oracle Database 11g: :
Administration I
Version : V8.02
1 2 5 6 10 11 12 13 17 22 24 27 30 32 38 40 41 42 43 44 45 46 47 50 53 54 57 63 64 65 67 72 73 77 80 82 85 87 88 89 92 93 94 95 96 97 98 99 100 102 106 107 108 110 116 117 119 124 127 128 131 134 138 141 144 146 147 149 151 152 153 158 163 165 166 169 170 172 174 177 2，10，30，40，47，49，50，60，63，64，77，85， 92，100，102，117，170，1721 / 86
The safer , easier way to help you pass any IT exams.
1. View the Exhibit and examine the attributes of an undo tablespace.
n. 属性；特质 vt. 归属；把…归于
retention n. 保留；扣留，滞留；记忆力；闭尿guarantee n. 保证；担保；保证人；保证书；抵押品 vt. 保证；担保extensible
adj. 可延长的；可扩张的
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour
abbr. 联机事务处理
批量插入
bulk
n. 体积，容量；大多数，大部分；大块 vt. 使扩大，使形成大量；使显得重要
adj. 最高的；最大值的
that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
n. 快照
ORA-01555: snapshot too old
What could be the reason for this error?
A.The query is unable to get a read-consistent image.
读一致性
consistent adj. 始终如一的，一致的；坚持的
B.There is not enough space in Flash Recovery Area.
闪回恢复区
C.There is not enough free space in the flashback archive. D.The query is unable to place data blocks in undo tablespace
vt. 放置；任命；寄予
Answer: A
2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.) 自动工作负荷知识库/自动工作负载信息库
A.All AWR tables belong to the SYSTEM schema.
B.The AWR contains systemwide tracing and logging information.
系统跟踪
记录信息 轻易进入
accessible
adj. 易接近的；可进入的；可理解的
C.The snapshots collected by the AWR are accessible through data dictionary views.
v. 收集；聚集（collect的过去式） 被…使用adj. 镇定的；收集成的
自调优组件
D.The snapshots collected by the AWR are used by self-tuning components in the database. Answer: CD
thereby adv. 从而，因此；在那附近；在那方面
3. While observing the index statistics, you find that an index is highly fragmented, thereby resulting in
v. 观察；遵守
n. 统计； v. 分裂；使成碎片 导致，结果是
poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?
vt. 证实，验证；确认；使生效n. 破碎；分裂；[计] 存储残片
v. 影响（affect的ing形式）
A.Validate the index structure using the ANALYZE...INDEX command. B.Rebuild the index using the ALTER INDEX..REBUILD ONLINE command. C.Change the block space utilization parameters using the ALTER INDEX command.
利用率；利用
D.Deallocate the unused space in the index using the ALTER INDEX..DEALLOCATE UNUSED command. 解除分配；释放
2 / 86
The safer , easier way to help you pass any IT exams.
Answer: B
4. Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type of backups that can be performed on the database? A.You can perform online whole database backups. B.You can perform offline whole database backups.
C.You cannot perform schema-level export/import operations.
D.You can perform the backup of only the SYSTEM tablespace when the database is open. Answer: B
5. The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. 完整性检验Given below are the steps to recover from the error in random order:
下面/如下/下文[计] 随机顺序
1: Shut down the instance, if not already done.
2: Copy one of the remaining control files to a new location.
3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.
4: Start up the database instance to the NOMOUNT stage. 5: Recover the database to the point of failure of the control file. 6: Open the database.
Identify the correct sequence of steps?
vt. 确定；鉴定；识别，辨认出
A.1, 2, 4, 3, 5, 6
B.2, 4, 3, 5, 6; 1 not required C.4, 5, 6, 2, 3; 1 not required D.5, 2, 3, 4; 1 and 6 not required Answer: A
utility 的复数形式
6. Note the following points describing various utilities in Oracle Database 11g: n. 点；见解
n. 实用；效用；公共设施；功用
3 / 86
The safer , easier way to help you pass any IT exams.
1: It enables the high-speed transfer of data from one database to another.
vt. 使能够，使成为可能；
2: It provides a complete solution for the backup, restoration, and recovery needs of the entire database. 3: It enables the loading of data from an external file into an Oracle database. 4: It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup? A.1 B.2 C.3 D.4
E.1, 2, and 4 F.1, 2, 3, and 4 Answer: D
n. 生态系统
7. You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database: 1: SGA is allocated.
adj. 分配的，指派的
2: Control file is read. 3: Redo log files are read. 4: Instance recovery is started. 5: Background processes are started. 6: Data files are checked for consistency.
检查
n. [计] 一致性；稠度；相容性
n. [计] 初始化；赋初值7: Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?
vi. 发生；出现；存在
A.7, 1, 5, 2, 3, 6, 4 B.1, 2, 3,7, 5, 6, 4 C.7, 1, 4, 5, 2, 3, 6 D.1, 7, 5, 4, 2, 3, 6 Answer: A
8. Observe the information in the columns: vt. 观察
n. 纵队，列；专栏；圆柱，柱形物
4 / 86
The safer , easier way to help you pass any IT exams.
1: The SGAa. Text and parsed forms of all SQL statements
2: The cursor stateb. Run-time memory values for the SQL statement, such as rows retrieved
[计] 检索；恢复；重新得到
3: User-session datac. Security and resource usage information 4: The stack spaced. Local variables for the process
[计] 栈空间
n. [数] 变量
Which option has the correct match between the memory areas and their contents? A.1-c, 2-b, 3-d, 4-a B.1-c, 2-b, 3-d, 4-a C.1-a, 2-b, 3-c, 4-d D.1-a, 2-b, 3-d, 4-c Answer: C
9. View the Exhibit and examine the privileges granted to the SL_REP user.
The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr;
Which statement describes the outcome of the command?
5 / 86
OCP题库及模拟考试2
