网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Which three descriptions are correct about the effects of the TRUNCATE command on a table()
- A、The corresponding indexes for the table are also truncated.
- B、Delete triggers on the table are fired during the execution of the TRUNCATE command.
- C、The child table is truncated when the TRUNCATE command is applied on the parent table.
- D、The high-water mark (HWM) is set to point to the first usable data block in the table segment.
- E、No undo or very little undo data is generated during the execution of the TRUNCATE command
参考答案
更多 “Which three descriptions are correct about the effects of the TRUNCATE command on a table()A、The corresponding indexes for the table are also truncated.B、Delete triggers on the table are fired during the execution of the TRUNCATE command.C、The child table is truncated when the TRUNCATE command is applied on the parent table.D、The high-water mark (HWM) is set to point to the first usable data block in the table segment.E、No undo or very little undo data is generated during the execution of the TRUNCATE command” 相关考题
考题
如果要删除Student数据库中的Information表,可以使用下列哪个命令?一——A.ALTER TABLE InformationB.TRUNCATE TABLE InformationC.DROP。TABLE InformationD.DELETE TABLE Information
考题
View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?()A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
考题
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()
A. Drop the table.B. Partition the tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.
考题
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? ()
A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
考题
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?()
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
考题
如果要删除A数据库中的B表,可以使用下列哪个命令?______A.ALTER TABLE BB.TRUNCATE TABLE BC.DROP TABLE BD.DELETE TABLE B
考题
关于Truncate table, 以下()描述是错误的。A、Truncate table 可跟Where从句,根据条件进行删除B、Truncate table 用来删除表中所有数据C、触发器对Truncate table无效D、delete 比Truncate table速度快
考题
删除emp表的全部数据,但不提交,以下正确的语句是()A、DELETE * FROM. EMPB、DELETE FROM EMPC、TRUNCATE TABLE EMPD、DELETE TABLE EMP"
考题
如下能正确执行的语句是()A、select * from table_name where 1=2B、truncate table table_nameC、delete from table_name where null=nullD、alter table table_name add column idd int
考题
关于Truncatetable,以下()描述是正确的。A、Truncate table 可跟Where从句,根据条件进行删除B、Truncate table 用来删除表中所有数据C、触发器对Truncate table无效D、delete 比Truncate table速度快
考题
若要删除book表中所有数据,以下语句错误的是()A、truncate table bookB、delete * from bookC、drop table bookD、delete from book
考题
You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()A、Drop the table.B、Partition the tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.
考题
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()A、ALTER TABLE SPLIT PARTITIONB、ALTER TABLE MERGE PARTITIONC、ALTER TABLE TRUNCATE PARTITIOND、ALTER TABLE ADD PARTITIONE、ALTER TABLE DROP PARTITIONF、ALTER TABLE MOVE PARTITION
考题
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?() A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.
考题
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()A、UPDATE TABLEB、CREATE CLUSTERC、TRUNCATE TABLED、ALTER TABLE MOVEE、INSERT INTO···VALUESF、ALTER TABLE···DROP COLUMNG、ALTER TABLE···DROP PARTITION
考题
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? ()A、It releases the storage space used by the table.B、It does not release the storage space used by the table.C、You can roll back the deletion of rows after the statement executes.D、You can NOT roll back the deletion of rows after the statement executes.E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
考题
Which statements are correct regarding indexes? ()A、 When a table is dropped, the corresponding indexes are automatically dropped.B、 For each DML operation performed, the corresponding indexes are automatically updated.C、 Indexes should be created on columns that are frequently referenced as part of an expression.D、 A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.
考题
You have just performed a FLASHBACK TABLE operation using the following command: flashback table employees to scn 123456; The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?() A、 All the triggers are disabled.B、 All the triggers are enabled by default.C、 Enabled triggers remain enabled and disabled triggers remain disabled.D、 Triggers are deleted when a Flashback Table operation is performed.
考题
单选题You have just performed a FLASHBACK TABLE operation using the following command: flashback table employees to scn 123456; The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?()A
All the triggers are disabled.B
All the triggers are enabled by default.C
Enabled triggers remain enabled and disabled triggers remain disabled.D
Triggers are deleted when a Flashback Table operation is performed.
考题
多选题Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?()AALTER TABLE SPLIT PARTITIONBALTER TABLE MERGE PARTITIONCALTER TABLE TRUNCATE PARTITIONDALTER TABLE ADD PARTITIONEALTER TABLE DROP PARTITIONFALTER TABLE MOVE PARTITION
考题
单选题You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?()A
Drop the table.B
Partition the table.C
Truncate the table.D
Add a column to the table.E
Rename a column in the table.
考题
多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table()AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark (HWM) is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command
考题
多选题关于Truncate table, 以下()描述是错误的。ATruncate table 可跟Where从句,根据条件进行删除BTruncate table 用来删除表中所有数据C触发器对Truncate table无效Ddelete 比Truncate table速度快
热门标签
最新试卷