多选题Which two statements about sequences are true? （）AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.BYou use a CURRVAL pseudo column to look at the current

题目
多选题
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.

相似考题

1.Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

2. Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）A、 use the @function @decimal in the column formula in the view B、 select decimal on the numbers tab in the view properties box C、 select decimal on the numbers tab in the column properties boxD、 use the @function @decimal to format the value in the field on the form that will display in the view 

3.Which two statements are true regarding views?（）A、A subquery that defines a view cannot include the GROUP BY clause B、A view that is created with the subquery having the DISTINCT keyword can be updated C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

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

更多“多选题Which two statements about sequences are true? （）AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.BYou use a CURRVAL pseudo column to look at the current ”相关问题

  • 第1题：

    Which two statements are true about constraints? （）

    • A、The UNIQUE constraint does not permit a null value for the column.
    • B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
    • C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
    • D、The NOT NULL constraint ensures that null values are not permitted for the column.

    正确答案:B,D

  • 第2题：

    Which two statements are true about a bitmap index？ （）

    • A、It is recommended for the columns that have unique values.
    • B、It can be converted to a B-tree index by using the ALTER INDEX command.
    • C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.
    • D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.

    正确答案:C,D

  • 第3题：

    Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）

    • A、The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
    • B、The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
    • C、All the components may be moved into SYSAUX tablespace.
    • D、All the components may be moved from the SYSAUX tablespace.

    正确答案:A,B

  • 第4题：

    Which two statements are true regarding single row functions?（）

    • A、They accept only a single argument 
    • B、They can be nested only to two levels 
    • C、Arguments can only be column values or constants 
    • D、They always return a single result row for every row of a queried table 
    • E、They can return a data type value different from the one that is referenced

    正确答案:D,E

  • 第5题：

    单选题
    Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）
    A

     use the @function @decimal in the column formula in the view 

    B

     select decimal on the numbers tab in the view properties box 

    C

     select decimal on the numbers tab in the column properties box

    D

     use the @function @decimal to format the value in the field on the form that will display in the view 


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

  • 第6题：

    多选题
    Which two are true about aggregate functions? （）
    A

    You can use aggregate functions in any clause of a SELECT statement.

    B

    You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.

    C

    You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

    D

    You can pass column names, expressions, constants, or functions as parameters to an aggregate function.

    E

    You can use aggregate functions on a table, only by grouping the whole table as one single group.

    F

    You cannot group the rows of a table by more than one column while using aggregate functions.


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

  • 第7题：

    多选题
    Which two statements are true about constraints? （）
    A

    The UNIQUE constraint does not permit a null value for the column.

    B

    A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

    C

    The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

    D

    The NOT NULL constraint ensures that null values are not permitted for the column.


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

  • 第8题：

    多选题
    Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）
    A

    The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.

    B

    The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.

    C

    All the components may be moved into SYSAUX tablespace.

    D

    All the components may be moved from the SYSAUX tablespace.


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

  • 第9题：

    多选题
    Which two statements are true regarding single row functions?（）
    A

    They accept only a single argument

    B

    They can be nested only to two levels

    C

    Arguments can only be column values or constants

    D

    They always return a single result row for every row of a queried table

    E

    They can return a data type value different from the one that is referenced


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

  • 第10题：

    多选题
    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,F
    解析： 暂无解析

  • 第11题：

    Which two are true about aggregate functions? （）

    • A、You can use aggregate functions in any clause of a SELECT statement.
    • B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
    • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
    • D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
    • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
    • F、You cannot group the rows of a table by more than one column while using aggregate functions.

    正确答案:A,D

  • 第12题：

    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.

    正确答案:C,D

  • 第13题：

    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

  • 第14题：

    多选题
    Which three are true regarding the use of outer joins? （）
    A

    You cannot use IN operator in a condition that involves an outerjoin.

    B

    You use (+) on both sides of the WHERE condition to perform an outerjoin.

    C

    You use (*) on both sides of the WHERE condition to perform an outerjoin.

    D

    You use an outerjoin to see only the rows that do not meet the join condition.

    E

    In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.

    F

    You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.


    正确答案： D,E,F
    解析： 暂无解析

  • 第15题：

    多选题
    Which two statements are true about a bitmap index？ （）
    A

    It is recommended for the columns that have unique values.

    B

    It can be converted to a B-tree index by using the ALTER INDEX command.

    C

    It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.

    D

    Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.


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

  • 第16题：

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


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

  • 第17题：

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


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

  • 第18题：

    多选题
    Which two statements are true regarding views?（）
    A

    A subquery that defines a view cannot include the GROUP BY clause

    B

    A view that is created with the subquery having the DISTINCT keyword can be updated

    C

    A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

    D

    A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table


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

  • 第19题：

    多选题
    Which two statements about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true？（）
    A

    You may use Cisco Network Assistant to set up the initial configuration

    B

    You must use CLI for initial configuration

    C

    You may use either CLI or CAN for configuration

    D

    You may make a direct connection to the PC from any point on the switch

    E

    You may only make a direct connection from the port with the flashing green LED to the PC


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

相关内容