Run Segment Advisor
Run the SQL Tuning Advisor (STA)
Run the Automatic Workload Repository (AWR) report
Run the SQL Access Advisor with a hypothetical workload
第1题:
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to ensure that a newly created room mailbox automatically accepts meeting requests.What should you do?()
第2题:
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.Company.com has recently acquired a new Internet domain name from the Service Provider (SP).During the course of the business week you receive instruction from Company.com to ensure that allthe network users are able to send and receive e-mail messages sent to the newly acquired domain name. What should you do?()
第3题:
第4题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this, you must make sure that after it is completed successfully, the job is removed. What should you do? ()
第5题:
You work as a network exchange administrator at company.com.the company.com network currently consists of a single active directory forest containing a single domain named company.com.the company.com organization makes use of microsoft exchange server 2010 as their messaging solution.company.com has recently acquired a new internet domain name from the internet service provider (isp).during the course of the business week you receive instruction from company.com to ensure that all the network users are able to send and receive e-mail messages sent to the newly acquired domain name. What should you do?()
第6题:
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messagingsolution.During the course of the business week you receive instruction from Company.com to have a set of cmdlets grouped for administrative delegation of duties.What should you do?()
第7题:
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? ()
第8题:
You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command: ORAPWD file=d:/oracle/ora9i/orapwU01 password=admin entries=4 You erroneously deleted the password file while the database was running. You re-create the password file using the following command: ORAPWD file=d:/oracle/ora9i/orapwU01 password=change_on_install entries=4 However, when you try to connect as the SYS user, you receive the following error: ORA-01031: insufficient privileges What should you do to resolve this error?()
第9题:
You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to ensure that the newly hired administrative user named Rory Allen is able to move mailboxes in the organization whilst ensuring that you assign the least amount permissions for Rory Allen.What should you do?()
第10题:
You have implemented folder compression on the Windows 2000 Server and Windows 2000 Professional computers on your network. A user named Julia copies a compressed folder from an NTFS partition on her Windows 2000 Workstation to a shared NTFS folder on a remote Windows 2000 Server. What effect will this have on the newly created folder?()