网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views. What should you do？（）
A
Create DML triggers that query the inserted and deleted tables.
B
Create a stored procedure that calls the LTRIM and RTRIM built-in functions.
C
Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.
D
Call the TRIM built-in function.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views. What should you do？（）A Create DML triggers that query the inserted and deleted tables.B Create a stored procedure that calls the LTRIM and RTRIM built-in functions.C Create a Transact-SQL function that calls the LTRIM and RTRIM built-in functions.D Call the TRIM built-in function.” 相关考题
考题
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. The users report the slow performance of a SQL Server 2005 application. You are required to identify the queries which perform slowly because of blocking. Which action should you perform？（）A、In a SQL Trace log file， you should look for queries with low duration values and high read and write values.B、In a query execution plan， you should look for queries with missing or out-of-date statistics.C、In a SQL Trace log file， you should look for queries with high duration values and low read and write values.D、In a query execution plan， you should look for queries with a large number of table scans.
考题
TestKing.com has a server named SQL1 that runs SQL Server 2005 Enterprise Edition.SQL1 has 2 GB of RAM， 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month. Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log？（）A、MSAS 2005：CacheB、MSAS 2005：MemoryC、MSAS 2005：Proactive CachingD、SQLServer：Buffer Manager
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A user database named Products is included by your SQL Server 2005 computer. SQL Server Integration Services （SSIS） packages are utilized to export data from the Products database to a text file. You deliver the text file to your company’s trading partners by utilizing FTP. You are required to make sure that your SSIS packages can be recovered from the occurrence of a disaster. Which action should be performed to finish the task？（）A、To finish the task，the Products database should be backed up.B、To finish the task，your server should be set to utilize the full recovery model.C、To finish the task，your server should be set to utilize the bulk-logged recovery model.D、To finish the task， the msdb database should be backed up.
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. More than a month ago， the SQL 2005 Server computer is deployed in operation. There are some query performance problems last week. Therefore， you perform an investigation on the locking contention. From the sys.dm_os_wait_stats dynamic management view （DMV）， you can see a high value in the max_wait_time_ms column. You want to check out whether this value is a factor which leads to the current performance problems. In addition， the impact on database users should e cut to the least. Which action should be performed to achieve the goal？（）A、To achieve the goal， the UPDATE STATISTICS command should be excuted.B、To achieve the goal， the SQL Server Service should be restarted.C、To achieve the goal， the SQL Server computer should be restarted.D、To achieve the goal， the statistics in the dynamic management view （DMV） should be reset.
考题
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 database named Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? （） A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. B、You should identify whether the SQL Server Agent is started on the primary server. C、You should identify whether the AdventureWorks database uses the Simple recovery model. D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
考题
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A、 Use SQLAzure Data Sync Service.B、 Use SQL Server replication.C、 Use SQL Server backup and restore.D、 Use SQL Server database snapshots.
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. You utilize the SP：Recompile event class to run SQL Server Profiler. You find that a great amount of recompiles occurring. The possible causes of the large number of recompiles should be identified. From the flowing four options， which one is the most possible cause of the problem？（）A、The sp_executesql batches are not being recovered from the procedure cache.B、A database administrator executed UPDATE STATISTICS statements on all tables， and the most common stored procedures reference all the tables.C、One new stored procedure is created by a database administrator.D、Ad hoc batches are not being recovered from the procedure cache.
考题
ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance.
考题
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the database administrator for your company. You find a problem that there are three reports which are running slowly. And through detailed analysis， you conclude that no error messages are generated from these reports. Not only the indexing strategy but also the status of the current indexes is tested by you. You confirm that the slow performance of the financial reports is not caused by it. Since you are the technical support， you are required to find out which statement is causing the slow performance. Which action should be performed first？（）A、SQL Server Profiler should be run with the Lock：Deadlock event class.B、The Database Engine Tuning Advisor （DTA） f should be run or at least one hour.C、SQL Server Profiler should be run with the TSQL_Duration template.D、The Database Engine Tuning Advisor （DTA） should be run with the default options.
考题
You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）A、Internet Information ServicesB、SQL Server BrowserC、SQL Server AgentD、Microsoft Distributed Transaction Coordinator
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
考题
单选题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 SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?（）A
For the database, you should turn on the TRUSTWORTHY database optionB
For the database, the PAGE_VERIFY database option should be set to CHECKSUMC
For the database, the database compatibility level option should be set to 10D
For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
考题
单选题You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A
Use SQLAzure Data Sync Service.B
Use SQL Server replication.C
Use SQL Server backup and restore.D
Use SQL Server database snapshots.
考题
单选题You need to select the appropriate edition of SQL Server 2005 for the portable computers that are used in the Mortgage Data Cleansing project. Which edition should you use?（）A
Microsoft SQL Server 2005 Mobile EditionB
Microsoft SQL Server 2005 Express EditionC
Microsoft SQL Server 2005 Standard EditionD
Microsoft SQL Server 2005 Workgroup Edition
考题
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）A
To achieve the goal， DBCC DBREINDEX should be utilized.B
To achieve the goal， SELECT * FROM sys.indexes should be utilized.C
To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.D
To achieve the goal， DBCC INDEXDEFRAG should be utilized.
考题
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work a database administrator for your company. There is a Data Transformation Services （DTS） package， and the DTS package is stored in SQL Server 2000. And you plans to have the SQL Server 2000 migrated into SQL Server 2005. The DTS package dynamically configures precedence constraints by utilizing complex Microsoft Visual Basic Scripting Edition （VBScript）. The SQL Server 2005 Package Migration Wizard is run by you， but the wizard cannot convert the package from SQL Server 2000 to SQL Server 2005. You are required to make sure that the DTS package runs in SQL Server 2005. And the package should be run in the shortest time. Which action should be utilized？（）A
The SQL Server 2000 Data Transformation Services （DTS） package should be wrapped in an Execute DTS 2000 Package task.B
The SQL Server 2000 Data Transformation Services （DTS） package should be manually recreated as a SQL Server Integration Services （SSIS） package.C
The SQL Server 2000 Data Transformation Services （DTS） task should be configured to not utilize precedence constraints. Then， the SQL Server 2005 Package Migration Wizard should be run again.D
The SQL Server 2005 Package Migration Wizard should be run. And when the upgrade fails， a Transfer SQL Server Objects task should be run.
考题
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）A
You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. B
You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. C
You should upgrade the SQL Server 2005 application to use SQL Server 2008. D
You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
考题
单选题You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation. You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）A
Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.B
Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.C
Modify the format file to specify the same collation as the Dublin database. Import the table again.D
Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.
考题
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A vendor company’s application is utilized， and the application is based on a proprietary database. Data is queried from the application database and the data is imported into a SQL Server 2005 database. A new OLE DB driver is offered by the application vendor， and the new OLE DB driver will be utilized when the application database is queried. According the company requirements， the connections between the SQL Server database and the application database is prohibited， except when this data is queried. You should think out a method to have data queried from the application database. Which action should be performed to achieve the goal？（）A
To achieve the goal， a Linked Server connection should be configured to the application database.B
To achieve the goal， a query should be written， and an OPENQUERY command is utilized by the query.C
To achieve the goal， a Remote Server connection to the application database should be configured.D
To achieve the goal， a query should be written， and an OPENDATASOURCE command is utilized by the query.
考题
单选题You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）A
Install a separate instance of SQL Server 2005 for each of the databases on a single server.B
Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.C
Import the data from each of the databases into a single database in an instance of SQL Server 2005.D
Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.
考题
单选题You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do？（）A
Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.B
Query the sys.server_permissions table on Server1.C
Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.D
Query the sys.database_permissions and sys.database_principals tables in the MedDB database.
考题
单选题ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （）A
You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance B
You should upgrade the SQL Server 2005 application to use SQL Server 2008 C
You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance D
You should install SQL Server 2008 as a named instance, and make the new application use the new instance.
考题
单选题You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）A
one SQL Server 2005 computer with one instanceB
two SQL Server 2005 computers， each with two instancesC
two SQL Server computers， one with one instance and one with three instancesD
one SQL Server 2005 computer with two instances
考题
单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer， and the computer is called SQL1. There are two databases on the SQL1， and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database， the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator， you are required to make sure the points listed below. First， the tables should not be removed from the Staging database. Second， any attempts to have tables migrated should be logged. Third， your solution should not impact on other databases. Which action should be performed to achieve the goal？（）A
To achieve the goal， a DML trigger on each table should be created to prevent deletion of data.B
To achieve the goal， a DDL trigger should be created， and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.C
To achieve the goal， an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.D
To achieve the goal， a DDL trigger should be created， and the ON ALL SERVER parameter is utilized by the DDL trigger.
考题
单选题You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）A
DBCC DBREINDEXB
SELECT * FROM sys.dm_db_index_physical_statsC
DBCC INDEXDEFRAGD
SELECT * FROM sys.indexes
考题
多选题You are a database administrator for your company. You are configuring a new SQL Server 2005 computer named SQL1. SQL1 will run Reporting Services. It will also be configured to automatically perform database backups and other maintenance tasks. There are no other SQL Server computers in the network environment. All access to SQL1 will be made by using SQL1s DNS name. You need to disable any unnecessary services on SQL1. Which service or services should you disable？（）AInternet Information ServicesBSQL Server BrowserCSQL Server AgentDMicrosoft Distributed Transaction Coordinator
热门标签
最新试卷
