Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA/x7f01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、drop and recreate the indexB、coalesce the ORDERS_IND indexC、coalesce the INDEXES tablespaceD、drop and recreate the ORDERS tableE、rebuild the index online and move it to another tablespace
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA/x7f01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
- A、drop and recreate the index
- B、coalesce the ORDERS_IND index
- C、coalesce the INDEXES tablespace
- D、drop and recreate the ORDERS table
- E、rebuild the index online and move it to another tablespace
相关考题：
Exhibit:BULK INSERT Ezonexam.dbo.employeesFROM ‘tk\africe\fubar512.txt’WITH DATAFILETYPE = ‘char’,FIELD/TERMINATOR = ‘\t’,ROWTERMINATOR = ‘\n,’TABLOCKYou work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.How should you improve the performance of the query in the exhibit above?A. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 5 percent of the number of rows to be loaded.B. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 10 percent of the number of rows to be loaded.C. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 5 percent of the number of rows to be loaded.D. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 10 percent of the number of rows to be loaded.E. Insert a line before the BULK INSERT statement that drops the indexes for the customers table. Insert a line after the BULK INSERT statement that recreates the indexes for the customers table.F. The TABLOCK option should be removed.G. The ROWTERMINATOR line should be removed.
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（）A、The MTTR Advisor is disabled.B、The database is in NOARCHIVELOG mode.C、The tablespace is already in backup mode.D、The Flash Recovery Area is not configured.
The user HR receives the following error while inserting data into the TTK table： ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon investigation， you find that SMD is a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A、Oracle Data Pump.B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D、Online Table Redefinition.E、Edition-Based Table Redefinition.
A user sends you an email with the following error message： create table idtable（id number） * ERROR at line 1： ORA- 01110： data file 4： ，，/oracle01/oradata/orcl/users01.dbf ORA-27041： 01116： error in opening database file 4 ORA-unable to open file Linux Error： 2： No such file or directory Additional information： 3 You can choose from the following steps： a. Restore the missing database datafiles. b. Take the missing datafile offline. c. Shut down the database. d. Issue the recover tablespace USERS command. e. Issue the Startup Mount command to mount the database. f. Bring the USERS tablespace online. g. Issue the alter database open command. Which is the correct order of these steps in this case？（）A、b， a， d， fB、c， a， e， b， d， f， gC、c， e， d， gD、b， d， f E、e， d， g
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？（）A、The database instance is not available.B、The ALTER TABLE command does not have WAIT optionC、The table or a row in the table is currently locked by another user session.D、The database instance is busy processing other user sessions commands.E、The CUSTOMERS table has no long running query active at the time when this request is made.F、The server process executing the ALTER TABLE command is busy with another command execution
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、 Drop and re-create the inbox.B、 Coalesce the ORDERS_IND index.C、 Coalesce the INDEXES tablespace.D、 Drop and re-create the ORDERS table.E、 Rebuild the index online and move it to another tablespace.
You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）A、Restart the database instance and run the jobB、Truncate the Certkiller STAFF table and run the jobC、Delete all rows from the Certkiller STAFF table and run the jobD、Increase the size of the USERStablespacethe and run the jobE、Increase the size of the database default permanenttablespaceand run the job
You work as a database administrator for Supportcenter.cn. You received the following error while working on your database： ORA-01555： snapshot too old ，In which situation would you receive such an error？（）A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted： INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） * ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.（）A、Grant the RESOURCE role to SCOTT.B、Add data files to the USERS tablespace.C、Grant the CREATE ANY TABLE privilege to SCOTT.D、Increase the space for SCOTT on the USERS tablespace.E、Increase the size of the data file associated with the USERS tablespace
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1： ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）A、drop and re-create the indexB、coalesce the ORDERS_IND indexC、coalesce the INDEXES tablespaceD、drop and re-create the ORDERS tableE、rebuild the index online and move it to another tablespace
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
The user HR receives the following error while inserting data into the TTK table：ERROR at line 1： ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace. Which three action would allow the user to insert data（）A、Add a data file to the SMD tablespace.B、Add a data file to the temporary tablespace associated with the user HR.C、Resize the data file associated with the SMD tablespace to make it larger.D、Alter the data file associated with the SMD tablespace to grow automatically.E、Change the segment space management for the SMD tablespace to automatic
You issued the following command： CREATE GLOBAL TEMPORARY TABLE admin_work_area （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1； An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command？（） A、 It stores only the temporary table but not its indexes.B、 It stores both the temporary table as well as its indexes.C、 It must be a nondefault temporary tablespace for the database.D、 It can be a default or nondefault temporary tablespace for the database.E、 It must be the default temporary tablespace of the user who issues the command.
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *ERROR at line 1： ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. （）A、Grant the RESOURCE role to SCOTT.B、Add data files to the USERS tablespace.C、Grant the CREATE ANY TABLE privilege to SCOTT.D、Increase the space for SCOTT on the USERS tablespace.E、Increase the size of the data file associated with the USERS tablespace
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（）A、It fails with a "Resource Busy" error.B、It deletes the rows successfully because the table is locked in SHARE mode.C、It fails to delete the records because the table is locked in EXCLUSIVE mode.D、It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
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.
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command： SQLDROP TABLESPACE INDEXES INCLUDING CONTENTS； SQL CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m； After that， you issued the following command to recreate the index： CREATE UNIQUE INDEX sales_index_pk ON sales （order_id） PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE （ INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ） NOLOGGING PARALLEL（ degree 4） Which two clauses are responsible for reducing the time for the recreation of the index？（）A、 PCTFREEB、 MAXTRANSC、 PCTINCREASED、 INITIALE、 NOLOGGINGF、 PARALLEL
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally， but will be slower
单选题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？ （）AThe table is partitionedBThe table name is wrong.CIt is an index-Organized table （IOT）DThe table is stored in locally managedtablespace.EThe table is stored in atablespacewhere segment space is managed manually.
单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old In which situation would you receive such an error？（）AYou performed rollback after commit.BIf a log switch occurs in your database.CThearchiverfails to generate an archived log file.DInstance recovery fails to find one of the redo log files.EA long-running query is unable to get read-consistent image.FIf you perform manual undo management operations in auto mode.
单选题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.
单选题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 with a Resource Busy error.BIt deletes the rows successfully because the table is locked in SHARE mode.CIt 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.
单选题You are attempting to create an Oracle-Managed Files （OMF） tablespace in a production database with the following statement and receive the following error message： CREATE TABLESPACE tbsl； ORA-02199： missing DATAFILE/TEMPFILE clause oerr ora 2199 02199， 00000， “missing DATAFILE/TEMPFILE clause” *Cause： A CREATE TABLESPACE statement has no DATAFILE/TEMPFTLE clause. *Action： specify DATAFILE/TEMPFILE clause. What is the corrective action to create the OMF based tablespace？（）A AB BC CD D