Oracle認(rèn)證考試1Z0-031章節(jié)練習(xí)(2018.08.01)

來源：考試資料網(wǎng)

1 When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）

點(diǎn)擊查看答案&解析

2 To determine the space allocated for temporary segments, the DBA can access which of the following views? （）

點(diǎn)擊查看答案&解析

3 A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

點(diǎn)擊查看答案&解析

4 You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）

點(diǎn)擊查看答案&解析

5 You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

點(diǎn)擊查看答案&解析

6 You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）

點(diǎn)擊查看答案&解析

7 Which component of the SGA stores parsed SQL statements is used for process sharing?（）

點(diǎn)擊查看答案&解析

8 Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）

點(diǎn)擊查看答案&解析

9 In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）

點(diǎn)擊查看答案&解析

10 If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）

點(diǎn)擊查看答案&解析