You are developing an application that tracks tennis matches. A match is represented by the following class:

A match is created by using the following code:

How many times is the Location property on the newly created Match class assigned?

• A.0
• B.3
• C.2
• D.1

Comment: *

Name: *

Email: *

Verification: *

This question requires that you evaluate the underlined text to determine if it is correct.
To improve performance, a SQL SELECT statement should use indexes.
Select the correct answer if the underlined text does not make the statement correct. Select "No change is needed'' if the underlined text makes the statement correct.

• A.No change is needed
• B.joins
• C.grouping
• D.ordering

Comment: *

Name: *

Email: *

Verification: *

You have a SQL Server database named MyDB that uses SQL Server Authentication.
Which connection string should you use to connect to MyDB?

• A.Data Source=MyDB; UserID=username; Password=P@sswOrd; Initial Catalog=Sales
• B.Data Source=MyDB; Integrated Security=SSPI; Initial Catalog=Sales
• C.Data Source=MyDB; Integrated Security=True; Initial Catalog=Sales
• D.Data Source=MyDB; Trusted_Connection=True; MultipleActiveResultSets=True; Initial Catalog=Sales

Comment: *

Name: *

Email: *

Verification: *

You have a server that limits the number of data connections.
What should you use to optimize connectivity when the number of users exceeds the number of available connections?

• A.Normalization
• B.Connection pooling
• C.Connection timeouts
• D.Named pipes

Comment: *

Name: *

Email: *

Verification: *

You are developing a Web page for a medium-sized business.
You want to separate the formatting and layout of the page from its content.
Which of the following technologies should you use to define the formatting and layout of the page content?

• A.Cascading Style Sheet (CSS)
• B.JavaScript
• C.Hypertext Transmission Protocol (HTTP)
• D.Hypertext Markup Language (HTML)

Comment: *

Name: *

Email: *

Verification: *