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 b

题目

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.
相似考题

1.You want to perform the following operations for the DATA ASM disk group:Which command accomplishes these tasks?()A. ALTER DISKGROUP data CHECK;B. ALTER DISKGROUP data CHECK DISK;C. ALTER DISKGROUP data CHECK FILE;D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

2.Which of the following commands should be used to alter the routing table on a running system without affecting the ODM settings？（）A、inetdB、routeC、cfgmgrD、chdev

3.Which of the following commands should be used to show the percentage of time that any given disk was busy？（）A、 psB、 tprofC、 iostatD、 vmstat

4.Which of the following privileges permits a user to update the comment on a sequence?()A.CONTROLB.UPDATEC.USAGED.ALTER

更多“Given the following ALTER SEQUEN”相关问题

  • 第1题：

    Which of the following privileges permits a user to update the comment on a sequence?（）

    • A、CONTROL
    • B、UPDATE
    • C、USAGE
    • D、ALTER

    正确答案:D

  • 第2题：

    Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）  

    • A、 alter tablespace DAVE_TBS backup mode
    • B、 alter tablespace DAVE_TBS start backup
    • C、 alter tablespace DAVE_TBS begin backup
    • D、 alter tablespace DAVE_TBS backup begin
    • E、 alter tablespace DAVE_TBS backup

    正确答案:C

  • 第3题：

    You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

    • A、ALTER DATABASE 
    • B、ALTER SYSTEM 
    • C、ALTER USER 
    • D、ALTER REDO LOG

    正确答案:B

  • 第4题：

    Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（）   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open 

    • A、 a， b， c， d， e， f
    • B、 c， b， a， d， e， f
    • C、 c， b， a， d， f
    • D、 c， a， b， d
    • E、 c， a， e， b， d， f

    正确答案:E

  • 第5题：

    You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）

    • A、DROP TABLE 
    • B、ALTER TABLE 
    • C、RESIZE 
    • D、COALESCE

    正确答案:A

  • 第6题：

    Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（）   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs

    • A、 b， a， c， d， e
    • B、 a， c， b， d， f
    • C、 c， a， b， d， e
    • D、 c， a， b， d， f
    • E、 e， a， b， d， c

    正确答案:D

  • 第7题：

    单选题
    Evaluate the following SQL statements that are issued in the given order：  What would be the status of the foreign key EMP_MGR_FK？（）
    A

     It would be automatically enabled and deferred.

    B

     It would be automatically enabled and immediate.

    C

     It would remain disabled and has to be enabled manually using the ALTER TABLE command.

    D

     It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.


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

  • 第8题：

    单选题
    Given the following routing table entries， which of the following will the next-hop address be for a packet destined for the address 192.168.1.203？（）
    A

    77.0.5.5

    B

    40.40.0.254

    C

    66.40.90.121

    D

    72.40.91.1


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

  • 第9题：

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


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

  • 第10题：

    单选题
    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?（）
    A

    ADD DIRECTORY

    B

    DROP DISK

    C

    RESIZE DISK

    D

    REBALANCE

    E

    ADD FAILGROUP


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

  • 第11题：

    单选题
    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）
    A

      STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    B

      STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    C

      STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；

    D

      STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；


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

  • 第12题：

    单选题
    User A executes the following command to update the TRANS table）  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table：   SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））；  What would happen in this scenario？（）
    A

    The transaction for user A is rolled back.

    B

    The ALTER TABLE command modifies the column successfully.

    C

    The ALTER TABLE command fails due to the resource being busy.

    D

    The ALTER TABLE command waits until user A ends the transaction.


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

  • 第13题：

    You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

    • A、Immediately following statement execution 
    • B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
    • C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
    • D、After the ALTER TABLE MODIFY command is issued

    正确答案:B

  • 第14题：

    The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）

    • A、ALTER USER DEFAULT ROLE ALL
    • B、ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
    • C、ALTER USER DEFAULT ROLE NONE
    • D、ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1

    正确答案:D

  • 第15题：

    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）

    • A、 ALTER DATABASE DROP LOGFILE GROUP 1
    • B、 ALTER DATABASE CLEAR LOGFILE GROUP 1
    • C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1
    • D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

    正确答案:C

  • 第16题：

    You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

    • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
    • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
    • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

    正确答案:D

  • 第17题：

    You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session：   ALTER SESSION ENABLE RESUMABLE；   Which command could you issue to enable the resumable space allocation feature at the session level？（）  

    • A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；
    • B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；
    • C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；
    • D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；

    正确答案:C

  • 第18题：

    单选题
    Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member.  When you attempt to start the database， you receive the following errors：（）
    A

     ALTER DATABASE DROP LOGFILE GROUP 1

    B

     ALTER DATABASE CLEAR LOGFILE GROUP 1

    C

     ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1

    D

     ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’


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

  • 第19题：

    单选题
    Given a complete loss of your database， in what order would you need to perform the following RMAN operations to restore it？（）   a. restore controlfile  b. restore database  c. restore spfile  d. recover database  e. alter database open  f. alter database open resetlogs
    A

     b， a， c， d， e

    B

     a， c， b， d， f

    C

     c， a， b， d， e

    D

     c， a， b， d， f

    E

     e， a， b， d， c


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

  • 第20题：

    单选题
    Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）
    A

     alter tablespace DAVE_TBS backup mode

    B

     alter tablespace DAVE_TBS start backup

    C

     alter tablespace DAVE_TBS begin backup

    D

     alter tablespace DAVE_TBS backup begin

    E

     alter tablespace DAVE_TBS backup


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

  • 第21题：

    单选题
    Which of the following represents the correct way to perform an online recovery of datafile 4， which is assigned to a tablespace called USERS？（）
    A

     shutdown restore datafile 4； recover datafile 4； alter database open；

    B

     Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； alter database open；

    C

     Sql alter database datafile 4 offline； restore datafile 4； Sql alter database datafile 4 online；

    D

     Sql alter database datafile 4 offline； restore database datafile 4； recover database datafile 4；Sql alter database datafile 4 online；

    E

     Sql alter database datafile 4 offline； restore datafile 4； recover datafile 4； Sql alter database datafile 4 online；


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

  • 第22题：

    单选题
    Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（）   a. restore database  b. recover database  c. shutdown immediate  d. startup  e. restore archivelog all f. alter database open
    A

     a， b， c， d， e， f

    B

     c， b， a， d， e， f

    C

     c， b， a， d， f

    D

     c， a， b， d

    E

     c， a， e， b， d， f


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

  • 第23题：

    单选题
    You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）
    A

    DROP TABLE 

    B

    ALTER TABLE 

    C

    RESIZE 

    D

    COALESCE


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

  • 第24题：

    单选题
    You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session：   ALTER SESSION ENABLE RESUMABLE；   Which command could you issue to enable the resumable space allocation feature at the session level？（）
    A

     ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5；

    B

     ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5；

    C

     ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300；

    D

     ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300；


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

相关内容