单选题What is true about sequences?（）A The start value of the sequence is always 1.B A sequence always increments by 1.C The minimum value of an ascending sequence defaults to 1.D The maximum value of descending sequence defaults to 1.

题目
单选题
What is true about sequences?（）
A

The start value of the sequence is always 1.

B

A sequence always increments by 1.

C

The minimum value of an ascending sequence defaults to 1.

D

The maximum value of descending sequence defaults to 1.

相似考题

1.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 issuedB.After the sequence is alteredC.After the sequence is droppedD.After the current session ends

2.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 value must be greater than zeroD.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

3.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.

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.2B.3C.11D.30

更多“单选题What is true about sequences?（）A The start value of the sequence is always 1.B A sequence always increments by 1.C The minimum value of an ascending sequence defaults to 1.D The maximum value of descending sequence defaults to 1.”相关问题

  • 第1题：

    You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

    • A、 The log sequence for the database will restart from 1.
    • B、 The log sequence number will be written to the control file.
    • C、 The log sequence number will be written to the datafile headers.
    • D、 The log sequence number will be written to the initialization parameter file.

    正确答案:D

  • 第2题：

    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

    正确答案:A

  • 第3题：

    A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）

    • A、20
    • B、25
    • C、50
    • D、55

    正确答案:D

  • 第4题：

    Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）

    • A、The MTTR advisor will be disabled.
    • B、Automatic checkpoint tuning will be enabled.
    • C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
    • D、The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.

    正确答案:B,C

  • 第5题：

    What is true regarding subqueries?（）

    • A、The inner query always sorts the results of the outer query
    • B、The outer query always sorts the results of the inner query
    • C、The outer query must return a value to the outer query
    • D、The inner query returns a value to the outer query
    • E、The inner query must always return a value or the outer query will give an error

    正确答案:E

  • 第6题：

    What is true about sequences? （）

    • A、The start value of the sequence is always 1.
    • B、A sequence always increments by 1.
    • C、The minimum value of an ascending sequence defaults to 1.
    • D、The maximum value of descending sequence defaults to 1.

    正确答案:A

  • 第7题：

    What is true regarding subqueries?（）

    • A、The inner query always sorts the results of the outer query.
    • B、The outer query always sorts the results of the inner query.
    • C、The outer query must return a value to the inner query.
    • D、The inner query returns a value to the outer query.
    • E、The inner query must always return a value or the outer query will give an error.

    正确答案:D

  • 第8题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    What is true regarding subqueries?（）
    A

    The inner query always sorts the results of the outer query

    B

    The outer query always sorts the results of the inner query

    C

    The outer query must return a value to the outer query

    D

    The inner query returns a value to the outer query

    E

    The inner query must always return a value or the outer query will give an error


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

    正确答案:B

  • 第14题：

    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

    正确答案:B

  • 第15题：

    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.

    正确答案:A

  • 第16题：

    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

    正确答案:A,C

  • 第17题：

    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.

    正确答案:B,C

  • 第18题：

    Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）

    • A、The MTTR advisor will be disabled.
    • B、Automatic checkpoint tuning will be enabled.
    • C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.
    • D、The time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.

    正确答案:B,C

  • 第19题：

    You are developing an ASP.NET Web page that will display the median value from a sequence of integer values. You need to create an extension method to compute the median value. Which interface should you add the extension method to？（）

    • A、 IComparer<T>
    • B、 IEnumerable<T>
    • C、 IEnumerator<T>  
    • D、 IEqualityComparer<T>

    正确答案:B

  • 第20题：

    单选题
    What is true about sequences?（）
    A

    The start value of the sequence is always 1.

    B

    A sequence always increments by 1.

    C

    The minimum value of an ascending sequence defaults to 1.

    D

    The maximum value of descending sequence defaults to 1.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    多选题
    Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）
    A

    The MTTR advisor will be disabled.

    B

    Automatic checkpoint tuning will be enabled.

    C

    The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.

    D

    The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.


    正确答案： C,D
    解析： 暂无解析

  • 第22题：

    单选题
    You are developing an ASP.NET Web page that will display the median value from a sequence of integer values. You need to create an extension method to compute the median value. Which interface should you add the extension method to？（）
    A

     IComparer<T>

    B

     IEnumerable<T>

    C

     IEnumerator<T>  

    D

     IEqualityComparer<T>


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）
    A

    20

    B

    25

    C

    50

    D

    55


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

相关内容