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?（）..

第1题

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.

点击查看答案

第2题

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

点击查看答案

第3题

[] What is true about sequences? （）

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

点击查看答案

第4题

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

点击查看答案

第5题

[单选题] You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A、Create a table view. B、Create a view in any schema. C、Create a view in your schema. D、Create a sequence view in any schema. E、Create a view that is accessible by everyone. F、Create a view only of it is based on tables that you created.

点击查看答案

第6题

[单选题] You are granted the CREATE VIEW privilege. What does this allow you to do? （）

A、Create a table view. B、Create a view in any schema. C、Create a view in your schema. D、Create a sequence view in any schema. E、Create a view that is accessible by everyone. F、Create a view only of it is based on tables that you created.

点击查看答案

第7题

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

点击查看答案

第8题

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

点击查看答案

第9题

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

点击查看答案

请使用微信扫码支付