多选题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 

第1题：

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.

第2题：

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， f
• B、c， a， e， b， d， f， g
• C、c， e， d， g
• D、b， d， f 
• E、e， d， g

第3题：

第4题：

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.

第5题：

The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）

• A、The session is terminated after receiving the error and JIM can continue with his transaction.
• B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
• C、The session is rolled back after receiving the error and JIM can continue with his transaction.
• D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

第6题：

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）  

• A、 The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
• B、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.
• C、 If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.
• D、 If you restart the database，the database will not be opened.

第7题：

Identify the two situations in which you use the alert log file in your database to check the details.（）

• A、Running a query on a table returns "ORA-600： Internal Error."
• B、Inserting a value in a table returns "ORA-01722： invalid number."
• C、Creating a table returns "ORA-00955： name is already used by an existing object."
• D、Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated." 
• E、Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."

第8题：

A user executes a query on the EMP table， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error： SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal; SELECT ename FROM emp WHERE deptno=10 ORDER BY sal  *  ERROR at line 1：  ORA/x7f01157： cannot identify/lock data file 201 /x7f see DBWR trace file  ORA/x7f01110： data file 201： ’/u01/app/oracle/oradata/orcl/temp01.dbf’  What is a possible reason？（）

• A、The tempfile belonging to the default temporary tablespace is missing.
• B、The database is opened in restricted mode， so queries are not allowed.
• C、The default temporary tablespace required to execute the query is offline.
• D、The default temporary tablespace required to execute the query is dropped.
• E、The default temporary tablespace required to execute the query is read­only.

第9题：

You opened the encryption wallet and then issued the following command：   SQL>CREATE 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.

第10题：

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 job
• B、Truncate the Certkiller STAFF table and run the job
• C、Delete all rows from the Certkiller STAFF table and run the job
• D、Increase the size of the USERStablespacethe and run the job
• E、Increase the size of the database default permanenttablespaceand run the job