You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session: ALTER SESSION ENABLE RESUMABLE; Which command could you issue to enable the resumable space allocation feature at the session level?()
While troubleshooting a network outage, you discover that an employee brought a switch from home into the office to connect additional equipment to the network. In order to increase his speed, he connected this switch to both network ports in his office, resulting in a bridge loop. Which of these can you implement to prevent future occurrences of this issue?()
_____
You discover that the ms db database on a SQL Server 2005 computer is corrupt and must be restored. Databases are backed up daily. The database backup files are written to a network share, but the file names do not clearly indicate which databases are in each file. You need to locate the correct backup file as quickly as possible. The first file in the list isnamed DB Backup.bak. Which Transact-SQL statement should you use?()
You have an Exchange Server 2010 organization.You discover that messages sent to the Internet include internal Exchange routing information in the message header.You need to prevent internal routing information from being sent to external recipients. What should you do?()
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?()
You discover that a particular group of settings named UserPreferences changes.You need to store the UserPreference settings to prevent affecting other applications. Which two actions should you perform?()
Who was the first European to discover Canada?()
You query the ORDERS table and discover that order number 1101 is missing. One of your reports, generated at 5:00 A.M. on April 23, 2005 using Oracle Reports, includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated?()
While maneuvering, you discover heavy smoke coming from the turbocharger casing, you should ()