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

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

1 In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）

點擊查看答案&解析

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

點擊查看答案&解析

3 You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

點擊查看答案&解析

4 You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

點擊查看答案&解析

5 You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

點擊查看答案&解析

6 Which of the following choices identifies a database component that will be used for multiplexing control files?（）

點擊查看答案&解析

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

點擊查看答案&解析

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

點擊查看答案&解析

9 You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

點擊查看答案&解析

10 You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

點擊查看答案&解析