CMS专题
多选题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 valueBC
题目
Each extra column in the copy with more columns must not have a default value
Columns that are common to both versions of the table must be defined in the same order on the master and the slave
The slave database cannot have more columns than the master. Only the master database can have more columns
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
The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
相似问题和答案
第1题：
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-info
B.Master-binlog
C.Include-log-file
D.Master-data
第2题：
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.
解析：Explanation:
A: Bulk update locks are taken when bulk copying data into a table and either the TABLOCK hint is specified, or the table lock on bulk load table option is set using sp_tableoption. Bulk update locks allow processes to bulk copy data concurrently into the same table while preventing other processes that are not bulk copying data from accessing the table. In this scenario the bulk update lock would meet the requirement that data should be loaded as quickly as possible.
B: SQL Server 2000 allows data to be bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement. This can improve the performance of data load operations. To bulk copy data into an instance of SQL Server in parallel, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.
E: By specifying the Bulk-Logged Recovery model, the logging for all SELECT INTO, CREATE INDEX, and bulk loading data operations will be minimal and will therefore require less log space while also improving performance.
Incorrect Answers:
C: When data is bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement to improve the performance of data load operations, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.
D: When data is bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement to improve the performance of data load operations, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.
第3题：
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.
第4题：
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-info
- B、Master-binlog
- C、Include-log-file
- D、Master-data
正确答案:D
第5题：
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.
正确答案:B
第6题：
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
第7题：
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_INVENTORY
- B、Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table
- C、Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table
- D、Set binlog_format=MIXED with the – replicate-ignore-temp-table option
- E、Use the – replicate-ignore-table option with the value equal to OLD_INENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table
正确答案:B,E
第8题：
A. Because row IDs may change during the flashback operation
B. Because the object number changes after the flashback operation
C. Because the rows are retrieved from the recycle bin during the flashback operation
D. Because the table is moved forward and back to a temporary during the flashback opertion
第9题：
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"%>
正确答案:B
第10题：
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.
正确答案:C