SQL Server,Access,FoxPRO被称

题目

SQL Server,Access,FoxPRO被称为()。

  • A、支撑管理软件系统
  • B、应用管理软件系统
  • C、通用管理软件系统
  • D、数据库管理系统
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

下列选项中,不属于数据库管理系统的是_________。

A.Excel
B.FoxPro
C.Access
D.SQL-Server

答案:A
解析:

第2题:

假设一系统原来使用Access数据库,现要使用sql server数据库,采用()方法可以完成两个数据库之间的数据转换工作。

  • A、Sql server的附加数据库功能
  • B、Sql server的还原数据库功能
  • C、在Sql server中可直接打开Access数据库,另存即可。
  • D、Sql server的导入导出功能

正确答案:D

第3题:

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.


正确答案:BE
解析:Explanation:B:TheAllowTemplateQueriesoptionletsyoucreateXMLtemplatesthatcontainSQLstatements,whichcanbeusedtoreturndataasXML.Nobrowserwouldberequired,thoughyoucouldcertainlyuseone.Apossiblenon-browserclientcouldbeaVisualBasicapplicationforexample.E:IfyouforcetheuserstoauthenticatethemselvesviaBasicauthentication,IIShasallinformationrequiredtomakethetrustedconnectiontoSQLServer.WesetupIIStouseWindowsIntegratedAuthenticationwhenconnectingtotheSQLServer.WindowsAuthenticationloginsmustbecreatedontheSQLServeraswell.Incorrectanswers:A:URLqueriesallowexecutionofSQLqueriesdirectlyintheURL.Thiswouldrequireabrowserhowever,butnotallpartnersusebrowsers.Note:TheAllowURLQueriesoptionletsyoutypeSelectstatementsdirectlyinthebrowserandreturnthedataasXML.C:TheInternetGuestAccount,notaspecificWindowsaccount,shouldbeusedtoconnecttotheSQLServerfromtheIISserver.D:WeshouldnotallowaccesstotheSQLServerfortheIISInternetGuestaccount.ThatwouldallowallpeopleconnectingtotheIISserveraccesstotheSQLServeraswell.

第4题:

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 Services
  • B、SQL Server Browser
  • C、SQL Server Agent
  • D、Microsoft Distributed Transaction Coordinator

正确答案:B,D

第5题:

通过ODBC数据库,Access只能和SQL Server之间进行导入或导出数据。


正确答案:错误

第6题:

下列属于数据库管理系统的是() ①Access ②SQL Server ③FoxPro ④Excel

  • A、②③④
  • B、①②④
  • C、①③④
  • D、①②③

正确答案:D

第7题:

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.

正确答案:A

第8题:

SQL Server、Access和oracle都是Microsoft公司开发的数据库系统。()


本题答案:错

第9题:

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;

正确答案:A

第10题:

单选题
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.


正确答案: C
解析: 暂无解析

更多相关问题