While running long running queries， you receive the Snapshot

第1题：

You work as a database administrator for Certkiller .com. You received the following error while working on your database： ORA-01555： snapshot too old  In which situation would you receive such an error？（）

• A、You performed rollback after commit.
• B、If a log switch occurs in your database.
• C、Thearchiverfails to generate an archived log file.
• D、Instance recovery fails to find one of the redo log files.
• E、A long-running query is unable to get read-consistent image.
• F、If you perform manual undo management operations in auto mode.

第2题：

You are employed as the Exchange administrator at Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.You receive an instruction from management to identify the size of the items in the Inbox folder and the amount of items in the Deleted Items folder for an employee’s mailbox.You need to accomplish this task with the least amount of administrative effort.What should you do？（）

• A、You should consider running the Get-StoreUsageStatistics cmdlet.
• B、You should consider running the Get-MailboxStatistics cmdlet.
• C、You should consider running the Get-MailboxFolder cmdlet
• D、You should consider running the Get-MailboxFolderStatistics cmdlet.

第3题：

第4题：

Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）

• A、 The queries that are currently executing will abort and an error message will be returned to the user.
• B、 The queries that are currently executing will execute normally but future queries will not executed.
• C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.
• D、 The currently executing and future queries will execute normally， but will be slower

第5题：

Using splitvg to create a snapshot volume group of rootvg results in an error.  What is the most likely cause of the error（）

• A、There is not an available disk to allocate to the snapshot volume group
• B、One of the physical volumes associated with rootvg has a status of "missing"
• C、Rootvg is running in enhanced concurrent mode
• D、A snapshot volume group cannot be created for the rootvg

第6题：

Twenty database users are connected to your database. Five of the users are running long queries involving sort operations. The TEMP tablespace is the default temporary tablespace for your database. You are performing offline tablespace backups of individual tablespaces and erroneously execute the following statement：   SQL>ALTER TABLSPACE temp OFFLINE NORMAL；   What is the result of this statement？（）

• A、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected after their queries complete.
• B、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are disconnected and must re-execute their queries.
• C、 The TEMP tablespace is taken offline. The users using the TEMP tablespace for sorting are not disconnected， but these users must re-execute their queries.
• D、 The TEMP tablespace is not taken offline. The users using the TEMP tablespace for sorting are not disconnected， and their queries execute successfully.

第7题：

An administrator has made several topology and resource group changes on one node in a running cluster.During verification and synchronization， using the "Emulate" option， many errors are reported. Theadministrator decided the best course of action was to roll back the changes. Prior to the changes beingmade， a cluster snapshot was taken. Which of the following actions will roll back the changes with the least disruption？（）

• A、Perform a synchronization from a node without the changes.
• B、Apply the cluster snapshot on both nodes while the cluster is running.
• C、"Restore HACMP Configuration Database from Active Configuration" on the node where the changes weremade
• D、Stop the cluster using the option "Unmanage Resource Groups" and apply the cluster snapshot on thenode where the changes were made

第8题：

第9题：

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

• A、 Memory Advisor
• B、 Segment Advisor
• C、 Undo Advisor
• D、 SQL Tuning Advisor

第10题：

A SQL Azure database generates an error when a row is inserted into any table in the database.  No error is generated when a row is deleted.  You need to recommend an approach for locating the source of the errors.  What should you recommend？（）  

• A、 Use a Dynamic Management View to check for locks.
• B、 Use a Dynamic Management View to check for blocked queries.
• C、 Use a Dynamic Management View to check for long-running queries.
• D、 Use a Dynamic Management View to check the size and maximum size of the database.