[单选]

Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（）
1.Shut down the database.
2.Take the users_01.dbf datafile offline with the alter database command.
3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.
4.Restore all users tablespace-related datafiles from backup media.
5.Issue the recover tablespace users command.
6.Issue the recover datafile users_01.dbf command.
7.Start up the database.
8.Bring the users_01.dbf datafile online with the alter database command.

A customer requires two 12X loops on their new POWER7 system. What is the smallest system that will support two loops?（） Power 710。 Power 720。 Power 730。 Power 740。 工程建设实施过程中的工程质量由（）负总责。 监理单位。 设计单位。 施工单位。 项目法人。 In which scenario would TOP N analysis be the best solution? （） You want to identify the most senior employee in the company.。 You want to find the manager supervising the largest number of employees.。 You want to identify the person who makes the highest salary for all employees.。 You want to rank the top three sales representatives who have sold the maximum number of products.。 Which three statements about performance analysis by SQL Performance Analyzer are true? （） It detects changes in SQL execution plans.。 It produces results that can be used to create the SQL plan baseline.。 The importance of SQL statements is based on the size of the objects accessed.。 It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.。 It shows only the overall impact on workload and not the net SQL impact on workload.。 准备工作

Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（）
1.Shut down the database.
2.Take the users_01.dbf datafile offline with the alter database command.
3.Restore the users_01.dbf datafile from backup media with the required archived redo logs.
4.Restore all users tablespace-related datafiles from backup media.
5.Issue the recover tablespace users command.
6.Issue the recover datafile users_01.dbf command.
7.Start up the database.
8.Bring the users_01.dbf datafile online with the alter database command.