Which three tasks can be performed using regular expression support in Oracle Database 10g？（）A、 it can be used to concatenate two strings.B、 it can be used to find out the total length of the string.C、 it can be used for string manipulation and searching 

第1题：

第2题：

Which two statements are true regarding the USING clause in table joins?（）

• A、It can be used to join a maximum of three tables 
• B、It can be used to restrict the number of columns used in a NATURAL join 
• C、It can be used to access data from tables through equijoins as well as nonequijoins 
• D、It can be used to join tables that have columns with the same name and compatible data types

正确答案:B,D

第3题：

which one of the following accurately describes field names?（）

• A、they must be unique in a database  
• B、they can only be used once in a view  
• C、they can only used once on each form  
• D、they can be used mulriple times on a form 

正确答案:C

第4题：

Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） 

• A、 The ADR base keeps all diagnostic information in binary format
• B、 SQL*Plus provides the ADRI script， which can be used to work with ADR
• C、 The ADR can be used for problem diagnosis only when the database is open
• D、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
• E、 The ADR can be used for problem diagnosis even when the database instance is down
• F、 The ADR base is shared across multiple instances

正确答案:E,F

第5题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation？（）

• A、 The backup as copy can only be taken to disk
• B、 The backup as copy can only be taken to tape
• C、 Backup can be performed only when the instance is shutdown
• D、 Backup will constitute all used and unused blocks in the database

正确答案:A,D

第6题：

You want to perform an RMAN backup of database as a copy. Which two factors will you consider whileperforming the backup operation?（） (Choose two).

• A、The backup as copy can only be taken to disk
• B、The backup as copy can only be taken to tape
• C、Backup can be performed only when the instance is shutdown
• D、Backup will constitute all used and unused blocks in the database

正确答案:A,D

第7题：

Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）  

• A、 Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
• B、 Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent.
• C、 Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
• D、 Health Monitor checks are always initiated manually when there is some critical error.

正确答案:A,B

第8题：

Which three tasks can be performed using a duplicate database？（）

• A、 Testing the backup and recovery procedures
• B、 Testing the upgrade of an Oracle database to a new release
• C、 Testing the effect of an application changes on database performance
• D、 Continuously updating archive log files from the target database to support failover

正确答案:A,B,C

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

NBAR is a Cisco IOS feature that can be used to perform three tasks？

正确答案: （1）Protocol discovery
（2）Traffic statistics collection
（3）Traffic classification

第15题：

Which two statements regarding external authentication servers for firewall userauthentication are true？（）

• A、Up to three external authentication server types can be used simultaneously.
• B、Only one external authentication server type can be used simultaneously.
• C、If the local password database is not configured in the authentication order， and the configured authentication server is unreachable， authentication is not performed.
• D、If the local password database is not configured in the authentication order， and the configured authentication server rejects the authentication request， authentication is not performed

正确答案:B,D

第16题：

Which three tasks can be performed using a duplicate database? （）(Choose three.)

• A、Testing the backup and recovery procedures
• B、Testing the upgrade of an Oracle database to a new release
• C、Testing the effect of an application changes on database performance
• D、Continuously updating archive log files from the target database to support failover

正确答案:A,B,C

第17题：

Which two statements are true about the Automatic Diagnostic Repository (ADR)?（） (Choose two.)

• A、The ADR base keeps all diagnostic information in binary format
• B、SQL*Plus provides the ADRI script, which can be used to work with ADR
• C、The ADR can be used for problem diagnosis only when the database is open
• D、The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
• E、The ADR can be used for problem diagnosis even when the database instance is down
• F、The ADR base is shared across multiple instances

正确答案:E,F

第18题：

Which two statements are true regarding the USING and ON clauses in table joins?（）

• A、Both USING and ON clauses can be used for equijoins and nonequijoins 
• B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
• C、The ON clause can be used to join tables on columns that have different names but compatible data types 
• D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

正确答案:C,D

第19题：

Which statement is true regarding remote archive log file destinations？（）

• A、Only two destinations per remote database can be specified.
• B、Destination is an Oracle Net alias specified by using the SERVICE keyword.
• C、The REOPEN attribute must be used when using remote archive log file destinations.
• D、The service name is resolved by searching sqlnet.ora file for the remote database name.

正确答案:B

第20题：

第21题：

第22题：

第23题：