IBM Tivoli Process Automation Engine V7.5 Implementation Set 9

You administer a Microsoft SQL Server 2008 R2 instance that contains two databases named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the SQL_Latin1_General_CP1_CS_AS collation. You need to write a query that returns all customers having the same name in each database. You also need to ensure that the query is not case-sensitive.\ Which Transact-SQL query should you use?

You administer a Microsoft SQL Server 2008 instance that has TCP/IP enabled. You need to verify the port that the SQL Server instance listens on. What should you do?

You administer a database for an online ordering system. You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native tools. You need to ensure that the transaction log backup schedule meets the following requirements: Log backups occur every 15 minutes between 9:00 hours and 17:00 hours. Log backups occur every hour between 17:00 hours and 9:00 hours. What should you do?

You administer two SQL Server 2008 instance that contains a database named DB1. DB1 contains a table named Sales.Table1. You need to obtain the effective permissions of a user named User1 to access the Sales.Table1 table. Which Transact-SQL statement(s) should you execute in the DB1 database?

You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named Customers resides on Instance1. You move the Customers database from Instance1 to Instance2. The user attempts to access the Customers database on Instance2 by using the SQL Server login User1. However, the user receives an error message which indicates that the access to the Customers database is denied. You need to ensure the User1 can access the Customers database. Which Transact-SQL statements should you execute on Instance2?

You administer a SQL Server 2008 instance. You need to identify the network protocol used by the current connection. What should you do?

You install a 64-bit version of a SQL Server 2008 instance by using the default setup and configuration settings.
You receive the following error message:
"Your SQL Server installation completed with failures."
You close the error window before noting the location where additional information about the error is recorded.
You need to located the additional information.
Where would you search?

You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing application.
You need to ensure that the database allows full-text searches on the Customers table. You also need to
ensure that the full-text index is ready for use by the users.
You execute a Transact-SQL statement to create the full-text index on the Customers table by using the
CHANGE_TRACKING OFF and NO POPULATION clauses in the CREATE FULLTEXT INDEX statement.
You execute an ALTER FULLTEXT INDEX.
Which command or commands should you use next?

You administer a SQL Server 2008 instance.
You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail stored procedure is used to send a large volume of reports during business hours.
The reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?

You administer a SQL Server 2008 instance.
You need to configure the instance to use a single thread for queries that have an estimated execution cost of less than 3.
Which sp_configure configuration option should you set?