70-175 Microsoft - Braindumps.com.ua: question list for "Designing and Implementing Distributed Applications with MS Visual Basic 6.0", page: 6

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Microsoft 70-175: Designing and Implementing Distributed Applications with MS Visual Basic 6.0

#51. You are using RDO to issue SQL statements against a database you do not want the database to create temporary stored procedures for these statements. Which option should you use?

#52. You use ADO to execute a stored procedure on a Microsoft SQL Server database. The execution times out. You want to retry. You also want of check the ADO errors collection to see if a timeout Error occurred. Which property code should you check first?

#53. You use the Execute method to send a query to database .You have specified the rdAsyncEnable option. How should you find out whether the operation is complete?

#54. Your Visual Basic application communicates with a Microsoft SQL Sever database. The application is used to track donation Information for a nonprofit organization. The database has a Donor table and a Donation table. The fields are shown in The following table. Table Fields Donor DononID, FirsyName, LastName, Phone ,Address, City, State, Zip Donation DonationID, DonorID, Donationdate, Amount DononID is a primary key in the Donor table and a Foreign Key in the Donation table. You want to write SQL code will display records for donors who have given donations. Which SQL statement should you use?

#55. Your Visual Basic application allows the user to edit data records. You want to ensure that only one user at a time can have a record open which type of locking strategy should you use?

#56. You want to retrieve an ADO recordset that allows users to have unrestricted data manipulation and browsing functionality. You do not need the local recordset to detect records added to the database by other user, However, You need the recordset to detect any changes made to its own records?

#57. A stored procedure named GetCustomer exists on a Microsoft SQL Server database. The procedure takes the input parameter ICustomerId, which is a SQL Sever integer; the procedure returns a result set that contains the customer data. The variable iVBCustomerId contains the value of ICustomerId the name of the command object is Cmd. The command Text property of the Cmd object is set to GetCustomer. Which code fragment should you use to execute the stored procedure?

#58. A client application uses Remote Data Services (RDS) to retrieve a disconnected Recordset object from a web server. The recordset was using ADO created recordset. The recordset is named rsData. You want the client application to persist the changes made to the recordset without reconnecting to the web server

#59. You are developing a client/server application. The client application will access only some of the data in the result set .You want to minimize the amount of network traffic. Which type of database cursor should you use in the application?

#60. You develop an Activex DLL project. You add a class module Named Account to this project. The class has a method named Savings. You add a Standard EXE project to allow you to test the Savings method. You want Visual Basic to enter break mode while the Savings method is being executed. What should you do?

[1] [2] [3] [4] [5] [6] [7]

gen. 0.057

Server date 03:38 08-01-2009

Microsoft 70-175

Forum

Start online exam simulation

Master braindump