网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Which command will drop a matching packet and send out a notification message?（）
- A、set routing-options static route 10.1.1.1/32 no-retain
- B、set routing-options static route 10.1.1.1/32 discard
- C、set routing-options static route 10.1.1.1/32 reject
- D、set routing-options static route 10.1.1.1/32 no-install
参考答案
更多 “Which command will drop a matching packet and send out a notification message?（）A、set routing-options static route 10.1.1.1/32 no-retainB、set routing-options static route 10.1.1.1/32 discardC、set routing-options static route 10.1.1.1/32 rejectD、set routing-options static route 10.1.1.1/32 no-install” 相关考题
考题
You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct?()
A. All the objects of scott are moved to the Recycle Bin.B. Any objects in the Recycle Bin belonging to scott are purged.C. All the objects owned by scott are permanently dropped from the database.D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
考题
What is the main reason for using the "ip ips deny-action ips-interface" IOS command？（）A、 To selectively apply drop actions to specific interfacesB、 To enable IOS to droptraffic for signatures configured with the Drop actionC、 To support load-balancing configurations in which traffic can arrive via multipleinterfaces D、 This is nota valid IOS command
考题
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 command： SQL DROP TABLE MYTABLE； SQL SHOW RECYCLEBIN The following output is returned： ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME ------------- ------------------------------ --------------- -------------------- MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE 2005-01-13：20：11：31 You want to drop the table， MYTABLE， from the Recycle Bin. Which two commands can you issue to accomplish the desired task？（）A、 DROP TABLE MYTABLE PURGE；B、 PURGE RECYCLEBIN；C、 PURGE TABLE MYTABLE；D、 PURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0；
考题
You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable： SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about the effect of the command（）A、No flashback is possible to bring back the ITEM table.B、The ORDER table is dropped along with the ITEM table.C、The dependent referential integrity constraints in the ORDER table are disabled.D、The dependent referential integrity constraints in the ORDER table are removed.E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.
考题
You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A、The command produces an error.B、The profile is dropped and current user sessions use the DEFAULT profile immediately.C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
考题
User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A、It fails to delete the records because the records are locked in SHARE mode.B、It deletes the rows successfully because the table is locked in SHARE modeC、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
Which statement is true about FLUSH LOGS command?（）A、It requires the RELOAD, FILE, and DROP privilegesB、It closes and reopens all log filesC、It closes and sends binary log files to slave serversD、It flushes dirty pages in the buffer pool to the REDO logs
考题
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
考题
多选题You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）AAll the objects of scott are moved to the Recycle Bin.BAny objects in the Recycle Bin belonging to scott are purged.CAll the objects owned by scott are permanently dropped from the database.DAll the objects of scott in the Recycle Bin must be purged before executing the DROP command.EAny objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
考题
单选题You want to drop the TBS1 tablespace from your database. You also want to delete the corresponding data files automatically， and not have to do it manually. What should you do？（）A
Use the DROP DATAFILE command.B
Use the DROP TABLESPACE command.C
Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.D
Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
考题
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）A
Issue the ALTER DISKGROUP ... ADD DISK command.B
Issue the ALTER DISKGROUP ... UNDROP DISKS command.C
Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D
Retrieve the disk from the Recycle Bin after the operation completes
考题
单选题What is the main reason for using the "ip ips deny-action ips-interface" IOS command？（）A
To selectively apply drop actions to specific interfacesB
To enable IOS to droptraffic for signatures configured with the Drop actionC
To support load-balancing configurations in which traffic can arrive via multipleinterfaces D
This is nota valid IOS command
考题
单选题You execute the following command to audit database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A
One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.B
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.C
One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.D
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E
One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
考题
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yetcompleted?（）A
Issue the ALTER DISKGROUP ... ADD DISK command.B
Issue the ALTER DISKGROUP ... UNDROP DISKS command.C
Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D
Retrieve the disk from the Recycle Bin after the operation completes.
考题
单选题You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A
Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B
Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C
One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E
One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
考题
单选题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
考题
单选题Which statement is true about FLUSH LOGS command?（）A
It requires the RELOAD, FILE, and DROP privilegesB
It closes and reopens all log filesC
It closes and sends binary log files to slave serversD
It flushes dirty pages in the buffer pool to the REDO logs
考题
单选题You execute the following command to audit the database activities： SQL AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command？（）A
One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.B
One audit record is created for every session when any user successfully drops a table owned by SCOTT.C
One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.D
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.E
One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
考题
单选题User A executes the following command to drop a large table in your database：SQL DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）A
It fails to delete the records because the records are locked in SHARE mode.B
It deletes the rows successfully because the table is locked in SHARE modeC
It fails to delete the records because the table is locked in EXCLUSIVE mode.D
It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
考题
单选题You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A
The command produces an error.B
The profile is dropped and current user sessions use the DEFAULT profile immediately.C
The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D
The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
考题
多选题You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable： SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE； Which two statements are true about the effect of the command（）ANo flashback is possible to bring back the ITEM table.BThe ORDER table is dropped along with the ITEM table.CThe dependent referential integrity constraints in the ORDER table are disabled.DThe dependent referential integrity constraints in the ORDER table are removed.EThe table definition of the ITEM table and associated indexes are placed in the recycle bin.
考题
单选题How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed？（）A
Issue the ALTER DISKGROUP ... ADD DISK command.B
Issue the ALTER DISKGROUP ... UNDROP DISKS command.C
Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.D
Retrieve the disk from the Recycle Bin after the operation completes.
考题
单选题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.
考题
单选题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 group.B
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 co pletedD
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
热门标签
最新试卷
