Oracle認證考試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? （）

點擊查看答案

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

點擊查看答案

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?（）

點擊查看答案

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? （）

點擊查看答案

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

點擊查看答案

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?（）

點擊查看答案

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

點擊查看答案

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

點擊查看答案

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? （）

點擊查看答案

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?（）

點擊查看答案