单选题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 t

题目

单选题

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 data in the segment will be compacted but the high water mark will not be adjusted

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 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.sqlWhich statement about the execution of this script is true?（）

A. It must be executed from the Oracle Database 11g environment.

B. It must be executed only after the SYSAUX tablespace has been created.

C. It must be executed from the environment of the database that is being upgraded.

D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

参考答案：C

第2题：

You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance： SQL> ALTER SYSTEM SWITCH LOGFILE； Which two tasks are performed when the statement is executed？（）

A、 The DBWn process writes to the datafile.
B、 Changes in the background process are recorded.
C、 The log file is updated with the current SCN number.
D、 The System Change Number （SCN） is recorded in the control file.
E、 The changes to the listener configuration in the listener.ora file are recorded.

正确答案:A,D

第3题：

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 adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

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

参考答案：B

第4题：

Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）

A、The table is moved to the SYSAUX tablespace.
B、The table is moved to the SYSTEM tablespace.
C、The table is removed from the database permanently.
D、The table is renamed and remains in the TBSFD tablespace.

正确答案:D

第5题：

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？（）

A、 It must be executed from the Oracle Database 11g environment.
B、 It must be executed only after the SYSAUX tablespace has been created.
C、 It must be executed from the environment of the database that is being upgraded.
D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

正确答案:C

第6题：

Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1()

A.0

B.1

C.3

D.6

参考答案：D

第7题：

When does a transaction complete?（）

A、when a DELETE statement is executed
B、when a ROLLBACK command is executed
C、when a PL/SQL anonymous block is executed
D、when a data definition language (DDL) statement is executed
E、when a TRUNCATE statement is executed after the pending transact ion

正确答案:B,D,E

第8题：

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?（）

A.Every SQL statement in the STS is considered only once for execution

B.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics

C.The execution plan and execution statistics are computed for each SQL statement in the STS

D.The effects of DDL and DML are considered to produce the execution plan and execution statistics

参考答案：A, C

第9题：

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？（）

A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
D、 You cannot shrink the SCOTT.EMP table.

正确答案:D

第10题：

You work as a database administrator for Supportcenter.cn. Because of space constraints， you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows： ERROR at Line 1： ORA-10635： Invalid segment or tablespace type What could be the reason？（）

A、The table is partitioned
B、The table name is wrong.
C、It is an index-Organized table （IOT）
D、The table is stored in locally managedtablespace.
E、The table is stored in atablespacewhere segment space is managed manually.

正确答案:E

You executed the following SQL statement to shrink the EMPLO

题目

相似问题和答案

更多相关问题

相关内容