SWASTICK YOUTH COMPUTER TRAINING CENTRE
(A Government of West Bengal Initative Under the Directorate of Youth services)
Village-Paschim Sridharpur, Post-Gurudaspur, P.S-Dholahat, Dist-24Pgs(S),
Block-Patharpratima, Pin-743349, Contact No : 97336 00064 / 77185 53373
Subject : MCQ ON-LINE EXAM, COURSE : DITA(S-2), SET 02,Time : 60 MINUTES, Marks : 70
Question 1. If a piece of data is to stored in two places in the database,then a Storage space is wasted Changing the data is one spot will cause data inconsistency It can be more easily accessed Both 1 and 2 Question 2. Which of the following columns does not exist in Macro Design Window ? Arguments Comments Conditions Actions Question 3. What datatype should you choose for a zip code field in a table? Text Number Memo All of above Question 4. How can you display sales grouped by country,Region,and salesperson,all at the same time ? Use the pivot table commend Use the sort desending command Use the find command on specified group All of Above Question 5. In access,the best types of queries to use for data analysis are : Action queries Parameter queries Select queries All of the above Question 6. Which of following is not a database application? Falsh MS Access FoxPro All of the above Question 7. Which of the following type of queries are action queries? Update queries Crosstab queries Append queries Both 1 and 3 Question 8. An organized collection of logically related data is known as Database Information Data All of above Question 9. _____means that the data contained in a database is accurate and reliable Data Definition Data Consistency Data Reliability Data Integrity Question 10. A group of releted records in data base is known as a File Database Table None Question 11. What are the different views to display a table Design view Pivot table and pivot chart view Datasheet view All of above Question 12. Which of the following is not a report section? Report Header Section Page Header Section Summary Section Details Section Question 13. A_______name must be unique within a database Character Record Table Field Question 14. If you write criteria values vertically (one in a row) it will mean AND condition OR condition NOT condition FOR condition Question 15. Which of the following is not a database application? Access DB Access DIT Foxpro Question 16. We can remove a relationship defined between two tables by Select the reletionship line & press delete Choose delete option from reletionship menu From edit menu choose delete reletionship All of above Question 17. Which of the following creates a drop down list of values to choose from a list? OLE object Hyperlink Memo Lookup wizard Question 18. A file containing relatively permanent data is Sequential file Transaction file Random file Master file Question 19. Default datatype of a field is Memo Number Text Autonumber Question 20. To create queries in access You can type the SQL command in SQL view You can use queries wizard or design view You can drag & drop fields on query builders All of above Question 21. To main measures for the efficiency of an algorithm are Processor & memory Complexity & capacity Time & space Data & space Question 22. Diamond shaped symbol is used in flowchart to show the Decision Box Statement Box Error Box If-statement Box Question 23. The complexity of Bobble sort algorithm is O(n) O(log) O(n2) O(n log n) Question 24. In flowchart,parallelogram is used to show General input symbol Operation on data Online use of keyboard Output data screen Question 25. Binary search algorithm can not be applied to Sorted linked list Sorted binary trees Sorted linear array None of This Question 26. The information software produces after it has processed the input is called Flowchart Output Object Prototype Question 27. Algorithm and flowchart help us to Know the memory capacity Identify the base of a number system Direct the output to a printer Specify the problem completely and clearly Question 28. An algorithm that calls itself directly or indirectly is known as Sub algorithm Recursion Polish notation Traversal algorithm Question 29. A person who produces or creates new programs for industrial and business users is called System analysts Program coordinator Computer coordinator User interface Question 30. Flowcharts and pseudocode are examples of tools used in the program____phase. Specification Design Code Test Question 31. In flowchart,invert trapezoid is used to show the On-line storage symbol Manual operations Communications link Show annotations Question 32. Part of an algorithm which is repeated for fixed number of times is classified as Iteration Selection Sequence Reverse action Question 33. Which of the following cases does not exist in complexity theory Best case Worst case Average case Null case Question 34. The worst case occur in linear search algorithm when Item is somewhere in the middle of the array Item is not in the array at all Item is the last element in the array Item is the last element in the array or is not there at all Question 35. 'Outlined program flowchart' show the Detailed operations General flowchart Classified flowchart Detailed program Question 36. The counter variable is normaly incremented or decremented by ____ 2 4 3 1 Question 37. Timer control contains____no.of events. 2 3 4 1 Question 38. How many bytes of memory will the number 50000 comsume if it is declared as a variant ? 13 14 15 16 Question 39. A text box can hold as many as .......characters for a single line text. ? 2052 2048 2058 2047 Question 40. To exit visual basic Click Alt-Q Use the file menu to select Quit Use the window menu to select exit Click on the diskatte icon Question 41. Which symbol creates and access key in the text of a menu item? @ # & $ Question 42. Which of the following is a relational operator? AND < + & Question 43. Which of the following arithmetic operations hase the highest label precedence? +- */ ^expronentiation () Question 44. Which menu object property places a check mark in the display of the menu text ? Check Check Mark Check on Checked Question 45. _____control is used to represent the items in a hierarchical manner. Tree view Grid view Progress bar None of these Question 46. When the user clicks a botton,____is triggered. An event A method A setting A property Question 47. Which sequence of char data types is listed from lowest to highest ? a, A, z, Z a, z, A, Z A, a, Z, z A, Z, a, z Question 48. Which TextBox property should always be changed first ? BorderStyle Name Font AcceptsReturn Question 49. An object is compiosed of Event Properties Methods All Off the above Question 50. In event-driven programming an event is generated by: The program itself A user's action The system All Off the above Question 51. The standrad reporting tool in VB is Crystal Report MS Access Data Report All of These Question 52. From how many places o\in the code can a proceduce be called ? 1 100 3 As many times as needed Question 53. Which property of command buttom sets the appearance of the control... Appearance Look Style BackColor Question 54. ______control display all the files under a directory Drive List Box Dir List Box File List Box Both 1 & 2 Question 55. Which are the standard prefixes for the button & combo box controls respectively ? btn and chb btn and cbo bto and chb bto and cho Question 56. Dedug window is the same as______window . Form Procedure Object Code Question 57. VBcritical is used for MSG Box TEXT Box Input Box Combo Box Question 58. The code that is used in a sub procedure to stop execution of a program is :? EXIT END With END END Sub Question 59. _______is used to select a particuler record. Data provider Data base VDM Fild point Question 60. Which two control combined to form the combobox control ? LISTBOX & TEXTBOX LISTBOX & INPUTBOX LISTBOX & MSGBOX LABEL & TEXTBOX Question 61. Code in VB is stored in Module Variable Report None of Above Question 62. Which statement about object is true ? One object can create many classes One object is used to create one class One class is used to create one object One class can create many objects Question 63. Which is not a valid control in data report ? Report label Report combo Report image Report textbox Question 64. ______is the common event for almost all the control. Key press Click Timer Scroll Question 65. The timer event is found only in which object ? Label Text Box List Box Timer Question 66. Which property of text box determines whether a control can be edited. IS EDIT LOCKED ENABLED VISIBLE Question 67. The cancell button property belongs to which object ? Button Form Label Text box Question 68. ______function translates a numeric value to a variable Message Build in Val Mod Question 69. An exception is another name for a : Superficial error Complie error Runtime error Logic error Question 70. Which phase of object development typically costs the most ? Analysis Design Implementation Maintenance
Copyright © Reserved
[…] Diploma in Information Technology Application (DITA) Question Paper Set 2 […]