多选题When does a transaction complete?（）Awhen a DELETE statement is executedBwhen a ROLLBACK command is executedCwhen a PL/SQL anonymous block is executedDwhen a data definition language (DDL) statement is executedEwhen a TRUNCATE statement is executed afte

第1题：

To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）

• A、It contains only the plan for the SQL statement executed by the user.
• B、It contains the SQL text executed by the user and the bind variables used with it.
• C、It contains the plan and statistics associated with the SQL statement executed by the user.
• D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

第2题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services （SSIS） package to perform an extract， transform， and load （ETL） process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components： A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average， 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do？（）

• A、 Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint. 
• B、 Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint. 
• C、 Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
• D、 Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.

第3题：

Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）

• A、None of the data definition language (DDL) statements are logged in the trace file.
• B、Only DDL commands that resulted in errors are logged in the alert log file.
• C、A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
• D、Only DDL commands that resulted in the creation of new database files are logged.

第4题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

• A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
• B、The ROLLBACK statement frees the storage space occupied by the DEPT table.
• C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
• D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

第5题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

• A、 functions
• B、 package
• C、 procedure
• D、 database trigger
• E、 anonymous PL/SQL block

第6题：

A data manipulation language statement （）.

• A、completes a transaction on a table
• B、modifies the structure and data in a table
• C、modifies the data but not the structure of a table
• D、modifies the structure but not the data of a table

第7题：

You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY   BEGIN TRANSACTION   DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY   BEGIN CATCH   DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） END CATCH；      You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do？（）

• A、Add a COMMIT TRANSACTION command to the CATCH block.
• B、Remove the COMMIT TRANSACTION command from the TRY block.
• C、Add a ROLLBACK TRANSACTION command to the CATCH block.
• D、Add a ROLLBACK TRANSACTION command to the TRY block.

第8题：

第9题：

第10题：

第11题：

第12题：

When does a transaction complete?（）

• A、when a DELETE statement is executed 
• B、when a ROLLBACK command is executed 
• C、when a PL/SQL anonymous block is executed 
• D、when a data definition language (DDL) statement is executed 
• E、when a TRUNCATE statement is executed after the pending transact ion

第13题：

Which statement correctly describes SQL and /SQL*Plus?（）

• A、Both SQL and /SQL*plus allow manipulation of values in the database.
• B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.
• C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.
• D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.

第14题：

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）

• A、function
• B、package
• C、procedure
• D、database trigger
• E、anonymous PL/SQL block

第15题：

Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）

• A、It releases the storage space used by the table.
• B、It does not release the storage space used by the table.
• C、You can roll back the deletion of rows after the statement executes.
• D、You can NOT roll back the deletion of rows after the statement executes.
• E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
• F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

第16题：

Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）

• A、 The statement will be executed successfully， and a new time zone will be set for the database.
• B、 The statement will be executed successfully， but a new time zone will not be set for the database.
• C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
• D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

第17题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）

• A、The DESCRIBE DEPT statement displays the structure of the DEPT table.
• B、The ROLLBACK statement frees the storage space occupies by the DEPT table.
• C、The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
• D、The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

第18题：

第19题：

第20题：

第21题：

第22题：