单选题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 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 opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?()A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

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.

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX:   SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE;   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation?() A、 Index-organized tableB、 Mapping TableC、 Clustered TableD、 Journal Table

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?()A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued

You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?()A、All data along with the table structure is deleted B、The pending transaction in the session is committed C、All indexes on the table will remain but they are invalidated D、All views and synonyms will remain but they are invalidated E、All data in the table are deleted but the table structure will remain

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.

You issued the following command to analyze the SCOTT.EMP table for block corruption:   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE;  You received the following error:   ORA-01578: ORACLE data block corrupted  (file # %s, block # %s)   How will you resolve the block corruption problem?()A、 by using the DBMS_REPAIR packageB、 by using the DB_BLOCK_CHECKING parameterC、 by using the DBVERIFY utilityD、 will not be completely resolved until the hardware fault is corrected

You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?()A、DROP TABLE B、ALTER TABLE C、RESIZE D、COALESCE

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.

Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?()A、It produces an error because data already exists in the table.B、It produces an error because compression can be enabled at table creation only.C、It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.D、It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table: SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’;  Before user A issues a COMMIT or ROLLBACK command, user B executes the following command onthe TRANS table:  SQL ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));  What would happen in this scenario()A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user a is rolled back.C The ALTER TABLE command waits indefinitely until user a ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.

单选题View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable: SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’; Before user A issues a COMMIT orROLLBACK command, user B executes the following command on the TRANS table: SQL ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));  What would happen in this scenario()A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user A is rolled back.C The ALTER TABLE command waits indefinitely until user A ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

多选题You issued the following command:        SQL DROP TABLE MYTABLE;        SQL SHOW RECYCLEBIN  The following output is returned:        ORIGINAL NAME RECYCLEBIN NAME               OBJECT TYPE      DROP TIME        ------------- ------------------------------ --------------- --------------------        MYTABLE BIN$04LhcpndanfgMAAAAAANPw==$0     TABLE           2005-01-13:20:11:31  You want to drop the table, MYTABLE, from the Recycle Bin. Which two commands can you issue to accomplish the desired task?()ADROP TABLE MYTABLE PURGE;BPURGE RECYCLEBIN;CPURGE TABLE MYTABLE;DPURGE TABLE BIN$04LhcpndanfgMAAAAAANPw==$0;

单选题Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?()AIt produces an error because data already exists in the table.BIt produces an error because compression can be enabled at table creation only.CIt compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.DIt immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

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

单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()ABecause row IDs may change during the flashback operationBBecause the object number changes after the flashback operationCBecause the rows are retrieved from the recycle bin during the flashback operationDBecause the table is moved forward and back to a temporary during the flashback operation

单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX:   SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE;   Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation?()A Index-organized tableB Mapping TableC Clustered TableD Journal Table

多选题You issued the following command to drop the PRODUCTS table: SQL DROP TABLE products; What is the implication of this command?()AAll data along with the table structure is deletedBThe pending transaction in the session is committedCAll indexes on the table will remain but they are invalidatedDAll views and synonyms will remain but they are invalidatedEAll data in the table are deleted but the table structure will remain

单选题You issued the following command to analyze the SCOTT.EMP table for block corruption:   ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE;  You received the following error:   ORA-01578: ORACLE data block corrupted  (file # %s, block # %s)   How will you resolve the block corruption problem?()A by using the DBMS_REPAIR packageB by using the DB_BLOCK_CHECKING parameterC by using the DBVERIFY utilityD will not be completely resolved until the hardware fault is corrected

单选题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?()ACREATE SYNONYM ord FOR orders; This command is issued by OE BCREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE CCREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator DCREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator

单选题One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table, he should get the highest priority. Which method would you use to overcome this problem?()Aexecute the command, ALTER SESSION KILL .., to kill the blocking sessionBexecute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionCexecute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking sessionDexecute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking sessionEexecute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session

单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table: ALTER TABLE customers  MODIFY (cust_nameVARCHAR2 (40)) /  When you execute the command, it displays the following error message:  ERROR at line 1:  ORA-00054: resource busy and acquire with NOWAIT specified  What could be the reason for the error message?()AThe database instance is not available.BThe ALTER TABLE command does not have WAIT optionCThe table or a row in the table is currently locked by another user session.DThe database instance is busy processing other user sessions commands.EThe CUSTOMERS table has no long running query active at the time when this request is made.FThe server process executing the ALTER TABLE command is busy with another command execution

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

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

单选题You opened the encryption wallet and then issued the following command:   SQLCREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M  ENCRYPTION USING ’3DES168’ DEFAULT STORAGE(ENCRYPT);   Then you closed the wallet. Later, you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.  What is the outcome?()A It creates the table and encrypts the data in it.B It generates an error because the wallet is closed.C It creates the table but does not encrypt the data in it.D It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

单选题User A executes the following command to update the TRANS table)  SQL UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’;  Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:   SQl ALTER TABLE trans MODIFY (tr_type VARCHAR2 (3));  What would happen in this scenario?()AThe transaction for user A is rolled back.BThe ALTER TABLE command modifies the column successfully.CThe ALTER TABLE command fails due to the resource being busy.DThe ALTER TABLE command waits until user A ends the transaction.

多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block