- 多项选择题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
关注下方微信公众号,在线模考后查看
- Which two statements
- You lost
- Which of
- Given: IfclassDonke
- Which three statemen
- Which action
- The database&e
- 限制从EMP表中只选出前5条记录的查语句
- You are using recov
- After implementing
- Which three statemen
- You need to create
- In your d
- Your database&e
- You issued&ensp
- 假设ABC中的所有列均为字符数据类型,
- Examine the structu
- Which SQL statement
- You plan
- You execute&en