搜题
用户您好, 请在下方输入框内搜索其它题目:
搜题
题目内容 (请给出正确答案)
提问人:网友 发布时间:
【单项选择题】

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 a financial services company. Replication is configured between two SQL Server 2005 computers, and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. 

A、A.Snapshot replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for a standard subscription.

B、B.Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for a standard subscription.

C、C.Merge replication should be set on SQL1. And then SQL2 should be set as a standard subscriber for an updateable subscription.

D、D.Transactional replication should be set on SQL1. And then, SQL2 should be set as a standard subscriber for an updateable subscription.

更多“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 a financial services company. Replication is configured between two SQL Server 2005 computers, and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. ”相关的问题
第1题

AYou are working on a database where downtime is not tolerated.  B、You are working on a database where downtime can be tolerated.  C、You are working on a database that operates in ARCHIVELOG mode.  D、You are working on a database that operates in NOARCHIVELOG mode.  E、You are working on a database where all the tablespaces are locally managed.  F、You are working on a database where control files and redo log files are multiplexed.  H、You are working on a database where control files and redo log files are not multiplexed.  

点击查看答案
第2题

A、Flashback logs are not deleted.  B、Flashback logs are deleted automatically.  C、Flashback logs are deleted only if you are using Recovery Manager (RMAN).  D、Flashback logs are deleted only if you are using Oracle Managed Files (OMF).  E、Flashback logs are deleted only if you are using Automatic Storage Management (ASM).  

点击查看答案
第3题

A、 Flashback logs are not deleted.  B、 Flashback logs are deleted automatically.  C、 Flashback logs are deleted only if you are using Recovery Manager (RMAN)  D、 Flashback logs are deleted only if you are using Oracle Manager Files (OFM)  E、 Flashback logs are deleted only if you are using Automatic Storage Management (ASM)  

点击查看答案
客服
TOP

请使用微信扫码支付

订单号:
遇到问题请联系在线客服