Searching for "select"

Q:

You are creating an ASP.NET page for selling movie tickets. Users select a region, and then they select from a list of cities in that region. The site displays the names and locations of movie theaters in the city selected by the user.


Your company, XYZ Brothers, maintains a list of theaters in a database table that includes the city, name, and street address of each theater. You want to minimize the time required to retrieve and display the list of theater names after a user selects the region and city.

 

 What should you do?

A) Modify the connection string to add the packet size property and set its values to 8192. B) Add the following directive to the page: OutputCache VaryByParam=?
C) Add the following directive to the page: OutputCache VaryByControl=?region;city? D) Modify the connection string to keep your database's connection pool as small as possible.
 
Answer & Explanation Answer: B) Add the following directive to the page: OutputCache VaryByParam=?

Explanation:

You can vary user control output to the cache by specifying the user control name and the parameter. We use the VaryByParam attribute of the  OutputCache  

 

Incorrect Answers: 

 

A: The Packet Size property of the Connection string is the size in bytes of the network packets sed to communicate with an instance of data provider. It is not an optimal property to change to optimize data retrieval.

 

C: The company database does not seem to include a region column.

 

D: If we keep the connection pool small we would allow less simulation connections. However, this would not minimize the required to retrieve and display the data.

Report Error

View Answer Report Error Discuss

Q:

You are a member of a team of developers creating several ASP.NET applications for XYZ. You want to create a reusable toolbar that will be used in each of the applications. The toolbar will be displayed at the top of each page viewed by the user.


The contents of the toolbar will vary depending on options each user selects when creating a profile.


You want to be able to add the toolbar to the ASP.NET toolbox for each of the developers on your team.What should you do?

A) Create a new Web Control Library project. Create the toolbar within a Web custom control. B) Add a new Web user control to your ASP.NET project. Create the toolbar within the Web user control.
C) Add a new Web Form to your ASP.NET project. Design the toolbar within the Web Form and save the Web Form with an .ascx extension. D) Add a new component class to your ASP.NET project. Design the toolbar within the designer of the component class.
 
Answer & Explanation Answer: A) Create a new Web Control Library project. Create the toolbar within a Web custom control.

Explanation:

Web custom controls are compiled code, which makes them easier to use but more difficult to create. You can add a Web custom control to the Toolbox and display it in a visual designer with full Properties window support and all the other design-time features of ASP.NET server controls. 

 

Incorrect Answers:

B: Web user controls are easy to make, but they can be less convenient to use in advanced scenarios such as this. Because Web user controls are compiled dynamically at run time they cannot be added to the Toolbox


C: A Web form would be inadequate.

 

D: The Component class Provides the base implementation for the IComponent interface and enables object-sharing between applications. It does not fit in this scenario.

Report Error

View Answer Report Error Discuss

Q:

You are creating an ASP.NET page for a travel service. The page contains a CheckBoxList control that contains travel destinations. Customer can select favorite destinations to receive weekly e-mail updates of travel packages.

 

The CheckBoxList control is bound to a database table of possible destinations. Each destination is ranked according to its popularity. You modify the page to sort the destination list by rank, from the most popular to the least popular. The list has three columns.

 

You want the most popular destination to be on the top row of the check box list at run time. Which property setting should you use for the CheckBoxList control?

A) Set the RepeatDirection property to Vertical. B) Set the RepeatDirection property to Horizontal.
C) Set the RepeatLayout property to Flow. D) Set the RepeatLayout property to Table.
 
Answer & Explanation Answer: B) Set the RepeatDirection property to Horizontal.

Explanation:

The DataList.RepeatDirection property is used to get or select whether the DataList control displays vertically or horizontally. If this property is set to RepeatDirection.Horizontal, the items in the list are displayed in rows loaded from left to right, then top to bottom, until all items are rendered.

 

Incorrect Answers:

A: If the DataList.RepeatDirection property is set to RepeatDirection.Vertical, the items in the list are displayed in columns loaded from top to bottom, then left to right, until all items are rendered.


C, D:DataList.RepeatLayout Property gets or sets whether the control is displayed in a table or flow layout. It does not affect the order in which the items are displayed.

Report Error

View Answer Report Error Discuss

Q:

What happens when you drop a dimension into a blank part of a report that contains two blocks, without the ALT key selected?

A. The currently selected cell is displayed.

B. A new section is created

C. A new block is created.

D. An error message is displayed.

Answer

Answer : B

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

You are working with a previously saved document and you have deleted a logical operator. Which two methods can you use to recover the logical operator?

A. Click the Undo button in the Query panel.

B. Rebuild the filters.

C. Close the Query panel without executing and then open the query

D. From the Tools menu, select Recover Operator.

Answer

Answer : B , C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which message appears when you select Use query drill while Scope of Analysis is set in a BusinessObjects Web Intelligence XI 3.0 report?

A. The Scope of Analysis is empty

B. The query drill mode option is enabled

C. The query drill mode option is not enabled

D. The Scope of Analysis is not empty

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which tab should you use to change the page orientation of a report?

A. Select the report tab; in Report Manager, select the Properties tab and select the Page Orientation

B. Click File Page Setup and select Page Orientation

C. In InfoView Preferences, change the default page orientation

D. Select the report page; in Report Manager, select the Properties tab and select the Page Orientation

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

Q:

Which method should you use to group query filters together to form one AND statement?

A. Select the filters, then click the Group Filters button on the toolbar

B. Select the filters, right-click and select Group

C. Drag the queries together

D. Drag the query filters to the Group panel

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW