為大家收集整理了《2013微軟認(rèn)證考試練習(xí)題及答案（20）》供大家參考，希望對(duì)大家有所幫助！??！
QUESTION 16 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a class that contains the following code segment. (Line numbers are included for reference only.) 01 public object GetCachedProducts(sqlConnection conn) { 02 03 if (Cache["products"] == null) { 04 SqlCommand cmd = new SqlCommand( 05 "SELECT * FROM Products", conn); 07 conn.Open(); 08 Cache.Insert("products", GetData(cmd)); 09 conn.Close(); 10 } 11 return Cache["products"]; 12 } 13 14 public object GetData(SqlCommand prodCmd) { 15 16 } Each time a Web form has to access a list of products, the GetCachedProducts method is called to provide this list from the Cache object. You need to ensure that the list of products is always available in the Cache object. Which code segment should you insert at line 15? A.return prodCmd.ExecuteReader(); SqlDataReader dr; prodCmd.CommandTimeout = int.MaxValue; B.dr = prodCmd.ExecuteReader(); return dr; C.SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = prodCmd; DataSet ds = new DataSet(); return ds.Tables[0]; D.SqlDataAdapter da = new SqlDataAdapter(prodCmd); DataSet ds = new DataSet(); da.Fill(ds); return ds;
Answer: D QUESTION 17 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You write the following code segment in the code-behind file to create a Web form. (Line numbers are included for reference only.) 01 string strQuery = "select * from Products;" 02 + "select * from Categories"; 03 SqlCommand cmd = new SqlCommand(strQuery, cnn); 04 cnn.Open(); 05 SqlDataReader rdr = cmd.ExecuteReader(); 06 07 rdr.Close(); 08 cnn.Close(); You need to ensure that the gvProducts and gvCategories GridView controls display the data that is contained in the following two database tables: The Products database tabl The Categories database tabl Which code segment should you insert at line 06? A.gvProducts.DataSource = rdr; gvProducts.DataBind(); gvCategories.DataSource = rdr; gvCategories.DataBind(); B.gvProducts.DataSource = rdr; gvCategories.DataSource = rdr; gvProducts.DataBind(); gvCategories.DataBind(); C.gvProducts.DataSource = rdr; rdr.NextResult(); gvCategories.DataSource = rdr; gvProducts.DataBind(); gvCategories.DataBind(); D.gvProducts.DataSource = rdr; gvCategories.DataSource = rdr; gvProducts.DataBind(); rdr.NextResult(); gvCategories.DataBind();
Answer: D QUESTION 18 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a Web form that contains the following code fragment. You write the following code segment in the code-behind file. (Line numbers are included for reference only.) 01 protected void Page_Load(object sender, EventArgs e) 02 { 03 DataSet objDS = new DataSet(); 04 SqlDataAdapter objDA = new SqlDataAdapter(objCmd); 05 objDA.Fill(objDS); 06 gridCities.DataSource = objDs; 07 gridCities.DataBind(); 08 Session["ds"] = objDS; 09 } 10 protected void btnSearch_Click(object sender, EventArgs e) 11 { 12 13 } You need to ensure that when the btnSearch Button control is clicked, the records in the gridCities GridView control are filtered by using the value of the txtSearch TextBox. Which code segment you should insert at line 12? A.DataSet ds = gridCities.DataSource as DataSet; DataView dv = ds.Tables[0].DefaultView; dv.RowFilter = "CityName LIKE ’" + txtSearch.Text + "%’"; gridCities.DataSource = dv; gridCities.DataBind(); B.DataSet ds = Session["ds"] as DataSet; DataView dv = ds.Tables[0].DefaultView; dv.RowFilter = "CityName LIKE ’" + txtSearch.Text + "%’"; gridCities.DataSource = dv; gridCities.DataBind(); C.DataTable dt = Session["ds"] as DataTable; DataView dv = dt.DefaultView; dv.RowFilter = "CityName LIKE ’" + txtSearch.Text + "%’"; gridCities.DataSource = dv; gridCities.DataBind(); D.DataSet ds = Session["ds"] as DataSet; DataTable dt = ds.Tables[0]; DataRow[] rows = dt.Select("CityName LIKE ’" + txtSearch.Text + "%’"); gridCities.DataSource = rows; gridCities.DataBind();
Answer: B QUESTION 19 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application consumes a Microsoft Windows Communication Foundation (WCF) service. The WCF service exposes the following method. [WebInvoke] string UpdateCustomerDetails(string custID); The application hosts the WCF service by using the following code segment. WebServiceHost host = new WebServiceHost(typeof(CService), new Uri("http://win/")); ServiceEndpoint ep = host.AddServiceEndpoint(typeof(ICService), new WebHttpBinding(), ""); You need to invoke the UpdateCustomerDetails method. Which code segment should you use? A.WebChannelFactory wcf = new WebChannelFactory(new Uri("http: //win")) ;
ICService channel = wcf.CreateChannel();
string s = channel.UpdateCustomerDetails("CustID12");
B.WebChannelFactory wcf = new WebChannelFactory(new Uri("http://win/UpdateCustomerDetails"));
ICService channel = wcf.CreateChannel();
string s = channel.UpdateCustomerDetails("CustID12");
C.ChannelFactory cf = new ChannelFactory(new WebHttpBinding(), "http: //win/UpdateCustomerDetails") ;
ICService channel = cf.CreateChannel();
string s = channel.UpdateCustomerDetails("CustID12");
D.ChannelFactory cf = new ChannelFactory(new BasicHttpBinding(), "http: //win ");
cf.Endpoint.Behaviors.Add(new WebHttpBehavior());
ICService channel = cf.CreateChannel();
string s = channel.UpdateCustomerDetails("CustID12");
Answer: A QUESTION 20 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a Microsoft Windows Communication Foundation (WCF) service that exposes the following service contract. (Line numbers are included for reference only.) 01 [ServiceContract] 02 public interface IBlogService 03 { 04 [OperationContract] 05 [WebGet(ResponseFormat=WebMessageFormat.Xml)] 06 Rss20FeedFormatter GetBlog(); 07 } You configure the WCF service to use the WebHttpBinding class, and to be exposed at the following URL: http://www.contoso.com/BlogService You need to store the result of the GetBlog operation in an XmlDocument variable named xmlBlog in a Web form. Which code segment should you use? A.string url = @"http: //www.contoso.com/BlogService/GetBlog"; XmlReader blogReader = XmlReader.Create(url); xmlBlog.Load(blogReader); B.string url = @"http: //www.contoso.com/BlogService"; XmlReader blogReader = XmlReader.Create(url); xmlBlog.Load(blogReader); C.Uri blogUri = new Uri(@"http: //www.contoso.com/BlogService"); ChannelFactory blogFactory = new ChannelFactory(blogUri);
IBlogService blogSrv = blogFactory.CreateChannel();
Rss20FeedFormatter feed = blogSrv.GetBlog();
xmlBlog.LoadXml(feed.ToString());
D.Uri blogUri = new Uri(@"http: //www.contoso.com/BlogService/GetBlog");
ChannelFactory blogFactory = new ChannelFactory(blogUri);
IBlogService blogSrv = blogFactory.CreateChannel();
Rss20FeedFormatter feed = blogSrv.GetBlog();
xmlBlog.LoadXml(feed.Feed.ToString());
Answer: A
QUESTION 16 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a class that contains the following code segment. (Line numbers are included for reference only.) 01 public object GetCachedProducts(sqlConnection conn) { 02 03 if (Cache["products"] == null) { 04 SqlCommand cmd = new SqlCommand( 05 "SELECT * FROM Products", conn); 07 conn.Open(); 08 Cache.Insert("products", GetData(cmd)); 09 conn.Close(); 10 } 11 return Cache["products"]; 12 } 13 14 public object GetData(SqlCommand prodCmd) { 15 16 } Each time a Web form has to access a list of products, the GetCachedProducts method is called to provide this list from the Cache object. You need to ensure that the list of products is always available in the Cache object. Which code segment should you insert at line 15? A.return prodCmd.ExecuteReader(); SqlDataReader dr; prodCmd.CommandTimeout = int.MaxValue; B.dr = prodCmd.ExecuteReader(); return dr; C.SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = prodCmd; DataSet ds = new DataSet(); return ds.Tables[0]; D.SqlDataAdapter da = new SqlDataAdapter(prodCmd); DataSet ds = new DataSet(); da.Fill(ds); return ds;
Answer: D QUESTION 17 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You write the following code segment in the code-behind file to create a Web form. (Line numbers are included for reference only.) 01 string strQuery = "select * from Products;" 02 + "select * from Categories"; 03 SqlCommand cmd = new SqlCommand(strQuery, cnn); 04 cnn.Open(); 05 SqlDataReader rdr = cmd.ExecuteReader(); 06 07 rdr.Close(); 08 cnn.Close(); You need to ensure that the gvProducts and gvCategories GridView controls display the data that is contained in the following two database tables: The Products database tabl The Categories database tabl Which code segment should you insert at line 06? A.gvProducts.DataSource = rdr; gvProducts.DataBind(); gvCategories.DataSource = rdr; gvCategories.DataBind(); B.gvProducts.DataSource = rdr; gvCategories.DataSource = rdr; gvProducts.DataBind(); gvCategories.DataBind(); C.gvProducts.DataSource = rdr; rdr.NextResult(); gvCategories.DataSource = rdr; gvProducts.DataBind(); gvCategories.DataBind(); D.gvProducts.DataSource = rdr; gvCategories.DataSource = rdr; gvProducts.DataBind(); rdr.NextResult(); gvCategories.DataBind();
Answer: D QUESTION 18 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a Web form that contains the following code fragment. You write the following code segment in the code-behind file. (Line numbers are included for reference only.) 01 protected void Page_Load(object sender, EventArgs e) 02 { 03 DataSet objDS = new DataSet(); 04 SqlDataAdapter objDA = new SqlDataAdapter(objCmd); 05 objDA.Fill(objDS); 06 gridCities.DataSource = objDs; 07 gridCities.DataBind(); 08 Session["ds"] = objDS; 09 } 10 protected void btnSearch_Click(object sender, EventArgs e) 11 { 12 13 } You need to ensure that when the btnSearch Button control is clicked, the records in the gridCities GridView control are filtered by using the value of the txtSearch TextBox. Which code segment you should insert at line 12? A.DataSet ds = gridCities.DataSource as DataSet; DataView dv = ds.Tables[0].DefaultView; dv.RowFilter = "CityName LIKE ’" + txtSearch.Text + "%’"; gridCities.DataSource = dv; gridCities.DataBind(); B.DataSet ds = Session["ds"] as DataSet; DataView dv = ds.Tables[0].DefaultView; dv.RowFilter = "CityName LIKE ’" + txtSearch.Text + "%’"; gridCities.DataSource = dv; gridCities.DataBind(); C.DataTable dt = Session["ds"] as DataTable; DataView dv = dt.DefaultView; dv.RowFilter = "CityName LIKE ’" + txtSearch.Text + "%’"; gridCities.DataSource = dv; gridCities.DataBind(); D.DataSet ds = Session["ds"] as DataSet; DataTable dt = ds.Tables[0]; DataRow[] rows = dt.Select("CityName LIKE ’" + txtSearch.Text + "%’"); gridCities.DataSource = rows; gridCities.DataBind();
Answer: B QUESTION 19 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. The application consumes a Microsoft Windows Communication Foundation (WCF) service. The WCF service exposes the following method. [WebInvoke] string UpdateCustomerDetails(string custID); The application hosts the WCF service by using the following code segment. WebServiceHost host = new WebServiceHost(typeof(CService), new Uri("http://win/")); ServiceEndpoint ep = host.AddServiceEndpoint(typeof(ICService), new WebHttpBinding(), ""); You need to invoke the UpdateCustomerDetails method. Which code segment should you use? A.WebChannelFactory
Answer: A QUESTION 20 You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You create a Microsoft Windows Communication Foundation (WCF) service that exposes the following service contract. (Line numbers are included for reference only.) 01 [ServiceContract] 02 public interface IBlogService 03 { 04 [OperationContract] 05 [WebGet(ResponseFormat=WebMessageFormat.Xml)] 06 Rss20FeedFormatter GetBlog(); 07 } You configure the WCF service to use the WebHttpBinding class, and to be exposed at the following URL: http://www.contoso.com/BlogService You need to store the result of the GetBlog operation in an XmlDocument variable named xmlBlog in a Web form. Which code segment should you use? A.string url = @"http: //www.contoso.com/BlogService/GetBlog"; XmlReader blogReader = XmlReader.Create(url); xmlBlog.Load(blogReader); B.string url = @"http: //www.contoso.com/BlogService"; XmlReader blogReader = XmlReader.Create(url); xmlBlog.Load(blogReader); C.Uri blogUri = new Uri(@"http: //www.contoso.com/BlogService"); ChannelFactory
Answer: A