单选题Which one of the following statements about the TNSPING utility is correct？（）A It helps you to determine whether or not the Oracle database is running.B It requires the username and password to check the connectivity of the service.C It does not requir

第1题：

第2题：

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

第3题：

第4题：

You use a recovery catalog for maintaining your database backups.You execute the following command:$rman TARGET / CATALOG rman / cat@catdbRMAN > BACKUP VALIDATE DATABASE ARCHIVELOG ALL;Which two statements are true?（）

• A、Corrupted blocks, if any, are repaired.
• B、Checks are performed for physical corruptions.
• C、Checks are performed for logical corruptions.
• D、Checks are performed to confirm whether all database files exist in correct locations
• E、Backup sets containing both data files and archive logs are created.

第5题：

our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

• A、Oracle Net Manager
• B、Listener Control utility
• C、Database Configuration Assistant
• D、Oracle Net Configuration Assistant

第6题：

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） 

• A、 The command restores only the missing control file.
• B、 The command restores all the control files.
• C、 The command fails because the database is running.
• D、 This is the correct way to address this problem.
• E、 This is not the correct way to address this problem.

第7题：

You are an experienced network administrator in an international corporation. One of your clients asks you to configure a network for a financial trading center which requires multiple high-value transactions. And the transactions are very important to the client. In such a situation, which two of the following are basic and most important requirements concerning the configuration? （）(Choose two.)

• A、no single point of failure
• B、determine which protocol to use
• C、trading database server location
• D、deterministic response to all failures

第8题：

第9题：

You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?（）

• A、It records the usernames and passwords of users when granted the DBA role.
• B、It contains the usernames and passwords of users for whom auditing is enabled.
• C、Is used by Oracle to authenticate users for remote database administration.
• D、It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
• E、It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

第10题：

While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you？（）

• A、Oracle Managed Files
• B、Oracle Grid Architecture
• C、Optimal Flexible Architecture
• D、Oracle database architecture