Braindump för 70-175 test
Förord
Jag tycker att man borde varna för MS Press böckerna för 70-175 och 70-176 då dessa båda är totalt värdelösa. Jag köpte båda dessa och de innehåller inget matnyttigt inför certifieringen - de funkar bättre för de som är nybörjare på VB. De flesta tror nog MS Press böckerna borde vara de bästa men så är alltså inte fallet.Innehåll
Samma varning vill jag ge för MS-Press boken för cert 70-100. 70-100 går inta att plugga till då det är ett mer praktiskt prov jag har även fått rekommendationen att ta 70-229 (SQL 2000) först då den liksom 70-100 innehåller mycket normalisering mm fast på ett mer teoretiskt plan.
Här kommer några frågor som skrivits och detta är en sammanställning. Skulle tro att en stor del av dessa frågor finns med:
1. In what sequence the form is loaded ?
a) Initialize, load, resize, paint.
2. You have an active-x component which you want to distribute over the web, how to minimize the download time?
3. How would you display your web site map ?
a) treeview
4. what files are created for distributing your files over the web ?
a) .cab
5. You have a command button on form1 with some code in its click event. You remove the command button from the form1 & place it to form2. What happens to the code ?
6. In your web document, you have a help menu item which will take the user to your personal web site. How will you do that ?
7. Explain what happens when the following procedure is executed 4 times.
function foo()
static x as integer.
if x<=4 then
exit sub
else
x=x/0
...
some error handling code etc..
Cascading events.
8. In command1 click you trigger command2 and in command click you set the command1 value to true. What will happen?
a) A stack overflow
9. You have created an application. In the Help menu, you have an option to navigate to a WWW site. What you should make use of ?
a)Winsock
b)Hyperlink *
10. How many instances of class1 is created ?
dim a as class1
dim b as new class1
b.MyPropertiy = true
set a = new class1
a) 0
b) 1
c) 2 *
d) 3
11. Which of the following is required for early binding ?
a) type library *
b) New Keyword (* if two answers are asked for)
c) Createobject()
12. Which property of Err object gives you an idea of where the error has occured ?
a) Number
b) Description
c) Source *
d) Name
13. Private sub mysub() as integer
static count as integer
if count >= 4 then
exit sub
else
mysub
end if
end sub
What will be the output ?
a) Compile error
b) Out of stack error *
c) No error
14. You have debug statement in your project. You don't want them to be compiled. What can you do:
a) Conditional compilation *
b) Use Edit and Replace
15. You are making use of pass by reference. How will you optimize numeric calculation.
a)Assume no aliasing
b)Remove FDIV checks * (if two answers are asked for)
c) Remove floating point error checks *
16. You have created a class. You want other members of your project to access it. You want them to access it like an app object. How do you set the instancing ?
a) Globalmultiuse *
b) multiuse * (depends how it´s reffered to)
c) Publicnotcreatable
d) Private
17. Use of Visual Component Manager?
a) Find and reuse it.
18. VSS only check in those file that can be compiled. no other file. branching. manually compiled and then check in. * label it as a compiled?
19. DCOMCNFG: John-T on client comp. he wants to access server component. u want to give access to John-T. what will u do by running DCOMCNFG on server?
a) give access permission to sys agent
b) give launching permission to sys agent
c) give access permission to jone ( answer)
d) give launching permission to jone ( answer )
20. To access MTS server from win-95 what is reqd?
a) DCOM(*)
b) Application executable(*)
c) MTS
21. Early binding is reqd. u want to access component in MTS explorer from VB-IDE?
a) reference MTS component dll(*)
b) reference MTS
c) add prj. to std exe.
22. You want to save prop. of document which event u will use it is being closed?
a) terminate
b) write properties(*)
c) initialise.
23. You want to use third party control. which type of declaration u will use to declare it?
a) OLE
b) UserControl
c) vbCtrlextender.(*)
d) user document.
24. VBD - multiple forms how will u navigate?
a) Hyperlink(*)
25. Document compiled and u want to reference it? which file.
a) .vbd(*)
26. Your app marked as unattended execution. no user interface. You want to report errors. How will report log events to winnt?
a) msgbox.
27. You want to know name of container which prop. u will use?
a) userdoc.Parent(*)
b) .container.
c) TypeName(UserDocument.Parent)
28. When unattended execution check mark is enabled?
a) when activex compo. is user control
b) when activex compo. is dll with form
c) when activex compo. is exe with form
d) when activex compo. is exe without any form.(*) (answer)
e) when activex compo. is dll without any form.(*) (answer)
29. DHTML provides which adv? (all that apply)
a) client cannot see code.( answer)
b) processing is done on server
c) web browser independent.
d) runs on client side.(*) ( answer)
e) existing VB skills can be used.(*)
f) vb debugging can be done. (*)
g) // Source Code is available ( answer)
30. You want to execute SQL command with RDO and u dont want temporary compilation of SQL?
a) rdExecuteDirect(*)
b) sqlExecuteDirect
c) rd-Oledb
31. You are using DataEnvironment and u want to use data bound control? choose 2
a) add connection to data environment.( answer)
b) add command to DE and drag and drop.(*) ( Answer)
c) changing the binding of data to diff. controls.
d) check for other options.
32. You have updated a control and u dont want existing user to use new control?
a) no compatibility (*) ( Answer)
b) binary compatibility
c) prj. compatibility.
33. command returns multiple recordset. how will u use it?
a) set rs = rs.NextRecordset without closing rs. ( Answer)
34. You want to check MTS compo. security programatically how would u do it?
a) if objcontext.IsSecurityEnable then
if IsCallerInRole("manager") then
allow access
else
deny access
end if
else
deny access
end if
35. You want to fill combobox with some data. type of cursor and location?
a) client side forward only(*) ( answer )
b) I think answer would be rather Server Side and Forward , Read only cursor. and if client side than with static cursor.
36. You want to reduce network traffic. choose 3
a) use variant array ( answer)
b) string buffer ( answer)
c) use ADO disconnected recordset ( answer)
37. You want to detect url
a) webclass.URLFor(details) (*) ( answer)
b) locate
38. In debugger u want to see all form controls. choose 2.
a) locals window (*) ( answer)
b) watchs window (*) (answer)
39. Form contains text box. You want to break app when text becomes Linda.
a) textbox.text = "Linda" break when expr. is true.(*)
b) If the context is all Proc.s and all modules than the it would be rather form1.text1.text = "Linda"
40. You want to watch var. it shows out of context. reason?
a) variable out of scope(*)
41. Which type of compo. u will use for multiuse.
a) activex dll(*)
b) active exe
c) std. exe
d) activex ctrl
42. Client is multithreaded. it uses com dll.
a) apartment threaded(*) ( Answer)
b) single use
c) multiuse
d) thread pool
43. You are using thin client to avoid reinstallation. what are possible server.
a) MSMQ
b) MTS
c) MTS DTC
d) IIS(*)
44. You are using P & D script. what are advantages for creating templates
b) scripts can run in silent mode(*)
c) save settings for simillar prjs.(*)
d) for further developmewnts ( * )
45. How to launch popup menu.
a) me.PopupMenu mnupopup(*) ( answer)
b) me.PopupMenu(mnupopup)
46. Centralised helpfile for app. and You want to use same file for raising errors with list coding. choose 2
a) err.Helpfile(*)
b) err.HelpContext(*)
47. There are 3 COM objets used in app. each obj contains save ,add, delete, modify. uniquely coded in each obj. depending on type of obj. what is best methods to do this.
a) create an abstract class and using implements keyword code
b) each method in respective classes.(*) ( Answer)
48. There is a repeated time out error in ADO connection. u want to check errors.which first stmt should You execute to check error.
a) cn.Errors(0).number(*) ( Answer)
b) cn.Errors(0).source
c) cn.Errors(1).desc
d) cn.Errors(1).source
49. COM component freezes on server. You want to handle error. how to do it?
a) different developer developing server and client compo.
b) err.raiseevent
c) error logging
d) App object logging ( answer)
50. which of the code will compile in Windows95?
#if win32 then
declaration 1
#else
declaration 2
#endif
a) Declaration 1
51. For dynamic load balancing (without MTS) how do you implement dynamic load balancing method to method basis.
a) You will develop client side COM object thro' which you route server request using dynamic load balancing algorithm. inside these objects.(*)
52. what is the order of following commands?
a) open, begintrans, execute.(*)
53. You want to do something directly in data base. best option?
a) Trough UI
b) Trough client side object.
c) Trough data object ( answer)
d) Trough stored procedure.
54. You are using ActiveX ctrl in your project. you want it to appear it in tool box. How?
a) project->components(*)
55. You want to add records of ado to flex grid. line no. given to reference?
a) line no10: recordset.open
b) line no11: set flexgrid.datasource = rs (*) ( answer)
56. You want map text boxes text property to a controls text prop. how will you do it?
a) public property get text()
text = textbox.text
end property
public property let text(Byval strtext as string)
textbox.text = strtext
end property
57. Property read/write within component itself but read only to client?
a) public property get text() (*)
b) friend property let text(Byval strtext as string)
58. Property read/write within module but read only to other modules?
a) public property get text()
b) private property let text(Byval strtext as string)
59. How to add MTS component? choose 2
a) create a blank package and add component to it.(*) ( answer)
b) drag and drop to right pane of explorer prebuilt
c) package which contains component thro' explorer.
d) add prebuilt package which contains component.(*) (answer)
60. You want to deploy , register , want access trough internet. how to do?
a) P & D
61. How to register com dll?
a) regsvr32.exe dllname(*) ( Answer)
b) compile dll (*) ( Answer)
62. how to register exe?
a) exename /regserver(*) (Answer)
b) compile(*) ( Answer)
63. You have an address component connected to database with fields add id, city, street name , time stamp, created by, creation date. What fields will be exposed in business object trough user interface?
a) City, Street Name Created By
64. How to declare object for early binding? choose 2
a) dim obj as new prj1.cls1(*)
b) dim obj as prj1.cls1 (*)
c) set obj = Getobject("","prj1.cls1")
65. You want to map data control to?
a) Business object
b) data object (*)
c) database
66. Optimistic locking in ADO. when it locks?
a) during update method.
67. To execute SQL commands repeatedly. for better performance what will you do?
a) Set prepared property of Command object to True ( Used Command Object)
68. How to add tool bar to cool bar.
a) Set child property of Coolbar to handle to window of toolbar.
69. What u will make emp-id?
a) property(*)
b) method
c) event
70. callback function used in enumproc window function is defined in?
a) class module
b) standared module(*)
c) form module
71. Stored procedure on server returns large amount of data which is to be processed, What cursor location and Recordset type to use?
a) aduseclient
b) aduseserver(*)
c) aduseserver with dynamic
72. To minimize development time of data control. which type of connection you will use?
a) SQL server
b) Direct connect ADO to database.(*)
c) DAO trough JET
d) ADO data aware class.
73. You want to enable/disable security. which layer u will use?
a) Security is implemented in MTS and database (SQL server).
74. MTS object by default early binding.
You are creating a four layered solution. UI, client side objects, server side objects, database. Now you want to populate a combo box in the UI with data in the database.
a) populate the combobox directly from the database.
b) Send the data from the database to server side objects, then use those objects to populate the combobox directly.
d) Send the data from database to server side objects, from server objects to client objects, and then to the combobox in UI.(*)
62). #to reduce n/w trip? choose 3
stored procedure disconnected rs client cursor
Här kommer några frågor som skrivits och detta är en sammanställning. Skulle tro att en stor del av dessa frågor finns med:
1. In what sequence the form is loaded ?
a) Initialize, load, resize, paint.
2. You have an active-x component which you want to distribute over the web, how to minimize the download time?
3. How would you display your web site map ?
a) treeview
4. what files are created for distributing your files over the web ?
a) .cab
5. You have a command button on form1 with some code in its click event. You remove the command button from the form1 & place it to form2. What happens to the code ?
6. In your web document, you have a help menu item which will take the user to your personal web site. How will you do that ?
7. Explain what happens when the following procedure is executed 4 times.
function foo()
static x as integer.
if x<=4 then
exit sub
else
x=x/0
...
some error handling code etc..
Cascading events.
8. In command1 click you trigger command2 and in command click you set the command1 value to true. What will happen?
a) A stack overflow
9. You have created an application. In the Help menu, you have an option to navigate to a WWW site. What you should make use of ?
a)Winsock
b)Hyperlink *
10. How many instances of class1 is created ?
dim a as class1
dim b as new class1
b.MyPropertiy = true
set a = new class1
a) 0
b) 1
c) 2 *
d) 3
11. Which of the following is required for early binding ?
a) type library *
b) New Keyword (* if two answers are asked for)
c) Createobject()
12. Which property of Err object gives you an idea of where the error has occured ?
a) Number
b) Description
c) Source *
d) Name
13. Private sub mysub() as integer
static count as integer
if count >= 4 then
exit sub
else
mysub
end if
end sub
What will be the output ?
a) Compile error
b) Out of stack error *
c) No error
14. You have debug statement in your project. You don't want them to be compiled. What can you do:
a) Conditional compilation *
b) Use Edit and Replace
15. You are making use of pass by reference. How will you optimize numeric calculation.
a)Assume no aliasing
b)Remove FDIV checks * (if two answers are asked for)
c) Remove floating point error checks *
16. You have created a class. You want other members of your project to access it. You want them to access it like an app object. How do you set the instancing ?
a) Globalmultiuse *
b) multiuse * (depends how it´s reffered to)
c) Publicnotcreatable
d) Private
17. Use of Visual Component Manager?
a) Find and reuse it.
18. VSS only check in those file that can be compiled. no other file. branching. manually compiled and then check in. * label it as a compiled?
19. DCOMCNFG: John-T on client comp. he wants to access server component. u want to give access to John-T. what will u do by running DCOMCNFG on server?
a) give access permission to sys agent
b) give launching permission to sys agent
c) give access permission to jone ( answer)
d) give launching permission to jone ( answer )
20. To access MTS server from win-95 what is reqd?
a) DCOM(*)
b) Application executable(*)
c) MTS
21. Early binding is reqd. u want to access component in MTS explorer from VB-IDE?
a) reference MTS component dll(*)
b) reference MTS
c) add prj. to std exe.
22. You want to save prop. of document which event u will use it is being closed?
a) terminate
b) write properties(*)
c) initialise.
23. You want to use third party control. which type of declaration u will use to declare it?
a) OLE
b) UserControl
c) vbCtrlextender.(*)
d) user document.
24. VBD - multiple forms how will u navigate?
a) Hyperlink(*)
25. Document compiled and u want to reference it? which file.
a) .vbd(*)
26. Your app marked as unattended execution. no user interface. You want to report errors. How will report log events to winnt?
a) msgbox.
27. You want to know name of container which prop. u will use?
a) userdoc.Parent(*)
b) .container.
c) TypeName(UserDocument.Parent)
28. When unattended execution check mark is enabled?
a) when activex compo. is user control
b) when activex compo. is dll with form
c) when activex compo. is exe with form
d) when activex compo. is exe without any form.(*) (answer)
e) when activex compo. is dll without any form.(*) (answer)
29. DHTML provides which adv? (all that apply)
a) client cannot see code.( answer)
b) processing is done on server
c) web browser independent.
d) runs on client side.(*) ( answer)
e) existing VB skills can be used.(*)
f) vb debugging can be done. (*)
g) // Source Code is available ( answer)
30. You want to execute SQL command with RDO and u dont want temporary compilation of SQL?
a) rdExecuteDirect(*)
b) sqlExecuteDirect
c) rd-Oledb
31. You are using DataEnvironment and u want to use data bound control? choose 2
a) add connection to data environment.( answer)
b) add command to DE and drag and drop.(*) ( Answer)
c) changing the binding of data to diff. controls.
d) check for other options.
32. You have updated a control and u dont want existing user to use new control?
a) no compatibility (*) ( Answer)
b) binary compatibility
c) prj. compatibility.
33. command returns multiple recordset. how will u use it?
a) set rs = rs.NextRecordset without closing rs. ( Answer)
34. You want to check MTS compo. security programatically how would u do it?
a) if objcontext.IsSecurityEnable then
if IsCallerInRole("manager") then
allow access
else
deny access
end if
else
deny access
end if
35. You want to fill combobox with some data. type of cursor and location?
a) client side forward only(*) ( answer )
b) I think answer would be rather Server Side and Forward , Read only cursor. and if client side than with static cursor.
36. You want to reduce network traffic. choose 3
a) use variant array ( answer)
b) string buffer ( answer)
c) use ADO disconnected recordset ( answer)
37. You want to detect url
a) webclass.URLFor(details) (*) ( answer)
b) locate
38. In debugger u want to see all form controls. choose 2.
a) locals window (*) ( answer)
b) watchs window (*) (answer)
39. Form contains text box. You want to break app when text becomes Linda.
a) textbox.text = "Linda" break when expr. is true.(*)
b) If the context is all Proc.s and all modules than the it would be rather form1.text1.text = "Linda"
40. You want to watch var. it shows out of context. reason?
a) variable out of scope(*)
41. Which type of compo. u will use for multiuse.
a) activex dll(*)
b) active exe
c) std. exe
d) activex ctrl
42. Client is multithreaded. it uses com dll.
a) apartment threaded(*) ( Answer)
b) single use
c) multiuse
d) thread pool
43. You are using thin client to avoid reinstallation. what are possible server.
a) MSMQ
b) MTS
c) MTS DTC
d) IIS(*)
44. You are using P & D script. what are advantages for creating templates
b) scripts can run in silent mode(*)
c) save settings for simillar prjs.(*)
d) for further developmewnts ( * )
45. How to launch popup menu.
a) me.PopupMenu mnupopup(*) ( answer)
b) me.PopupMenu(mnupopup)
46. Centralised helpfile for app. and You want to use same file for raising errors with list coding. choose 2
a) err.Helpfile(*)
b) err.HelpContext(*)
47. There are 3 COM objets used in app. each obj contains save ,add, delete, modify. uniquely coded in each obj. depending on type of obj. what is best methods to do this.
a) create an abstract class and using implements keyword code
b) each method in respective classes.(*) ( Answer)
48. There is a repeated time out error in ADO connection. u want to check errors.which first stmt should You execute to check error.
a) cn.Errors(0).number(*) ( Answer)
b) cn.Errors(0).source
c) cn.Errors(1).desc
d) cn.Errors(1).source
49. COM component freezes on server. You want to handle error. how to do it?
a) different developer developing server and client compo.
b) err.raiseevent
c) error logging
d) App object logging ( answer)
50. which of the code will compile in Windows95?
#if win32 then
declaration 1
#else
declaration 2
#endif
a) Declaration 1
51. For dynamic load balancing (without MTS) how do you implement dynamic load balancing method to method basis.
a) You will develop client side COM object thro' which you route server request using dynamic load balancing algorithm. inside these objects.(*)
52. what is the order of following commands?
a) open, begintrans, execute.(*)
53. You want to do something directly in data base. best option?
a) Trough UI
b) Trough client side object.
c) Trough data object ( answer)
d) Trough stored procedure.
54. You are using ActiveX ctrl in your project. you want it to appear it in tool box. How?
a) project->components(*)
55. You want to add records of ado to flex grid. line no. given to reference?
a) line no10: recordset.open
b) line no11: set flexgrid.datasource = rs (*) ( answer)
56. You want map text boxes text property to a controls text prop. how will you do it?
a) public property get text()
text = textbox.text
end property
public property let text(Byval strtext as string)
textbox.text = strtext
end property
57. Property read/write within component itself but read only to client?
a) public property get text() (*)
b) friend property let text(Byval strtext as string)
58. Property read/write within module but read only to other modules?
a) public property get text()
b) private property let text(Byval strtext as string)
59. How to add MTS component? choose 2
a) create a blank package and add component to it.(*) ( answer)
b) drag and drop to right pane of explorer prebuilt
c) package which contains component thro' explorer.
d) add prebuilt package which contains component.(*) (answer)
60. You want to deploy , register , want access trough internet. how to do?
a) P & D
61. How to register com dll?
a) regsvr32.exe dllname(*) ( Answer)
b) compile dll (*) ( Answer)
62. how to register exe?
a) exename /regserver(*) (Answer)
b) compile(*) ( Answer)
63. You have an address component connected to database with fields add id, city, street name , time stamp, created by, creation date. What fields will be exposed in business object trough user interface?
a) City, Street Name Created By
64. How to declare object for early binding? choose 2
a) dim obj as new prj1.cls1(*)
b) dim obj as prj1.cls1 (*)
c) set obj = Getobject("","prj1.cls1")
65. You want to map data control to?
a) Business object
b) data object (*)
c) database
66. Optimistic locking in ADO. when it locks?
a) during update method.
67. To execute SQL commands repeatedly. for better performance what will you do?
a) Set prepared property of Command object to True ( Used Command Object)
68. How to add tool bar to cool bar.
a) Set child property of Coolbar to handle to window of toolbar.
69. What u will make emp-id?
a) property(*)
b) method
c) event
70. callback function used in enumproc window function is defined in?
a) class module
b) standared module(*)
c) form module
71. Stored procedure on server returns large amount of data which is to be processed, What cursor location and Recordset type to use?
a) aduseclient
b) aduseserver(*)
c) aduseserver with dynamic
72. To minimize development time of data control. which type of connection you will use?
a) SQL server
b) Direct connect ADO to database.(*)
c) DAO trough JET
d) ADO data aware class.
73. You want to enable/disable security. which layer u will use?
a) Security is implemented in MTS and database (SQL server).
74. MTS object by default early binding.
You are creating a four layered solution. UI, client side objects, server side objects, database. Now you want to populate a combo box in the UI with data in the database.
a) populate the combobox directly from the database.
b) Send the data from the database to server side objects, then use those objects to populate the combobox directly.
d) Send the data from database to server side objects, from server objects to client objects, and then to the combobox in UI.(*)
62). #to reduce n/w trip? choose 3
stored procedure disconnected rs client cursor
0 Kommentarer