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

第1题：

You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）

• A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.
• B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.
• C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.
• D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.

第2题：

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.

第3题：

第4题：

You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

• A、 flash back the corrupted blocks
• B、 use the DBMS_REPAIR package
• C、 use the RMAN TSPITR command
• D、 use the RMAN BLOCKRECOVER command
• E、 use the RESTORE DATABASE and RECOVER DATABASE commands
• F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

第5题：

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：  ’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following： The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file， and all the archived logs are accessible.   Which option would you choose？（）

• A、flash back the corrupted blocks
• B、use the DBMS_REPAIR package
• C、use the RMAN TSPITR command
• D、use the RMAN BLOCKRECOVER command
• E、use the RESTORE DATABASE and RECOVER DATABASE commands
• F、investigate the time at which the corruption occurred and perform a point-in-time recovery

第6题：

A user executes a query on the EMPtable， 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-01157： cannot identify/lock data file  201 - see DBWR trace file ORA-01110： 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.

第7题：

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

• A、 open the database with the RESTRICTED option
• B、 open the database with the RESETLOGS option
• C、 recover to the required SCN only that data file in which the error occurred
• D、 recover all the data files to the same system change number （SCN）

第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题：

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

第10题：

When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）

• A、audit trail
• B、alert log file
• C、user trace file
• D、online trace file
• E、background trace file
• F、operating system event viewer