网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
某企业的SQL Server 2005数据库每周日12点进行一次完整备份,每天晚上24点进行一次差异备份,每小时进行一次事务日志备份,数据库在2009-7-16的6:30崩溃,应如何将其恢复从而使数据库损失最小?
参考答案
更多 “某企业的SQL Server 2005数据库每周日12点进行一次完整备份,每天晚上24点进行一次差异备份,每小时进行一次事务日志备份,数据库在2009-7-16的6:30崩溃,应如何将其恢复从而使数据库损失最小?” 相关考题
考题
以下属于网络数据库SQL Server中常见的版本的是()
A.SQL Server 2000企业版B.SQL Server 2000标准版C.SQL Server 2000个人版D.SQL Server 2000企业版;SQL Server 2000标准版;SQL Server 2000个人版都是
考题
【急】请教一个SQL Server 2005的问题
我现在有2台数据库服务器(A与B),均安装的是SQL Server 2005数据库;有没有办法让A的存储过程直接操作B的表?请给出详细的配置等实例,谢谢!
考题
设数据库管理员为SQL Server 2008默认实例中的某数据库实施了基于维护计划的数据库备份任务。配置完成后,发现此维护计划并未执行但数据库运行正常。有关此维护计划未执行的原因,下列说法中最有可能的是( )。A.“SQL Server(MSSQLSERVER)”服务未启动B.“SQL Server代理(MSSQLSERVER)”服务未启动C.“SQL Server Browser”服务未启动D.“SQL Server VSS Writer”服务未启动
考题
支持SQL Server 2000中的所有可用功能,可作为企业数据库服务器使用的SQL Serve2000版本是——。A.SQL Server 2000个人版B.SQtL Server 2000企业版C.SQL Server 2000开发版D.SQL Server 2000标准版
考题
以下不属于网络数据库SQL Server中常见的版本的是()A、SQL Server 2000企业版B、SQL Server 2000标准版C、SQL Server 2000增强版D、SQL Server 2000开发版
考题
以下属于网络数据库SQL Server中常见的版本的是()A、SQL Server 2000企业版B、SQL Server 2000标准版C、SQL Server 2000个人版D、SQL Server 2000企业版;SQL Server 2000标准版;SQL Server 2000个人版都是
考题
假设一系统原来使用Access数据库,现要使用sql server数据库,采用()方法可以完成两个数据库之间的数据转换工作。A、Sql server的附加数据库功能B、Sql server的还原数据库功能C、在Sql server中可直接打开Access数据库,另存即可。D、Sql server的导入导出功能
考题
假设某一系统,原来使用Access数据库,现在改用SQL server数据库,采用()方法可以快速完成两个数据库之间的数据转换动作。A、SQL server的附加数据库功能B、SQL server的还原数据库功能C、在SQL server中直接打开Access数据库,另存即可D、使用SQL server的的导入/导出功能
考题
某公司的网络中有一台数据库服务器,服务器上运行的应用软SQL Server 2000.某日数据库管理员通过操作系统的工具“性能监视器”对SQL Server进行性能监视时,选择的监视对象为:SQL Server:Cache Manager,通过该对象他可以监视的内容为()A、SQL Server数据库对象的分配B、SQL Server复制代理程序的信息C、SQL Server内存的使用信息D、SQL Server高速缓存的信息
考题
()管理工具是SQL SERVER2005提供的集成环境,它能完成访问、配置和管理SQL SERVER的所有任务。A、SQL SERVER Management StudioB、SQL SERVER配置管理器C、企业管理器D、查询分析器
考题
You need to identify the combinations of the Windows operating system and SQL Server 2005 version that will be the most appropriate for the new RD configuration, which will include the Research, Parts, and Engineering databases.Which two combinations will be the most appropriate?()A、Windows Server 2003 Enterprise Edition with SQL Server 2005 Enterprise EditionB、Windows Server 2003 Datacenter Edition with SQL Server 2005 Enterprise EditionC、Windows Server 2003 Standard Edition with SQL Server 2005 Enterprise EditionD、Windows Server 2003 Enterprise Edition with SQL Server 2005 Standard Edition
考题
单选题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 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 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 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
考题
多选题Netnumen网管可以支持的数据库类型有()?AMS SQLS ERVERBMS SQL SERVER2005COracleDSybaseEMySQL
热门标签
最新试卷