You need to create a data block for DML operations in the NE

第1题：

You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）

• A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
• B、Create a CHECK constraint.
• C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
• D、Create a DML AFTER trigger that writes the failed records to a file or table.

第2题：

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)

• A、You must configure block change tracking file
• B、You must have first level 1 backups for RMAN to restore blocks
• C、You must ensure that the SALES database is mounted or open
• D、You must have full or level 0 backups for RMAN to restore blocks
• E、You must take the tools01.dbf data file offline before you start a block media recovery

第3题：

第4题：

You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）

• A、Create the relation manually and coordinate the blocks using triggers. 
• B、Base the relation on a REF pointer using the Data Block Wizard. 
• C、Base the relation on a foreign key using the Data Block Wizard. 
• D、This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.

第5题：

There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） 

• A、the DBNEWID utility
• B、the DBVERIFY utility
• C、the ANALYZE command
• D、the RMAN REPORT command
• E、the RMAN CROSSCHECK command
• F、the CHECK_OBJECT procedure of the DBMS_REPAIR package

第6题：

In your web application，you need to execute a block of code whenever the session object is first created. Which design will accomplish this goal？（）

• A、Create an HttpSessionListener class and implement the sessionInitialized method with that block ofcode.
• B、Create an HttpSessionActivationListener class and implement the sessionCreated method with thatblock of code.
• C、Create a Filter class， call the getSession（false） method， and if the result was null， then execute that block of code.
• D、Create an HttpSessionListener class and implement the sessionCreated method with that block of code.

第7题：

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

第8题：

ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）

• A、vector 
• B、database view 
• C、database table 
• D、transactional trigger 
• E、PL/SQL table of records 
• F、multi-dimensional array

第9题：

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

• A、by using triggers
• B、by using Data Pump
• C、by using external tables
• D、by using anonymous PL/SQL blocks

第10题：

You create a Data Collector Set (DCS).You need prevent the DCS from logging data if the server has less than 1 GB of available disk space. What should you do？（）

• A、Create a passive file screen.
• B、Create an active file screen.
• C、Modify the Data Manager settings of the DCS.
• D、Modify the Stop Conditions settings of the DCS.