题目

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.

答案
查看答案
相关试题

安装WINDOWS2000前,要检查下列哪些项目()

A、与UPS之间的连接

B、第三方软件

C、防病毒软件

D、主板BIOS

A customer reports that error messages occasionally appear and quickly disappear. Which of thefollowing is the BEST place for a technician to begin troubleshooting this issue?()

A、Run a System Restore

B、Check Device Manager

C、Check the Event Logs

D、Check the System Information

有三个关系表R、S和T如下,其中三个关系对应的关键字分别为A,B和复合关键字(A,B)。表T的记录项(b,q,4)违反了(  )。

A、实体完整性约束

B、参照完整性约束

C、用户定义的完整性约束

D、关系完整性约束

Identify three situations in which you would NOT be able to drop a tablespace. ()

A

when the tablespace is online

B

when the tablespace has segments with data in it

C

when the tablespace is a default permanent tablespace for the database

D

when the tablespace contains a table that is currently being used by transactions

E

when the tablespace contains undo data that is needed to rollback an uncommitted transaction

You have executed this command to change the size of the database buffer cache: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582; System altered.  To verify the change in size, you executed this command: SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE  ------------------- ----------- ------------------  db_cache_size big integer 4194304  (4M)  Why is the value set to 4194304 and not to 2516582()

A、because 4194304 is the granule size

B、because 4194304 is the standard block size

C、because 4194304 is the largest nonstandard block size defined in the database

D、because 4194304 is the total size of data already available in the database buffer cache

最新解答的试题
提出现代生物-心理-社会医学模式是()

A.恩格尔B.波特C.托马斯·帕茨瓦尔D.比彻尔E.桑德斯
付款人在进行付款时无()

A.形式审查义务

B.实质审查义务

C.附带审查义务

D.票据外有关事项的审查义务
根据《公司法》的规定,有限责任公司下列人员中,可以提议召开股东会临时会议的是()。
A.总经理B.人数过半数的股东C.监事会主席D.人数为半数的董事
关于股份有限公司中的监事会,下列说法错误的是()

A.监事会负责提议聘请或更换外部审计机构B.监事会主席和副主席由全体监事过半数选举产生C.监事会中的职工代表的比例不得低于三分之一D.监事会应至少每6个月召开一次会议
三北精神的科学内涵