网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）
A
Each extra column in the copy with more columns must not have a default value
B
Columns that are common to both versions of the table must be defined in the same order on the master and the slave
C
The slave database cannot have more columns than the master. Only the master database can have more columns
D
Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
E
The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
参考答案
参考解析
解析：
暂无解析
更多 “多选题You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）AEach extra column in the copy with more columns must not have a default valueBColumns that are common to both versions of the table must be defined in the same order on the master and the slaveCThe slave database cannot have more columns than the master. Only the master database can have more columnsDColumns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverEThe master database cannot have more columns than the slave. Only the slave deatbase can have more columns” 相关考题
考题
You create a master page named PageBase.master. The master page contains a Label control named lblTitle.You create a content page that references the master page.You need to change the Text property of the master page‘s lblTitle control from the content page.Which code segment should you use?（）A.B.C.D.
考题
Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed?()
A. Because row IDs may change during the flashback operationB. Because the object number changes after the flashback operationC. Because the rows are retrieved from the recycle bin during the flashback operationD. Because the table is moved forward and back to a temporary during the flashback opertion
考题
You need to dump the data from the master server and import it into a new slave server.Which mysqldump option can be used when dumping data from the master server in order to include the master server‘s binary log information?（）A.Include-master-infoB.Master-binlogC.Include-log-fileD.Master-data
考题
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?()
A.Each extra column in the copy with more columns must not have a default valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
考题
You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)A．Apply a bulk update lock to the table.B．Use separate client connections to load the files into the table simultaneously.C．Create a clustered index on the table.D．Specify the Full Recovery model for the database.E．Specify the Bulk-Logged Recovery model for the database.
考题
You want to create a temporary table named OLD_INVENTORY in the OLD_INVENTORY database on the master server. This table is not to be replicated to the slave server. Which two changes would ensure that the temporary table does not propagate to the slave?（）A、Use the – replicate-do-db, — replicate-do-table, or – replicate-wild-do-table option with the value equal to OLD_INVENTORYB、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY tableC、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary tableD、Set binlog_format=MIXED with the – replicate-ignore-temp-table optionE、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
考题
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; （）A、You obtain the results retrieved from the public synonym HR created by the database administrator.B、You obtain the results retrieved from the HR table that belongs to your schema.C、You get an error message because you cannot retrieve from a table that has the same name as a public synonym.D、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.E、You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
考题
You create a master page named Article.master. Article.master serves as the template for articles on your Web site. The master page uses the following page directives. %@ Master Language="C#" Src="~/article.master.cs" Inherits="article" % You need to create a content page that uses the master page as a template. In addition, you need to use a single master page for all devices that access the Web site. Which code segment should you use? （）A、%@ Page Language="C#" Theme="article"%B、%@ Page Language="C#" MasterPageFile="~/article.master"%C、%@ Page Language="C#" ie:MasterPageFile="~/article.master"%D、%@Page Language="C#" all:MasterPageFile="~/article.master"%
考题
You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）A、Include-master-infoB、Master-binlogC、Include-log-fileD、Master-data
考题
An application uses Windows Azure Table storage. The application uses five tables. One table used by the application is approaching the limit for storage requests per second. You need to recommend an approach for avoiding data access throttling. What should you recommend？（）A、 Use a single partition key for the table.B、 Compress data before storing it in the table.C、 Create additional partition keys for the table.D、 Continually remove unnecessary data from the table.
考题
You have an Exchange Server 2010 that contains a DAG named DAG1.Contains 3 Mailbox Servers including a server named Server 1. Server 1 fails.You restore Server 1.You need to ensure that Server 1 can replicate Mailbox Databases from DAG1. What should you do first？（）A、Modify the GUID for Server 1B、Remove the object for Server 1 from DAG1C、Remove the default Mailbox Database from Server 1D、Disable log truncation for the Mailbox database in DAG1
考题
You are transferring records from one database to another. You need to decide whether you can use the SqlBulkCopy class to transfer the records. What should you do? （）A、Ensure that the source database is Microsoft SQL Server.B、Ensure that the destination database is Microsoft SQL Server.C、Ensure that the column names in the source table match the column names in the destination table.D、Ensure that the bulk copy program (bcp) utility is installed on the destination server.
考题
You create a master page named Article.master. Article.master serves as the template for articles on your Web site. The master page uses the following page directives. %@ Master Language="VB" CodeFile="article.master.vb" Inherits="article" % You need to create a content page that uses the master page as a template. In addition, you need to use a single master page for all devices that access the Web site. Which code segment should you use? （）A、%@ Page Language="VB" Theme="article"%B、%@ Page Language="VB" MasterPageFile="~/article.master"%C、%@ Page Language="VB" ie:MasterPageFile="~/article.master"%D、%@Page Language="VB" all:MasterPageFile="~/article.master"%
考题
You create a master page named Template.master. Template.master contains the following ContentPlaceHolder server controls.You also create 10 Web Forms. The Web Forms reference Template.master as their master page. Each Web Form has the following Content controls that correspond to the ContentPlaceHolder controls in Template.master.You need to configure the Web pages so that default content will be shown in the area2 ContentPlaceHolder control whenever a Web Form does not provide that content. What should you do? （）A、Move default content inside area2 in Template.master. Remove area2 from Web Forms that do not provide content.B、Move default content inside area2 in Template.master. Leave area2 blank in Web Forms that do not provide content.C、Move default content inside area2 in the Web Forms. Remove area2 from Template.master.D、Create an additional ContentPlaceHolder control in Template.master named area2_default. Place default content inside area2_default. Remove area2 from Web Forms that do not provide content.
考题
You are decommissioning domain controllers that hold forest-wide operations master roles. You need to transfer all forest-wide operations master roles to another domain controller. Which two roles should you transfer？（）A、RID masterB、PDC emulatorC、Schema masterD、Infrastructure masterE、Domain naming master
考题
You need to ensure that domain controllers only replicate between domain controllers in adjacent sites. What should you configure from Active Directory Sites and Services（）A、From the IP properties， select Ignore all schedules.B、From the IP properties， select Disable site link bridging.C、From the NTDS Settings object， manually configure the Active Directory Domain Services connection objects.D、From the properties of the NTDS Site Settings object， configure the Inter-Site Topology Generator for each site.
考题
You need to design a connection agreement for Active Directory Connector to synchronize directory information with the subsidiary location. Which two actions should you perform？（）A、Configure a one-way connection agreement that replicates from the subsidiary’s Exchange 5.5 organization to Active DirectoryB、Configure a one-way connection agreement that replicates from Active Directory to the subsidiary’s Exchange 5.5 organizationC、Configure two one-way connection agreements that replicate between the subsidiary’s Exchange 5.5 organization and Active DirectoryD、Configure the connection agreement to replicate all objectsE、Configure the connection agreement to replicate only mailboxesF、Configure the connection agreement to save deletions in an LDAP Data Interchange Format file
考题
单选题Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）A
Because row IDs may change during the flashback operationB
Because the object number changes after the flashback operationC
Because the rows are retrieved from the recycle bin during the flashback operationD
Because the table is moved forward and back to a temporary during the flashback operation
考题
单选题Your database is running in NOARCHIVELOG mode with two online redo log files. The SALES table contains sales information for the organization. The SALES table belongs to the SALESTB tablespace. On Monday， you insert 10 rows into the SALES table. The current log sequence number is 14. You change the tablespace status from READ WRITE to READ ONLY for the SALESTB tablespace. You shut down the database and take a backup of the SALESTB tablespace. On Tuesday， you start the database. You change the status for the SALESTB tablespace from READ ONLY to READ WRITE. You insert 10 more rows into the SALES table and shut down the database. The current log sequence number is 15. When you try to open the database on Wednesday morning， you discover that the SALESTB tablespace was lost because of a media failure. Which of the following options is true about recovering the SALES table？（）A
The SALES table cannot be recovered because the database is running in NOARCHIVELOG mode.B
The SALES table can be recovered by restoring the SALESTB tablespace from the backup and performing a media recovery.C
The SALES table can be recovered by restoring the SALESTB tablespace from the backup without performing any media recovery.D
The SALES table can be recovered by restoring the SALESTB tablespace from the backup， but the rows inserted on Tuesday need to be inserted again.
考题
单选题36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）A
Rows B
Totals C
Columns D
Cells E
Data
考题
单选题You create a master page named Article.master. Article.master serves as the template for articles on your Web site. The master page uses the following page directives. You need to create a content page that uses the master page as a template. In addition, you need to use a single master page for all devices that access the Web site. Which code segment should you use? （）A
%@ Page Language=VB Theme=article%B
%@ Page Language=VB MasterPageFile=~/article.master%C
%@ Page Language=VB ie:MasterPageFile=~/article.master%D
%@Page Language=VB all:MasterPageFile=~/article.master%
考题
多选题You need to design a connection agreement for Active Directory Connector to synchronize directory information with the subsidiary location. Which two actions should you perform？（）AConfigure a one-way connection agreement that replicates from the subsidiary’s Exchange 5.5 organization to Active DirectoryBConfigure a one-way connection agreement that replicates from Active Directory to the subsidiary’s Exchange 5.5 organizationCConfigure two one-way connection agreements that replicate between the subsidiary’s Exchange 5.5 organization and Active DirectoryDConfigure the connection agreement to replicate all objectsEConfigure the connection agreement to replicate only mailboxesFConfigure the connection agreement to save deletions in an LDAP Data Interchange Format file
考题
单选题Before a Flashback Table operation，you execute the following command： ALTER TABLE employees ENABLE ROW MOVEMENT； Why would you need this to be executed？（）A
Because row IDs may change during the flashback operationB
Because the object number changes after the flashback operationC
Because the rows are retrieved from the recycle bin during the flashback operationD
Because the table is moved forward and back to a temporary during the flashback opertion
考题
单选题You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master server's binary log information?（）A
Include-master-infoB
Master-binlogC
Include-log-fileD
Master-data
热门标签
最新试卷
