单选题Which of the following is a characteristic of a sequence?（）A A sequence will never generate duplicate valuesB The MAXVALUE of a sequence can be equal to the MINVALUEC It is not possible to create a sequence that generates a constant since the INCREMENT

第1题：

第2题：

第3题：

Which of the following is a characteristic of a sequence?（）

• A、A sequence will never generate duplicate values
• B、The MAXVALUE of a sequence can be equal to the MINVALUE
• C、It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
• D、When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

第4题：

A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）

• A、2
• B、3
• C、11
• D、30

第5题：

Which two patented or patent-pending compression and caching technologies are used for WX/WXC devices?（）(Choose two.)

• A、Network Sequence Caching (NSC)
• B、Molecular Sequence Caching (MSC)
• C、Network Sequence Reduction (NSR)
• D、Molecular Sequence Reduction (MSR)

第6题：

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.

第7题：

Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived， and it contained information from 10：35 a.m. onwards.  The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1;  3> ALTER DATABASE MOUNT;  4> RESTORE DATABASE;  5> RECOVER DATABASE;  6> ALTER DATABASE OPEN RESETLOGS; 7> };  With reference to this scenario， which statement is true？（）

• A、RMAN recovers up to log sequence 230， but not including 230.
• B、RMAN returns an error because the log sequence number mentioned in the command should be 229.
• C、RMAN returns an error because the log sequence number mentioned in the command may never be missing.
• D、RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）

• A、The next value will be 0 and the sequence will never use the values 101 to 105.
• B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
• C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
• D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

第15题：

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）

• A、After a ROLLBACK is issued
• B、After the sequence is altered
• C、After the sequence is dropped
• D、After the current session ends

第16题：

Which of the following privileges permits a user to update the comment on a sequence?（）

• A、CONTROL
• B、UPDATE
• C、USAGE
• D、ALTER

第17题：

What is true about sequences? （）

• A、Once created, a sequence belongs to a specific schema.
• B、Once created, a sequence is linked to a specific table.
• C、Once created, a sequence is automatically available to all users.
• D、Only the DBA can control which sequence is used by a certain table.
• E、Once created, a sequence is automatically used in all INSERT and UPDATE statements.

第18题：

Which of the following can be used in conjunction with a Flashback Versions Query to filter the results？（）

• A、 A range of SCN values
• B、 A list of SCN values
• C、 A starting and ending timestamp
• D、 Minimum and maximum sequence values
• E、 A list of sequence values

第19题：

Which two statements about sequences are true? （）

• A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
• B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
• C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
• D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
• E、If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
• F、You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

第20题：

第21题：

第22题：

第23题：