网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
What is the net effect of the following command？（） alter diskgroup dgroup1 drop disk abc；
A
The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.
B
The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
C
The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.
D
This command will fail because you cannot drop a specific disk in an ASM disk group.
E
The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.
参考答案
参考解析
解析：
暂无解析
更多 “单选题What is the net effect of the following command？（） alter diskgroup dgroup1 drop disk abc；A The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.B The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.C The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.D This command will fail because you cannot drop a specific disk in an ASM disk group.E The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.” 相关考题
考题
What are the basic configuration steps to enable IS - IS?（）A、Configure the net system - id command under routerisis and enable IS - IS on each interface with the ip router isis command.B、Configure the net sy stem - id and the network net - id commands under routerisis.C、Configure the network net - id command(s) under routerisis and enable IS - IS on each interface with the ip router isis command.D、Configure the network net - id command(s) and the is - type level -1- 2 command under routerisis.E、Configure the net system - id and the network net - id commands under routerisis and enable ISIS on each interface with the ip router isis command.
考题
You execute the following command to change the status of the SALES tablespace： SQL ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.
考题
Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command？（）A、The command would return an error because LOG_BUFFER is a static parameter.B、The parameter value would be changed and it would come into effect immediately.C、You need to restart the database so that parameter changes can come into effect.D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.
考题
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A、Image of the control fileB、Location of the control fileC、Contents of the control file in text formatD、SQL command to re-create the databaseE、SQL command to re-create the control fileF、Contents of the control file in binary format
考题
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
考题
You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）A、The database instance is not available.B、The ALTER TABLE command does not have WAIT optionC、The table or a row in the table is currently locked by another user session.D、The database instance is busy processing other user sessions commands.E、The CUSTOMERS table has no long running query active at the time when this request is made.F、The server process executing the ALTER TABLE command is busy with another command execution
考题
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
考题
our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A、The command succeeds only if Automatic Memory Management is not enabled.B、The command succeeds， but you need to restart the database for changes to take effect.C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.D、The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）
考题
You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B、 The command will not execute successfully because resumable space allocation is enabled at the session level.C、 The command will execute successfully and resumable space will be allocated at the session level.D、 The command will execute successfully and resumable space will be allocated at the instance level.
考题
our database is in the MOUNT state and you execute the following command to open it： ALTER DATABASE OPEN What two actions are performed as a result of this command？（）A、All control files are opened.B、All redo log files are openedC、The password file is opened.D、The parameter file is opened.E、All online data files are opened.
考题
You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）A、Flashback logs are not deleted.B、Flashback logs are deleted automatically.C、Flashback logs are deleted only if you are using Recovery Manager （RMAN）.D、Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.E、Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.
考题
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.
考题
You execute the following command to change the status of the SALES tablespace：SQL ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）A、The tablespace would require recovery to go back online.B、A checkpoint is taken on all data files that are associated with the SALES tablespace.C、The sessions that subsequently try to access the objects in the SALES tablespace receive an errorD、The new status of the SALES tablespace is recorded in the control file when the database instance isclosed
考题
Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）A、It cancels all pending disk drops within the disk groupB、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been completedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group
考题
多选题our database is in the MOUNT state and you execute the following command to open it： ALTER DATABASE OPEN What two actions are performed as a result of this command？（）AAll control files are opened.BAll redo log files are openedCThe password file is opened.DThe parameter file is opened.EAll online data files are opened.
考题
单选题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
考题
单选题You issued the following statement： SQLALTER DATABASE ENABLE RESUMABLE TIMEOUT n； What will be the result of issuing the above statement？（）A
The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.B
The command will not execute successfully because resumable space allocation is enabled at the session level.C
The command will execute successfully and resumable space will be allocated at the session level.D
The command will execute successfully and resumable space will be allocated at the instance level.
考题
单选题View the Exhibit and examine the parameters. 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 onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A
The ALTER TABLE command modifies the column successfully.B
The DDL operation gets higher priority and transaction for user a is rolled back.C
The ALTER TABLE command waits indefinitely until user a ends the transaction.D
The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
考题
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF； What would be the effect of this command on the existing flashback logs？（）A
Flashback logs are not deleted.B
Flashback logs are deleted automatically.C
Flashback logs are deleted only if you are using Recovery Manager （RMAN）D
Flashback logs are deleted only if you are using Oracle Manager Files （OFM）E
Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
考题
单选题our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A
The command succeeds only if Automatic Memory Management is not enabled.B
The command succeeds， but you need to restart the database for changes to take effect.C
The command returns an error because the size of the redo log buffer cannot be changed dynamically.D
The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）
考题
单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）A
The database instance is not available.B
The ALTER TABLE command does not have WAIT optionC
The table or a row in the table is currently locked by another user session.D
The database instance is busy processing other user sessions commands.E
The CUSTOMERS table has no long running query active at the time when this request is made.F
The server process executing the ALTER TABLE command is busy with another command execution
考题
单选题You disabled the Flashback Database feature by using the following command： SQL ALTER DATABASE FLASHBACK OFF; What would be the effect of this command on the existing flashback logs？（）A
Flashback logs are not deleted.B
Flashback logs are deleted automatically.C
Flashback logs are deleted only if you are using Recovery Manager （RMAN）.D
Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.E
Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.
考题
单选题You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）A
Image of the control fileB
Location of the control fileC
Contents of the control file in text formatD
SQL command to re-create the databaseE
SQL command to re-create the control fileF
Contents of the control file in binary format
考题
单选题Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）A
The command succeeds only if Automatic Memory Management is not enabled.B
The command succeeds， but you need to restart the database for changes to take effect.C
The command returns an error because the size of the redo log buffer cannot be changed dynamically.D
The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.
考题
单选题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.
考题
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A
The alter database archivelog command will failB
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC
The alter database archivelog command will succeedD
The alter database archivelog command will ask if you want to make the database consistent firstE
There is no alter database archivelog command. The correct command is alter database alterlogging
考题
多选题You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）AAll control files are openedBAll redo files are openedCThe password file is openedDThe parameter file is openedEAll online data files are opened
热门标签
最新试卷
