Mininterno.net - Elenco domande di 70-175: Distributed applications with Visual Basic 6

Elenco in ordine alfabetico delle domande di 70-175: Distributed applications with Visual Basic 6

Seleziona l'iniziale:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

> Clicca qui per scaricare l'elenco completo delle domande di questo argomento in formato Word!

- What are the benefits of using stored procedures for data access? [Check all that apply] Better performance.

- What are the benefits of using stored procedures for data access? [Check all that apply] The database schema can be abstracted from the calling program.

- What are the benefits of using stored procedures for data access? [Check all that apply] Increased security.

- What are the tradeoffs involved in choosing a dynamic, server-side cursor when creating an ADO recordset with SQL Server? The cursor will consume more server resources, but will be able to reflect changes made to the recordset by other users.

- What is the result of the following code if the insert into the Orders table fails? (Assume that cnSQL is a valid ADO Connection object.)

cnSQL.Execute "INSERT INTO Customers VALUES _
('Willie','Mays')
cnSQL.BeginTrans
sqlCommand = "UPDATE Products SET Quantity = _ Quantity – 1 "
sqlCommand = sqlCommand + "WHERE prodid = 15"
cnSQL.Execute sqlCommand
cnSQL.Execute "INSERT INTO Orders VALUES _ (15,1,'12/14/1998')"
cnSQL.CommitTrans
The update to the Products table is rolled back, but the Customers insert succeeds.

- What is the syntax for declaring an event, DataHasChanged, that takes no arguments in a UserControl object? Event DataHasChanged()

- What is the value of Err.Number after the following code executes?

Dim x as Integer
On Error Resume Next
x = 1/0
If Err.Number = 13 Then
MsgBox Err.Description
End If
None of the above

- What is the value of the Form1 form-level variable strName after the following code has been run?

Load Form1
Form1.strName = "Mays"
Form1.Show
Unload Form1
Mays.

- What two pieces of information are conveyed by the CODEBASE attribute of the <OBJECT> tag? The version of the component to be installed on the client computer

- What two pieces of information are conveyed by the CODEBASE attribute of the <OBJECT> tag? The location of the component to be downloaded

- What type of binding does the VB compiler use with the following code segment?

Dim obj as ACME.Customer
Set obj = CreateObject("ACME.Customer")
Either DispID binding or vtable binding

- When developing an ASP-based application, an important concept known as a user session retains the state information required to produce a single instance of application access. This concept is important because information stored within the Session object is maintained or accessible only during a session. A separate session is maintained for each user currently accessing an ASP application. During what action or event is the session established for the user? When the first ASP file is accessed or requested

- When modeling or designing a unique characteristic of a piece of data, such as an AddressID for use in an Address table in a database, how should this be physically implemented in your component? Property

- When trying to access a member within a Request object collection, failing to explicitly list the collection to be searched will result in which of the following occurring? The collections will be searched in order (Cookies, ServerVariables, ClientCertificate, Form, and Querystring), returning the first element found of the desired name.

- When would you create a dependency file using the Package and Deployment Wizard? When the project can be distributed as a part of another project

- Where must Session or Application object variables be declared prior to use within an ASP file? [Check all that apply] It is not necessary to declare Session or Application object variables prior to use.

- Which ADO objects can be created independently? [Check all that apply] Command

- Which ADO objects can be created independently? [Check all that apply] Recordset

- Which cursor type and location is the most efficient for retrieving a recordset and displaying it in an HTML table in an Active Server Page (ASP) using SQL Server? Server-side forward-only cursor

- Which event of the UserControl object is used to save properties to persistent storage? WriteProperties

- Which line of code allows you to access the Visible property provided by the container from code within a UserControl object? Extender.Visible

- Which line(s) of VBScript could be added at positions [6] and [7] in the following code to properly allow modification of the second member of the array stored in the Session object?

[0] <% ' Contents in First.asp
[1] Dim MemberIDs (2)
[2] MemberIDs (1) = "234"
[3] MemberIDs (2) = "345"
[4] Session("MemberIDs") = MemberIDs %>
[5] <% ' Contents in Second.asp
[6]
[7]
[8] Session("MemberIDs") = SecondArray %>

SecondArray = Session("MemberIDs")

- Which method can you use to configure a client computer to run a component on a different remote server once the application has been installed? Use the DCOMCNFG utility on the client computer.

- Which of the following are benefits of adopting a three-tier architecture? [Check all that apply] Business logic is more maintainable.

- Which of the following are benefits of adopting a three-tier architecture? [Check all that apply] Components can be reused in multiple applications.

- Which of the following is required to configure a Windows 95/98 system to run a distributed application that uses components running within MTS on a remote system? [Check all that apply] Install DCOM support on the client system.

- Which of the following menu properties can be set at runtime? [Check all that apply] Checked

- Which of the following menu properties can be set at runtime? [Check all that apply] Visible

- Which of the following statements regarding the Package and Deployment Wizard is false? It can create a license-packaging file for your components.

- Which segment of code should be added at line [1] to properly persist the data changed for an ActiveX DLL?

[1] …
[2] PropBag.WriteProperty "InterestRate", _ mIntRate, conDefRate
[3] End Sub
Private Sub Class_WriteProperties(PropBag As PropertyBag)

- Which SQL statement would update the last name column in the Authors table, changing its value to "Mays" for the author with an ID of "123-45-6789"? UPDATE Authors SET LName = 'Mays' WHERE au_id = '123-45-6789'

- Which two methods are valid for creating controls dynamically at runtime? Using the Load statement to add a control to an existing control array

- Which two methods are valid for creating controls dynamically at runtime? Using the Add method of the Controls collection