You are developing a client/sever application that must accommodate a Microsoft Windows based interface and a Web interface. You want to ensure that the application supports security based on user roles. In which two layers can you map permissions to roles to support this design? (Choose two) A. in the database B. in the client objects C. in the server objects D. in the user interface code
Answer: A, C
What are the tasks that can be performed by creating customized scripts using the package and deployment wizard in a project?
What must be done to use data environment designer to place controls and labels which will be bound to the result set of a stored procedure that already exists in the database on a form?
You are developing a client/server application. You want to minimize the development time necessary to connect data-bound controls to a SQLSERVER database. Which data-access method should you use?A. ADO connected directly to SQL SERVER B. RDO connected directly to SQL SERVER C. DAO connected to SQL SERVER via the jet engine D. ADO connected to SQL SERVER via data-aware classes
Answer: A
How to ensure early binding is used when calling the methods of COM used by a client application and the reference of the component is stored in a variable?
You are developing a client/sever application. The application calls a stored procedure that returns multiple large result sets. You want your application to process all of the result sets that are returned. Which properties of the ADO recordset should you set? A. CursorLocation=adUseClient and any cursor type B. CursorLocation=adUseSever and any cursor type C. CursorLocation=adUseServer and CursorType = adOpenDynamic D. Any cursor location and CursorType = adOpenkeyset
Answer: A
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?A. Dynamic server-side cursor B. Dynamic keyset client-side with pessimistic locking C. Static client-side cursor with optimistic locking D. Non-keyset client-side cursor.
Answer: A
What is the command used to roll back all actions that are part of the transactions in an application that uses an ObjectContext variable to maintain the connection to objects created using MTS component package?
What must be done to pass data from the database to controls on a UI form in an n-tier application having user interface (UI), business objects, data objects, and database layers?
