单选题After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new d

第1题：

While working on the database， you receive the following error：        01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

• A、 Block Media Recovery must be used with RMAN.
• B、 You must perform complete recovery of individual blocks.
• C、 You must have a full RMAN backup， not an incremental backup.
• D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.

第2题：

In which scenario will you create a sorted hash cluster？ （）

• A、 if the application uses queries joining tables only occasionally
• B、 if the full table scan is executed often on only one table of the clustered tables
• C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
• D、 when you want the data to be returned automatically in the chronological order

第3题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第4题：

The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command：        SQL> EXECUTE   DBMS_SERVER_ALERT.SET_THRESHOLD        （dbms_server_alert.tablespace_pct_full，        dbms_server_alert.operator_ge，80，        dbms_server_alert.operator_ge，90，        1，1，NULL，   dbms_server_alert.object_type_tablespace，’DATA’）；   What will be the result of the command？（）  

• A、 The command will be executed successfully only if the tablespace DATA1 is a dictionary-managed tablespace.
• B、 The total numbers of alerts that you receive every day will be reduced.
• C、 The total number of alerts that you receive every day will be increased.
• D、 No more data will be added to the DATA1 tablespace if 80% of the space allocated to the DATA1 tablespace is used.

第5题：

Windows Communication Foundation （WCF） application uses a data contract that has several data members. You need the application to throw a Serialization Exception if any of the data members are not present when a serialized instance of the data contract is deserialized. What should you do？（）

• A、 Add the Known Type attribute to the data contract.Set a default value in each of the data member declarations.
• B、 Add the Known Type attribute to the data contract.Set the Order property of each data member to unique integer value.
• C、 Set the Emit Default Value property of each data member to false.
• D、 Set the Is Required property of each data member to true.

第6题：

You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）

• A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.
• B、Define the new column as NOT NULL with a default value of ’Undefined.’
• C、Define the new column as NULL. Use application logic to enforce the data constraint.
• D、Define the new column as NULL with a default value of ’Undefined.’

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new default value for numeric full redaction?（）

• A、Re-enable redaction policies that use FULL data redaction.
• B、Re-create redaction policies that use FULL data redaction.
• C、Re-connect the sessions that access objects with redaction policies defined on them.
• D、Flush the shared pool.
• E、Restart the database instance

第15题：

You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）

• A、 You do not need to restore all the data files.
• B、 You do not need to open the database with the RESETLOGS operation
• C、 You do not need to perform a full backup after the RESETLOGS operation.
• D、 You do not need to recover all the data files to the same system change number （SCN）.

第16题：

You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）

• A、 Create an INSERT trigger to assign the default value to each item in the table. 
• B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. 
• C、 Create an UPDATE trigger to update the default value for each new item in the table. 
• D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.

第17题：

A Windows Communication Foundation (WCF) application uses a data contract that has several data members. You need the application to throw a SerializationException if any of the data members are not present when a serialized instance of the data contract is deserialized.What should you do?（）

• A、Add the KnownType attribute to the data contract. Set a default value in each of the data member declarations.
• B、Add the KnownType attribute to the data contract. Set the Order property of each data member to unique integer value.
• C、Set the EmitDefaultValue property of each data member to false.
• D、Set the lsRequired property of each data member to true.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：