多选题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
多选题
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 statement is true about loading data using the conventional path of SQL*Loader（）ARedo is not generated while performing conventional path loads.BOnly PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.CNo exclusive locks are acquired when the conventional path loads are performed.DInstead of performing transactions， SQL*Loader directly writes data blocks to the data files.EINSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
多选题Which two kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist（）Afailure when no standby database is configuredBfailure because a data file is renamed accidentallyCfailure that requires no archive logs to be applied for recoveryDfailure due to loss of connectivity-for example， an unplugged disk cable
单选题You executed the following command to perform a backup of the USERS tablespace：SQL ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）AThe MTTR Advisor is disabled.BThe database is in NOARCHIVELOG mode.CThe tablespace is already in backup mode.DThe Flash Recovery Area is not configured
单选题Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.A1 and 3B2， 3， and 5C1， 2， and 3D2， 3， 4， and 5
单选题In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information. What action would you take to achieve this task（）AApply fine-grained auditing.BImplement value-based auditing.CImpose standard database auditing to auditobject privileges.DImpose standard databaseauditing to audit SQL statements.
多选题Which two operations can be performed on an external table（）ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the table using the DELETE command.
单选题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（）AIt fails to delete the records because the records are locked in SHARE mode.BIt deletes the rows successfully because the table is locked in SHARE modeCIt fails to delete the records because the table is locked in EXCLUSIVE mode.DIt deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
多选题After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL ALTER DATABASE OPEN； Which two statements are true（）AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked
多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）AYou must shut down the database instance to perform the backups.BYou must configure the Flash Recovery Area （FRA） for the database.CYou can perform complete database backups without closing the database.DAll the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.
单选题You are managing an Oracle Database 11g database with this backup strategy： - Every Sunday night， level 0 backup is performed. - On Monday night and subsequent days， level 1 incremental backup is performed. The backups are not cumulative incremental. Which statement about Monday’s backup is true（）AThe backup contains all the used blocks.BThe backup contains all the used and unused blocks.CThe backup contains blocks that have changed since the last level 0 backup.DThe backup contains blocks that have changed since the last level 1 backup taken last week.