网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
You are managing an ASM instance. You previously issued the following statements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops that are pending for the DG1 disk group.Which statement should you issue?（）A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;B. ALTER DISKGROUP dg1 UNDROP;C. ALTER DISKGROUP dg1 UNDROP DISKS;D. You cannot cancel the pending disk drops.
考题
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?（）A.2B.3C.11D.30
考题
Which of the following is a characteristic of a sequence?()
A.A sequence will never generate duplicate valuesB.The MAXVALUE of a sequence can be equal to the MINVALUEC.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD.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
考题
Which of the following privileges permits a user to update the comment on a sequence?()
A.CONTROLB.UPDATEC.USAGED.ALTER
考题
Which of the following is a characteristic of a sequence?（）A、A sequence will never generate duplicate valuesB、The MAXVALUE of a sequence can be equal to the MINVALUEC、It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD、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
考题
要删除“雇员标识序列”序列，应使用以下哪条语句（）A、DELETE SEQUENCE雇员标识序列B、DROP SEQUENCE雇员标识序列C、ALTER SEQUENCE雇员标识序列D、REMOV ESEQUENCE雇员标识序列
考题
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?（）A、2B、3C、11D、30
考题
Which of the following privileges permits a user to update the comment on a sequence?（）A、CONTROLB、UPDATEC、USAGED、ALTER
考题
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
考题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A、 2， 7， 3， 5， 1， 6， 4B、 2， 1， 7， 6， 3， 5， 4C、 7， 1， 3， 2， 6， 5， 4D、 7， 2， 3， 1， 4， 6， 5
考题
You issued the following statement： SQL ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（） A、 The control file will be multiplexed.B、 The control file will be recreated.C、The script containing the CREATE CONTROLFILE statement will be created.D、 The binary backup of the control file will be created.
考题
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
考题
When performing an online backup，what is the proper order of the following steps？（） a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command. d. Back up the database files. e. Determine the beginning log sequence number. f. Determine the ending log sequence number. g. Force a log switch with the alter system switch logfile command.A、a， b， c， d， e， f， gB、c， d， a， b， e， g， fC、f， d， b， g， a， c， eD、e， c， d， a， g， f， bE、a， f， b， g， e， c， d
考题
Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（） A、 ALTER SYSTEM KILL SESSIONB、 ALTER SYSTEM DISCONNECT SESSIONC、 ALTER SYSTEM QUIESCE RESTRICTEDD、 ALTER SYSTEM ENABLE RESTRICTED SESSION
考题
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；
考题
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
考题
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）A、Shut down the database.B、Set the appropriate parameters in init.ora file.C、Start the database in NOMOUNT state.D、Issue the ALTER DATABASE ARCHIVELOG command.E、Open the database.F、Take a full closed backup.
考题
单选题Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement： SQL ALTER DATABASE SET TIME_ZONE =’Europe/London’； What will be the result of issuing the above statement？（）A
The statement will be executed successfully， and a new time zone will be set for the database.B
The statement will be executed successfully， but a new time zone will not be set for the database.C
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.D
The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
考题
单选题Which of the following is a characteristic of a sequence?（）A
A sequence will never generate duplicate valuesB
The MAXVALUE of a sequence can be equal to the MINVALUEC
It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zeroD
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
考题
单选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file： 1.RESTORE CONTROLFILE； 2.RESTORE DATABASE； 3.ALTER DATABASE MOUNT； 4.SQL ALTER TABLESPACE temp ADD TEMPFILE 5.ALTER DATABASE OPEN RESETLOGS； 6.RECOVER DATABASE； 7.STARTUP NOMOUNT； In what sequence would you use this process to perform the recovery？（）A
2， 7， 3， 5， 1， 6， 4B
2， 1， 7， 6， 3， 5， 4C
7， 1， 3， 2， 6， 5， 4D
7， 2， 3， 1， 4， 6， 5
考题
单选题Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）A
Shut down the database.B
Set the appropriate parameters in init.ora file.C
Start the database in NOMOUNT state.D
Issue the ALTER DATABASE ARCHIVELOG command.E
Open the database.F
Take a full closed backup.
考题
单选题You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this： 1. Set the retention target： SQL ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320； 2. Enable Flashback Database： SQL ALTER DATABASE FLASHBACK ON； 3. Mount the database： SQL STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance： SQL SHUTDOWN IMMEDIATE 5. Open the database： SQL ALTER DATABASE OPEN； Choose the correct sequence.（）A
4， 1， 3， 2， 5B
4， 3， 1， 2， 5C
2， 4， 3， 5， 1D
4， 2， 5， 3， 1
考题
单选题You are managing an ASM instance. You previously issued the following statements： ALTER DISKGROUP dg1 DROP DISK disk2； ALTER DISKGROUP dg1 DROP DISK disk3； ALTER DISKGROUP dg1 DROP DISK disk5； You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue？（）A
ALTER DISKGROUP dg1 UNDROP disk2，disk3，disk5B
ALTER DISKGROUP dg1 UNDROPC
ALTER DISKGROUP dg1 UNDROP DISKSD
You cannot cancel the pending disk drops
考题
单选题Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery： RMAN RUN { 2 SET UNTIL SEQUENCE 230 THREAD 1； 3 ALTER DATABASE MOUNT； 4 RESTORE DATABASE； 5 RECOVER DATABASE； 6 ALTER DATABASE OPEN RESETLOGS； 7 }； With reference to this scenario， which statement is true？（）A
RMAN recovers up to log sequence 230， but not including 230.B
RMAN returns an error because the log sequence number mentioned in the command should be 229.C
RMAN returns an error because the log sequence number mentioned in the command may never be missing.D
RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.
考题
单选题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；
考题
单选题When performing an online backup，what is the proper order of the following steps？（） a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command. d. Back up the database files. e. Determine the beginning log sequence number. f. Determine the ending log sequence number. g. Force a log switch with the alter system switch logfile command.A
a， b， c， d， e， f， gB
c， d， a， b， e， g， fC
f， d， b， g， a， c， eD
e， c， d， a， g， f， bE
a， f， b， g， e， c， d
考题
单选题Which statement must you issue to an already-running Automatic Storage Management （ASM） instance to prevent database instances from connecting to the ASM instance？（）A
ALTER SYSTEM KILL SESSIONB
ALTER SYSTEM DISCONNECT SESSIONC
ALTER SYSTEM QUIESCE RESTRICTEDD
ALTER SYSTEM ENABLE RESTRICTED SESSION
热门标签
最新试卷