网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
SQL Server，Access，FoxPRO被称为（）。
- A、支撑管理软件系统
- B、应用管理软件系统
- C、通用管理软件系统
- D、数据库管理系统
参考答案
更多 “SQL Server，Access，FoxPRO被称为（）。A、支撑管理软件系统B、应用管理软件系统C、通用管理软件系统D、数据库管理系统” 相关考题
考题
You are the administrator of two Microsoft Windows 2000 computers. One computer is running Internet Information Services (IIS), and the other is running SQL Server 2000. Company partners need to connect by means of the Internet and query data stored on the SQL Server computer. Some of these partners have computers that do not use Microsoft operating systems or Web browsers.You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer.You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)A．Configure the IIS virtual directory to allow URL queries.B．Configure the IIS virtual directory to allow template queries.C．Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.D．Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.E．Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.
考题
假设一系统原来使用Access数据库，现要使用sql server数据库，采用（）方法可以完成两个数据库之间的数据转换工作。A、Sql server的附加数据库功能B、Sql server的还原数据库功能C、在Sql server中可直接打开Access数据库，另存即可。D、Sql server的导入导出功能
考题
Which statement correctly describes SQL and /SQL*Plus?（）A、Both SQL and /SQL*plus allow manipulation of values in the database.B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of two SQL Server 2008 instance. The two instances are respectively named InstanceA and InstanceB. There is a database named Dworks on InstanceA. You move the Dworks database to InstanceB. A user use a SQL Server login named Mary to access the database on InstanceA with the password "Tk@87#34". On InstanceB, you create the same SQL Server login. The user tries to use the SQL Server login Mark to access the Dworks database on InstanceB. But the user gets an error message, according to the indication of the message, the access to the Dworks database has been denied. You must make sure that the user can access the Dworks database on InstanceB successfully. So on InstanceB, which Transact-SQL statements should you execute?（） A、USE AdventureWorks;ALTER USER Mary WITH LOGIN = Mary; B、USE AdventureWorks;ALTER LOGIN Mary ENABLE; C、USE AdventureWorks;ALTER LOGIN Mary WITH PASSWORD = "Tk@87#34" UNLOCK; D、USE AdventureWorks;ALTER LOGIN Mary WITH DEFAULT_DATABASE = AdventureWorks;
考题
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 are a database administrator for your company. The company has two SQL Server 2005 computers named SQL1 and SQL2. SQL1 is located on the local network. SQL2 is located at a vendors site and is connected by using a VPN over the Internet. You need to write heterogeneous queries on SQL1 that access data from both SQL1 and SQL2. To ensure that your queries are functional， you must configure access to the vendors site. What should you do？（）A
Configure an HTTP endpoint for SQL2 on SQL1.B
Configure SQL2 as a linked server on SQL1.C
Configure an HTTP endpoint for SQL1 on SQL2.D
Configure SQL1 as a linked server on SQL2.
考题
单选题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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? （）A
You should configure Distributed File SystemB
You should configure SQL ServerC
You should configure SQL Server Full TextD
You should configure SQL Server VSS Writer
考题
多选题You need to ensure that the company’s standard password policy is enforced for all logins that areused to access SQL Server 2005.Which two actions should you perform？（）ASet the appropriate local password policies for all computers on which SQL Server is installed.BSet the server authentication mode of all SQL Server instances to Windows Authentication mode.CInstall all instances of SQL Server 2005 on computers that run Windows Server 2003 or later.DCreate SQL Server logins that have CHECK_POLICY enabled.
考题
单选题You are the administrator of a SQL Server 2005 computer named SQL1. All servers run Microsoft Windows Server 2003 and belong to a Microsoft Active Directory domain. The companys written security policy mandates strong passwords for all domain， local， and application accounts. The appropriate domain password policy has been deployed through the use of a Group Policy object （GPO）. Many of the company’s computers run MS-DOS-based or UNIX-based operating systems. These computers require varying levels of access to a database named Services on SQL1. You need to ensure that these computers can access the Services database without violating the company’s written security policy. What should you do？（）A
Create a domain account for each of the company’s users. Provide each domain account with access to SQL1 and the Services database.B
Create a local logon account on SQL1 for each of the company’s users. Provide each logon account with access to SQL1 and the Services database.C
Create a SQL Server logon account for each of the company’s users. Enable the Enforce password policy option for each logon account. Provide each logon account with access to the Services database.D
Configure a virtual directory through Internet Information Services （IIS） for access to SQL1. Direct users to the virtual directory for data access.E
Create one SQL Server logon account for all of the company’s computers running MS-DOS or UNIX-based operating systems. Enable the Enforce password policy option for users’ accounts. Provide the logon accounts with access to the Services database.
考题
单选题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.
考题
单选题A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message： "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1. What should you do？（）A
Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.B
Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.C
Ensure that the login name is created with square brackets （[]）.D
Give the login access to a specific database by using the CREATE USER Transact-SQL statement.
考题
单选题假设一系统原来使用Access数据库，现要使用sql server数据库，采用（）方法可以完成两个数据库之间的数据转换工作。A
Sql server的附加数据库功能B
Sql server的还原数据库功能C
在Sql server中可直接打开Access数据库，另存即可。D
Sql server的导入导出功能
考题
单选题Which statement correctly describes SQL and /SQL*Plus?（）A
Both SQL and /SQL*plus allow manipulation of values in the database.B
/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.C
/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.D
/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the 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.
考题
单选题假设某一系统，原来使用Access数据库，现在改用SQL server数据库，采用（）方法可以快速完成两个数据库之间的数据转换动作。A
SQL server的附加数据库功能B
SQL server的还原数据库功能C
在SQL server中直接打开Access数据库，另存即可D
使用SQL server的的导入/导出功能
考题
单选题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? （）A
You should use local Service accountB
You should use network Service accountC
You should use domain accountD
You should use local System account
考题
单选题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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （）A
You should configure SQL Server VSS Writer B
You should configure Distributed File System C
You should configure SQL Server D
You should configure SQL Server Full Text
考题
单选题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. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number. Which performance object should you capture?（）A
SQLServer:Buffer Manager B
SQLServer:Access Methods C
SQLServer:General Statistics D
SQLServer:Exec Statistics
考题
多选题You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM database on SQL2. You create a linked server for SQL2， and you create a linked server login that uses impersonation.Now， you need to ask the network administrator to configure SQL1. Which two tasks should you ask the administrator to perform？（）AAdd the user account that is used by the SQL Server service to the local Administrators group.BEnable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.CCreate a Service Principal Name （SPN） for the user account that is used by the SQL Server service.DEnable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.
考题
单选题TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. A user in TestKing.com named Eric writes many ad hoc queries against the company databases.Eric has access to the Customer database on SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that join information from both servers. What should you do first？（）A
Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.B
Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.C
Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the server name.D
Instruct Eric to specify SQL Server object names by using four-part notation.
考题
多选题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
热门标签
最新试卷