CREATE、ALTER、DROP属于 （)

相似题目

• Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）

  A . A syntax error will result as you cannot specify more than one partition in the same statement B . All data in p1 and p3 partitions are removed and the table definition is changed C . All data in p1 and p3 partitions are removed, but the table definition remains unchanged D . Only the first partition (p1) will be dropped as only one can be dropped at any time

  查看最佳答案

• You create a server control that inherits from WebControl. You need to enable the server control to emit markup for a new kind of mobile device. You must not alter the code in the server controls. Which two actions should you perform?（）

  A . Create a class that inherits HtmlTextWriter and that can emit the new markup. B . Create a class that inherits StreamWriter and that can emit the new markup. C . Reference the class in the <capabilities> element of the new device's browser definition file. D . Reference the class in the <controlAdapters> element of the new device's browser definition file.

  查看最佳答案

• Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）

  A . SRW.BREAK  B . SRW.SET_ALTER  C . SRW.REFERENCE  D . SRW.DO_SQL  E . SRW.RUN_REPORT F . SRW.SET_FIELD

  查看最佳答案

• You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）;  Which statement is true？（）

  A . When a file is created in DGROUP1 with the template， it would have three­way mirroring.  B . When a file is created in DGROUP1， the MY_TEMP template becomes the default template. C . When a file is created in DGROUP1 with the template， it would have two­way mirroring and file striping. D . When a file is created in DGROUP1 with the template， it would have three­way mirroring and file striping. E . When a file is created in DGROUP1 with the template， it would have two­way mirroring but no file striping.

  查看最佳答案

• 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

  查看最佳答案

• 默认约束是在CREATE TABLE或ALTER TABLE语句中定义的，删除表的时候默认约束也随之删除了。

  A . 正确 B . 错误

  查看最佳答案

• 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 operation C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E . It adds previously dropped disks back into the disk grou

  查看最佳答案

• CREATE，DROP，ALTER等命令属于下列哪类命令（）

  A . DCL B . DDL C . DML D . DQL E . 以上所述都不正确

  查看最佳答案

• 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.

  查看最佳答案

• 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.

  查看最佳答案

• How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has already completed？（）  

  A .  Issue the ALTER DISKGROUP ... ADD DISK command. B .  Issue the ALTER DISKGROUP ... UNDROP DISKS command.P.... DROP DISK CANCEL command. C .  Issue the ALTER DISKGROU D .  Retrieve the disk from the Recycle Bin after the operation completes.

  查看最佳答案

• 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 operation C .  It mounts disks in the disk group for which the drop-disk operation has already been co pleted D .  It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E .  It adds previously dropped disks back into the disk grou

  查看最佳答案

• You have a disk group， DGROUP1， with three disk and NORMAL redundancy. You execute the following command to create a template for the disk group： ALTER DISKGROUP dgroup1 ADD TEMPLATE my_temp ATTRIBUTES （MIRROR FINE）；Which statement is true？（）

  A .  When a file is created in DGROUP1 with the template， it would have three-way mirroring. B .  When a file is created in DGROUP1， the MY_TEMP template becomes the default template. C .  When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping. D .  When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping. E .  When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file striping.

  查看最佳答案

• 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 complete

  查看最佳答案

• You have a disk group， DGROUP1， with three disks and NORMAL redundancy. You execute the following command to create a template for the disk group：  ALTER DISKGROUP dgroup1  ADD TEMPLATE my_temp  ATTRIBUTES （MIRROR FINE）；  Which statement is true？（）

  A . When a file is created in DGROUP1 with the template， it would have three-way mirroring. B . When a file is created in DGROUP1， the MY_TEMP template becomes the default template. C . When a file is created in DGROUP1 with the template， it would have two-way mirroring and file striping. D . When a file is created in DGROUP1 with the template， it would have three-way mirroring and file striping. E . When a file is created in DGROUP1 with the template， it would have two-way mirroring but no file Striping.

  查看最佳答案

• 在SQL中建立和删除数据库模式的命令分别是create schema和drop schema。（ ）

  查看最佳答案

• SQL语言集数据查询、数据操纵、数据定义和数据控制功能于一体，语句CREATE、 DROP、ALTER实现哪类功能？______。

  A．数据查询 B．数据操纵 C．数据定义 D．数据控制

  查看最佳答案

• Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode？（）1.shutdown immediate from RMAN2.Log into RMAN3.startup mount from RMAN4.backup database5.alter database open6.backup database plus archivelog delete input

  A.2，3，1，4，5 B.2，1，3，6，5 C.1，3，5，4 D.2，1，3，5，6 E.2，1，3，4，5

  查看最佳答案

• CREATE语句属于SQL的（）语言

  A．数据定义语言 B．数据转换语言 C．数据操纵语言 D．数据控制语言

  查看最佳答案

• 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.

  查看最佳答案

• 2、CREATE命令属于（）语句。

  A．数据查询 B．数据操纵 C．数据定义 D．数据控制

  查看最佳答案

• SQL语言集数据查询、数据操纵、数据定义与数据控制功能于一体，语句CREATE, DROP、ALTER实现__功能（）

  A．数据查询 B．数据操纵 C．数据定义 D．数据控制

  查看最佳答案

• 一个程序用pthread_create创建了4个线程，此时系统中属于这个程序的共有（)线程。

  A．4 B．5 C．6 D．7

  查看最佳答案