70-293 braindumps

QUESTION 1
You work as a software developer at Certkiller .com. You develop a Windows-based
application to manage inventory. The application calls a Microsoft SQL Server
stored procedure named sp_Update Certkiller Prices.
sp_Update Certkiller Prices performs a SQL UPDATE statement that increases
prices for selected items in an inventory table. It returns an output parameter
named @totalprice as a result set that contains all of the records that were updated.
@totalprice contains the sum of the prices of all items that were updates.
You implement a SqlCommand object that executes sp_Update Certkiller Prices and
returns the results to a SqlDataReader object. The SqlDataReader object gives you
access to the data in the result set, which is displayed in a list box on your Windows
Form.
The value of @totalprice must also be displayed in a text box on your Windows
Form. You need to write code that will retrieve this value.
Which code segment should you use?
A. Do Until reader.Read()
TextBox1.Text = _
com.Parameters(“@totalprice”).ValueToString()
Loop
reader.Close()
B. While reader.Read()
TextBox1.Text = _
com.Parameters(“@totalprice”).ValueToString()
End While
C. reader.Close()
TextBox1.Text = _
com.Parameters(“@totalprice”).Value.ToString()
reader.Close()
D. reader.Close()
TextBox1.Text = _
com.Parameters(“@totalprice”).Value.ToString()
Answer: D
Not C: Closing the reader twice.
QUESTION 2
You develop a Windows-based application. You plan to use ADO.NET to call a
Microsoft SQL Server stored procedure named EmployeeData. This procedure
accepts a parameter for querying the database by an employee’s family name.
You need to add code to your application to set up the parameter for use with the
stored procedure.
Which three lines of code should you add? (Each correct answer presents part of the
solution. Choose three.)

Actualtests.org – The Power of Knowing
A. Dim parm1 As New SqlParameter()
B. Dim parm1 As New SqlParameter(“@FamilyName”, _
Sq1DbType.VarChar)
C. parm1.Direction = ParameterDirection.Input
D. parm1.Direction = ParameterDirection.InputOutput
E. cmd.Parameters.Add(parm1)
F. parm1.Add(cmd)
Answer: B, C, E
Explanation:
B: The names of the parameter added must match the names of the parameter markers in
your stored procedure.
C: The parameter is used as an input parameter.
E: We add the parameter to the command.
Reference:
.NET Framework Class Library, SqlParameter Class [Visual Basic]
.NET Framework Class Library, SqlParameter Members
.NET Framework Class Library, SqlParameter Constructor () [Visual Basic]
.NET Framework Class Library, SqlParameter Constructor (String, SqlDbType) [Visual
Basic]
Incorrect Answers
A: We should specify the name of the parameter and its value.
D: The parameter is an input parameter, not an input/output parameter.
F: The parameter should be added to the command, not vice versa.
QUESTION 3
You develop a Windows-based customer service application that includes a search
feature. Users will enter characters in a text box to look up customer information by
family name.
For convenience, users must be able to perform a search by entering only the first
few characters of the family name. To enable this functionality, your application
will capture the users input and stores it in a variable named CKName. Your
application must then submit a Microsoft SQL Server query to the central customer
service database.
How should you write the query?
A. SQL = “SELECT PersonalName, FamilyName FROM ” & _
“Customers WHERE FamilyName = ‘” & CKName & “%’”
B. SQL = “SELECT” PersonalName, FamilyName FROM ” & _
“Customers WHERE FamilyName LIKE ‘” & CKName & “%’”
C. SQL = SELECT PersonalName, FamilyName FROM ” & _
“Customers WHERE FamilyName = ‘” & CKName & “*’”
D. SQL = “SELECT PersonalName, FamilyName FROM ” & _

Actualtests.org – The Power of Knowing
“Customers WHERE FamilyName LIKE ‘” & CKName & “*’”
Answer: B
Explanation: The SQL server LIKE Transact-SQL command LIKE determines
whether or not a given character string matches a specified pattern. % is used as a
wildcard character.
Reference: SQL Server Books Online, LIKE
Incorrect Answers
A: We must use the LIKE keyword.
C: We must use the LIKE keyword with the % wildcard character.
D: %, not *, is used as a wildcard character.