A sequence of any number of characters enclosed in the double queotes“”is called a character ______.A．arrayB．groupC．setD．string

第1题：

第2题：

第3题：

A customer has a p650 with a write-intensive database application.  Recently the order entry team has complained about unusually slow response times. There have been no complaints from any other departments.  Which of the following actions would most likely address the problem？（）

• A、Double the number of processors.
• B、Double the number of memory DIMMs.
• C、Double the number of network adapters.
• D、Double the number of SCSI buses and disks.

第4题：

Which the statement is true？（）

• A、 The Error class is a Runtime Exception.
• B、 No exceptions are subclasses of Error.
• C、 Any statement that may throw an Error must be enclosed in a try block.
• D、 any statement that may throw an Exception must be enclosed in a try block.
• E、 Any statement that may throw an Runtime Exception must be enclosed in a try block.

第5题：

When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）

• A、Thread number.
• B、Log Sequence number.
• C、Control file sequence number.
• D、Name of the last archived log.

第6题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

• A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
• D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
• F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

第7题：

Which two statements are true regarding the use of UTF-16 encoding？ （）

• A、Enables easier loading of multinational data. 
• B、Uses a fixed-width Multibyte encoding sequence.
• C、Asian characters are represented in three characters. 
• D、Used a variable-width Multibyte encoding sequence. 
• E、European characters are represented on one or two bytes. 

第8题：

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）

• A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.
• B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.
• C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.
• D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.
• E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.
• F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

第15题：

Given two different character sets （A and B）， which of the following must be true for A to be considered a strict superset of B？（）

• A、 A must contain all of the characters defined in B
• B、 A must be Unicode
• C、 The encoded values in A must match the encoded values in B for all characters defined in B 
• D、 A must be a multibyte character set
• E、 The encoded values in A must match the encoded values in B for all numeric and alphabetic character

第16题：

You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command：   RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS；   After configuring the recovery window， you performed the database backup as follows：（）  

• A、 Backup RB1 at log sequence number 12871 on 5th Jan
• B、 Backup RB2 at log sequence number 15622 on 12th Jan
• C、 Backup RB3 at log sequence 16721 on 15th Jan
• D、 On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.

第17题：

For which action can you use the TO_DATE function? （）

• A、Convert any date literal to a date
• B、Convert any numeric literal to a date
• C、Convert any character literal to a date
• D、Convert any date to a character literal
• E、Format '10-JAN-99' to 'January 10 1999'

第18题：

Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）

• A、A must contain all of the characters defined in B
• B、A must be Unicode
• C、The encoded values in A must match the encoded values in B for all characters defined in B
• D、A must be a multibyte character set
• E、The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B

第19题：

What does the Character Set Scanner command line utility do？（）

• A、Reports only on any Unicode character conversions required.
• B、Performs character set conversions to the new specified character set.
• C、Scans on any character set conversion required， then converts the data.
• D、Checks for any character definitions that will fail conversion to the new character set.

第20题：

第21题：

第22题：

第23题：