网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()
A

 INCLUDING DEPENDENCIES

B

 INCLUDING DEPENDENCIES CASCADE

C

 COMPACT

D

 CASCADE

E

 None of the above


参考答案

参考解析
解析: 暂无解析
更多 “单选题When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()A  INCLUDING DEPENDENCIESB  INCLUDING DEPENDENCIES CASCADEC  COMPACTD  CASCADEE  None of the above” 相关考题
考题 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

考题 Which describes the default behavior when you create a table? () A. The table is accessible to all users.B. Tables are created in the public schema.C. Tables are created in your schema.D. Tables are created in the DBA schema.E. You must specify the schema when the table is created.

考题 You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?() A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.

考题 You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()A、 You must enable the block change tracking feature.B、 You must have enable the flashback feature.C、 You must use the OMF in your database.D、 You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

考题 In which scenario do you use the Flashback Database feature?()A、 when a table is dropped and you restore it from the Recycle BinB、 when a user’s schema is dropped and you recover the user’s schemaC、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD、 when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duration

考题 In which scenario will you use the Flashback Transaction Query feature?()A、 when you want to restore an important table that is dropped from the Recycle BinB、 when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC、when you want to restore a dropped user’s schemaD、 when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

考题 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.

考题 In which scenario will you perform a user-managed incomplete recovery?()A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period

考题 When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()A、 INCLUDING DEPENDENCIESB、 INCLUDING DEPENDENCIES CASCADEC、 COMPACTD、 CASCADEE、 None of the above

考题 In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()A、 REBUILDB、 CASCADEC、 TRUNCATED、 ROW MOVEMENTE、 SHRINK SPACE COMPACTF、 SHRINK SPACE CASCADE

考题 In which scenario will you perform an incomplete recovery?()A、 when a table is dropped and stored in the Recycle BinB、 when all the control files are deletedC、 when a member of a multiplexed redo log group is droppedD、 when you are required to recover a table to its previous state

考题 In which situation are you NOT required to perform an incomplete recovery?()A、 when all the control files are lostB、 when all the members of a redo log group are lostC、 when a table is dropped and purged from the Recycle BinD、 when a temporary file of the default temporary tablespace is lost

考题 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 partitionedB、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.

考题 单选题In which scenario do you use the Flashback Database feature?()A  when a table is dropped and you restore it from the Recycle BinB  when a user’s schema is dropped and you recover the user’s schemaC  when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD  when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duration

考题 单选题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 partitionedB 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.

考题 多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?()AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.

考题 单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()A  REBUILDB  CASCADEC  TRUNCATED  ROW MOVEMENTE  SHRINK SPACE COMPACTF  SHRINK SPACE CASCADE

考题 单选题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-only mode during the shrink operation.B The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.C The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.D Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

考题 单选题In which scenario will you perform a user-managed incomplete recovery?()A  when a table is dropped and stored in the Recycle BinB when a table is dropped and purged from the Recycle BinC  when you are required to recover an existing table to its previous stateD  when you are required to view all the versions of a row of an existing table between a specific time period

考题 单选题You issued the following command:   ALTER TABLE SCOTT.EMP SHRINK SPACE;   The SCOTT.EMP table is stored in the DATA1 tablespace that has the following properties:   DATA1 is a read/write tablespace.   DATA1 is not autoextensible to an unlimited size.  DATA1 is online.   Segment space management for the DATA1 tablespace is manual.   You issued the ALTER TABLE SCOTT.EMP SHRINK SPACE; command that generates the following error:   ORA-10635: Invalid segment or tablespace type    What could be the reason for the failure of the command?()A  The tablespace, DATA1, is not read-only.B  The tablespace, DATA1, is not autoextensible.C  The tablespace, DATA1, is not offline.D  The segment space management for the tablespace, DATA1, is manual.

考题 单选题You are performing the shrink operation on the SCOTT.EMP table. You want to perform the same operation on all dependent objects of the SCOTT.EMP table. What is NOT a prerequisite for the operation?()A  You must enable the row movement on the SCOTT.EMP table.B  You must define the tablespace of the SCOTT.EMP table for automatic segment space management.C  You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.D  You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

考题 单选题You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()A  You must enable the block change tracking feature.B  You must have enable the flashback feature.C  You must use the OMF in your database.D  You must define the tablespace of the SCOTT.EMP table for automatic segment space management.

考题 单选题In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective?()A REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE

考题 单选题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.

考题 单选题In which scenario will you perform an incomplete recovery?()A  when a table is dropped and stored in the Recycle BinB  when all the control files are deletedC  when a member of a multiplexed redo log group is droppedD  when you are required to recover a table to its previous state

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

考题 单选题In which scenario will you use the Flashback Transaction Query feature?()A  when you want to restore an important table that is dropped from the Recycle BinB  when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transactionC when you want to restore a dropped user’s schemaD  when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period