单选题You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use

第1题：

The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）

• A、Programme units. 
• B、PL/SQL libraries. 
• C、Database object. 
• D、Built in packages.

第2题：

You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis.  How would you achieve this？（）

• A、by using triggers
• B、by using external tables
• C、by using anonymous PL/SQL blocks
• D、by auditing all DML operations on the table

第3题：

You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler（）

• A、XML script
• B、PL/SQL script
• C、Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.com
• D、Recovery Manager （RMAN） script

第4题：

You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

• A、use the external table population
• B、use the Oracle Data Pump export and import utility
• C、use the conventional path data load of SQL*Loader utility
• D、use the direct path data load of Oracle export and import utility

第5题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

• A、 functions
• B、 package
• C、 procedure
• D、 database trigger
• E、 anonymous PL/SQL block

第6题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）

• A、function
• B、package
• C、procedure
• D、database trigger
• E、anonymous PL/SQL block

第7题：

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）

• A、SQL*Plus
• B、iSQL*Plus
• C、Management Server
• D、Management Repository
• E、Oracle Enterprise Manager 10g Database Control

第8题：

You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

• A、Use the external table population.
• B、Use the Oracle Data Pump export and import utility.
• C、Use the conventional path data load of the SQL*Loader utility.
• D、Use the INSERT INTO...SELECT command to load the data

第9题：

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

• A、the XML script
• B、the PL/SQL script
• C、the DBMS_SCHEDULER package
• D、Enterprise Manager to schedule the backup

第10题：

You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）

• A、Monitor thealert.logfile
• B、Enable server-side SQL tracing for user sessions
• C、Enable fine-grained auditing for the customer table
• D、Enable Fine-Grained Access Control （FGAC） for the customer table
• E、Write a database trigger on the customer table on the SELECT event