Oracle認證考試1Z0-031章節(jié)練習(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?（）

點擊查看答案