单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A The EMPLOYEES table will be changed to read-onl

题目内容(请给出正确答案)

单选题

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

The EMPLOYEES table will be changed to read-only mode during the shrink operation.

The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You created the DEPT table by using the following command： CREATE TABLE scott.dept （deptno NUMBER（3）， dname VARCHAR2（15）， loc VARCHAR2（15）） STORAGE （INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）AIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.BIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.CIssue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.DYou cannot shrink the SCOTT.EMP table.

点击查看答案
第2题

单选题Examine the following command： SQL> ALTER TABLE booking SHRINK SPACE COMPACT； Which activity is performed when the preceding command is executed？（）AThe shrink operation touches every block in the BOOKING tableBThe high-water mark （HWM） for the BOOKING table is shifted from its original positionCThe progress of the shrink operation is saved in the bitmap blocks of the BOOKING tableDThe data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation

点击查看答案
第3题

单选题You created the ORDERS table in your database by using the following code： SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）； Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）； SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）； SQL> COMMIT； Next， you issued the following statement to change the time zone for the database： SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’； What will be the result of executing the above statement？（）AThe statement will fail.BThe statement will be executed successfully， and the new time zone will be set for the database.CThe statement will be executed successfully， but the new time zone will be set for the current session.D The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

点击查看答案
第4题

单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）A When view V1 is createdB Each time the REFRESH VIEW v1 statement is executedC Each time an SQL statement is executed against view V1D Only the first time an SQL statement is executed against view V1

点击查看答案
第5题

单选题You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）A The data in the segment will be compacted but the high water mark will not be adjusted B The EMPLOYEES table will be changed to read-only mode during the shrink operation C The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is overD The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation E Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation

点击查看答案
第6题

单选题You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL>@utlu111i.sql Which statement about the execution of this script is true？（）AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

点击查看答案
第7题

多选题You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）AEvery SQL statement in the STS is considered only once for execution.BThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.CThe execution plan and execution statistics are computed for each SQL statement in the STS.DThe effects of DDL and DML are considered to produce the execution plan and execution statistics.

点击查看答案

You executed the following SQL statement to shrink the EMPLO

题目内容(请给出正确答案)

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容