You have an SQL query that takes one minute to execute. You use the following code segment

A. Some quer y or reply packets are lost between the routers.

B. The neighboring router starts receiving route updates from this router.

C. A failure causes traffic on a link between two neighboring routers to flow in only one direction(unidirectional link).

D. Th e neighboring router stops receiving ACK packets from this router.

A. The Automatic Memory Manager (AMM)

B. The SQL Tuning Advisor

C. The Segment Advisor

D. The SQL Access Advisor

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

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

You issued the following command on the temporary tablespace LMTEMP in your database:SQL＞ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;Which requirement must be fulfilled for this command to succeed？（）

A. The tablespace must be locally managed.

B. The tablespace must have only one temp file.

C. The tablespace must be made nondefault and offline.

D. The tablespace can remain as the default but must have no active sort operations.

information about contracts on which your company has placed bids.

Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.

What should you do？

A．Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.

B．Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.

C．Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.

D．Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.

following entries: 2013-08-27 14:15:47 9056 [ERROR] Slave SQL: Could not execute Delete_rows event on table test.t1;Can‘t find record in ‘t1‘, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event‘s master log 56_master-bin. 000003, end_log_pos 851, Error_code: 10322013-08-27 14:15:47 9056 [warning] Slave: Can‘t find record in ‘t1‘ Error_code: 10322013-08-27 14:15:47 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START".We stopped at log ‘56_masterbin. 000003‘ position 684 Why did you receive this error？（）

A.The slave SQL thread does not have DELETE privileges to execute on test.t1 table.s

B.The table definition on the slave -litters from the master

C.Multi-threaded replication slaves can have temporary errors occurring for cross database updates

D.The slave SQL thread attempted to remove a row from the test.t1 table, but the row did not exist

in the HR schema by issuing the following command:$＞ sqlldr hr/hr@pdb table=employeesWhich two statements are true regarding the command？（）

A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

B. It fails because no SQL *Loader data file location is specified.

C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

D. It fails because no SQL *Loader control file location is specified.

company's Accounts database. Hundreds of users access the database each day.

Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

What should you do？

A．Enable the torn page detection database option for each database.

B．Disable write caching on all disk controllers.

C．Ensure that write caching disk controllers have battery backups.

D．Create a database maintenance plan to check database integrity and make repairs each night.

Internet Information Services (IIS), and the other is running SQL Server 2000. Company partners need to connect by means of the Internet and query data stored on the SQL Server computer. Some of these partners have computers that do not use Microsoft operating systems or Web browsers.

You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.

Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer.

You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take？ (Each correct answer represents part of the solution. Choose two.)

A．Configure the IIS virtual directory to allow URL queries.

B．Configure the IIS virtual directory to allow template queries.

C．Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.

D．Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.

E．Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.