Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? （） It releases the storage space used by the table.。 It does not release the storage space used by the table.。 You can roll back the deletion of rows after the statement executes.。 You can NOT roll back the deletion of rows after the statement executes.。 An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.。 You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table。
拆除施工尘土较大时，没有采取洒水降尘的措施，容易导致对周围空气造成（）。 职业病。 物体打击。 中毒。 扬尘污染。
In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（） The optimizer statistics are collected automatically.。 Only the timed operating system （OS） statistics and plan execution statistics are collected.。 The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.。 The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. 。 Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.。
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 computer is managed by you， and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement， rows which duplicate CustName values are included should be moved from the CustInfo table every year. However， the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support， you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized. Which action should be performed to finish the task？（） A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.。 A new unique index should be created on the CustName column. And then， IGNORE_DUP_KEY = ON should be specified when creating index.。 On the CustName column， a foreign key constraint should be created， and a distinct list of CustName values is referenced by the foreign key constraint.。 A SELECT INTO query should be utilized， and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.。
因子Ⅶ和因子V主要含于下列哪种血液成分中（） 硫酸钡吸附血浆。 硫酸钡吸附血清。 正常人新鲜血浆。 正常人新鲜血清。
When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（）
a. Restore the control file from autobackups.
b. Run the RMAN restore and recover command.
c.Restore the database spfile from autobackups.
d. Make the RMAN backup set pieces available.
e. Open the database with the alter database open resetlogs command.
f.Open the database with the alter database open command.
