You have a large amount of historical data in an operating system file. Some analysts in your organization need to query this data. The file is too large to load into your current database. Which is the most effective method to accomplish the task？（）A、Upg

第1题：

You are the network administrator for your company. The network consists of a single Active Directorydomain. The functional level of the domain is Windows Server 2003.Some user accounts have expiring passwords and some do not. You need to identify all user accounts that do not have expiring passwords. You need to modify the passwordproperty to allow the passwords on these accounts to expire. You must complete this task by using the minimum amount of administrative effort.First, you create a saved query to obtain a list of all user accounts that do not have expiring passwords.What should you do next? （）

• A、Export the query results to a comma-delimited file. Use a CSVDE script to modify the password property of each user account.
• B、From the Results pane of the query, select all user accounts and modify their password properties simultaneously.
• C、Export the query results to a comma-delimited file. Use an LDIFDE script to modify the password property of each user account.
• D、From the Results pane of the query, select each user account and modify the password property, one by one.

第2题：

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

• A、Use the database link.
• B、Use the SQL*Loader utility.
• C、Use the Oracle Data Pump utility.
• D、Create an external table and leave the data in the flat file

第3题：

第4题：

A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、 Flash back all the tables in the data file， one by one.
• B、 Restore the data file to a new location and perform a media recovery.
• C、 Flash back the database， there is no need to restore the data file.
• D、 Restore the data file from the most recent backup and flash the database.

第5题：

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database.  Which method would you use to recover the data file？（）

• A、Restore all the data files and open the database
• B、Create the data file and performtablespacerecovery
• C、No need to restore any file， just recover the database
• D、Restore only the system data file and recover the database
• E、Restore only lost date file and performtablespacerecovery

第6题：

Your network contains a Distributed File System (DFS) target folder named Folder1 that contains 100 GB of data. You plan to create a new DFS replica of Folder1 on a server named Server2. You need to prestage the data in Folder1 on Server2. The solution must ensure that the amount of initial DFS replication traffic is minimized. Which tool should you use to prestage the Folder1 data？（）

• A、Dfscmd
• B、Dfsrmig
• C、Dfsutil
• D、Wbadmin

第7题：

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

• A、Restore and recover the datafile. 
• B、Restore and recover the tablespace. 
• C、Restore and recover the database. 
• D、Restore and recover the control file. 
• E、Restore and recover the parameter file.

第8题：

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、flash back all the tables in the data file， one by one
• B、restore the data file to a new location and perform a media recovery
• C、flash back the database; there is no need to restore the data file
• D、restore the data file from the most recent backup and flash back the database

第9题：

You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load 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.

第10题：

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

• A、 Enable Flashback Data Archive for the tables.
• B、 Specify undo retention guarantee for the database.
• C、 Enable supplemental logging for the database.
• D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
• E、 Create Flashback Data Archive on the tablespace on which the tables are stored.