DITA SET 01

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 01,Time : 60 MINUTES, Marks : 70

Question 1.
What is the Maximum Length A Text Field Can Be?
 120
 255
 265
 75

Question 2.
The size of Yes No Field is Always?
 1 Bit
 1 Byte
 1 Character
 1 Gb

Question 3.
In MS-Access to Open a combo box?
 F4 or ALT+DOWN ARROW
 DOWN ARROW
 PAGE DOWN
 A9

Question 4.
Unlike text data type, this can store up to maximum of 65,535 characters.
 memo
 data/time
 number
 All of Above

Question 5.
How do you update Pivot Table report data after changes are made to the source data?
 Save your changes, close the workbook, and then reopen it.
 Select the Pivot Table worksheet and press F9 on the keyboard.
 Click the report, and on the Pivot Table toolbar
 All of the above

Question 6.
Which of the following is a database management tool developed by Microsoft?
 Sybase
 Dbase
 MS-Access
 All of the above

Question 7.
DCL Provides Commands To Perform Actions Like?
 Authorizing Access And Other Control Over Database
 DOWN ARROW
 PAGE DOWN
 A9

Question 8.
Which type of field is incremented automatically?
 Autonumber
 Auto value
 Auto increment
 Auto size

Question 9.
Which of the following is not a Data type in Access?
 Text
 Memo
 OLE Object
 Caption

Question 10.
The arranging of data in a logical swquence is called?
 Summarizing
 Reproducing
 Sorting
 Classifying

Question 11.
To duplicate a controls formatting you can use _______
 Manager
 Wizard
 Painter
 Control

Question 12.
A subset of characters within a data field is known as?
 Byte
 File
 Report
 Data string

Question 13.
The executive responsible for the data processing function in an organization is?
 PMD
 Data-Processing Manager (DPM)
 DP
 DBMS

Question 14.
To create relationship between two tables?
 Drag any field from parent table and drop on child table
 Drag the primary key of a table into foreign key of another table
 Drag the foreign key of a table into primary key of another table
 None

Question 15.
What are the columns in a Microsoft Access Table Called?
 Columns
 Records
 Row
 Fields

Question 16.
The result of a query is displayed in a?
 Record
 Query datasheet
 Query table
 Form

Question 17.
Data can be import into Access database from
 Word Files
 Excel Files
 Power Point Files
 HTML Files

Question 18.
What do you call primary key field included in another table?
 Foreign key
 Parent key
 Child key
 Index

Question 19.
Which of the field has width 8 Bytes?
 Memo
 Number
 Date/time
 Hyperlink

Question 20.
Which of the following is a database management system?
 MS Word
 MS Excel
 Oracle
 Lotus 1-2-3

Question 21.
Microsoft Access is a?
 RDBMS
 OODBMS
 ORDBMS
 Network Database Model

Question 22.
The Database Language that allows to Access or maintain Data in a Database?
 DCL
 DML
 DDL
 None of Above

Question 23.
What is the extension of microsoft Office Access 2007?
 .MDB
 .ACCDB
 .DB
 None of Above

Question 24.
How can you add a table to the relationship window?
 SELECT EDIT >ADD TABLE FROM THE MENU
 SELECT THE TABLE FROM THE TABLE LIST ON THE TOOLBAR
 SELECT TOOLS>ADD TABLE FROM THE MENU
 ON THE DESIGN TAB, IN THE RELATIONSHIPS GROUP, CLICK SHOW TABLE 

Question 25.
In MS-Access Press CTRL+O to?
 Open a new database
 Open an existing database
 Exit MS Access
 None of This

Question 26.
Which of the following is not a data type?
 PICTURE/GRAPHIC
 DATA/TIME
 TEXT
 NUMBER

Question 27.
What Is The Full From of SQL?
 SOPHISRICATED QUESTION LIST
 EStructured QUESTION LIST
 SMALL QUERY LENGTH
 STRUCTURED QUERY LANGUAGE

Question 28.
Which of the following store command to retrieve data from database?
 FORMS
 REPORT 
 QUERIES 
 TABLES

Question 29.
What is fast way to adjust the width of a column?
 RIGHT CLICK THE LEFT SIDE OF THE COLUMN HEADING
 DOUBLE CLICK THE RIGHT SIDE OF THE COLUMN HEADING
 DOUBLE CLICK THE LEFT SIDE OF THE COLUMN HEADING
 SELECT TOOLS >ADJUST COLUMN WIDTH FROM THE MENU

Question 30.
Which of the following is NUMBER Field Size in Access?
 Date/Time
 Double
 Attachment
 Yes/No

Question 31.
What is algorithm?
 A flowchart
 Step by step instructions used to solve a problem
 A flowchart or pseudocode
 A decision

Question 32.
In a flowchart an input or output instruction is represented by?
 A rectangle
 A rhombus
 A parallelogram
 A Circle

Question 33.
Diagram that represents steps or operations involved in any kind of process is called?
 system diagram
 management hierarchy
 flowcharts
 convenience diagrams

Question 34.
The time factor when determining the efficiency of algorithm is measured by?
 Counting microseconds
 Counting the number of key operations
 Counting the number of statements
 Counting the kilobytes of algorithm

Question 35.
What is a list of instructions in a proper order to solve a problem called?
 Flowchart
 Sequence
 Algorithm
 None of these

Question 36.
Program flowcharts are the parts of?
 Operation chart
 Process chart
 Algorithms flowchart
 System flowcharts

Question 37.
Link with another part of program or connectors in flowchart are shown in ?
 rhombus
 parallelogram
 circle
 trapezoid

Question 38.
How many values a CheckBox can have?
 4
 1
 3
 2

Question 39.
How many MDI forms added in a project File?
 5
 1
 4
 2

Question 40.
how many shapes are possible in a shape tool?
 6
 7
 8
 9

Question 41.
How many colors in RGB()
 16
 256
 265
 75

Question 42.
How many default controls are available in VB?
 20
 21
 23
 22

Question 43.
In Visual Basic, a variable name cannot be more than ............. characters
 450
 255
 355
 500

Question 44.
Visual basic maintains a project file with the extension .................
 .frm
 .vbp
 .vbs
 .cls

Question 45.
QBColor() Code range Between
 0 to 15
 0 to 255
 0 to 16
 0 to 256

Question 46.
The value of Option Button is
 Yes/No
 0/1
 True/False
 0/2

Question 47.
What is the full form ADO 
 Acting database object
 Active data Object
 Activex Database Object
 Activex Data Object

Question 48.
"Form Load()" the "Load" is name of
 keyword
 Procedure
 Syntex
 All of the Above

Question 49.
Auto Size property is for
 Label
 Combobox
 Button
 All Off the above

Question 50.
Val() function used for convert
 String to date
 text to number
 number to string
 All Off the above

Question 51.
In txtName.Text
 The Property is txt name
 the property is text
 the object is Txt
 Both a and c is correct

Question 52.
Which one is not object oriented programming
 C
 java
 C#
 c++

Question 53.
Code is:
 Updateable in the from editor
	Instructions
 Seldom used
 An object

Question 54.
List Property is used
 Lable 
 Text box 
 Command Button
 ComboBox

Question 55.
Key fields of the Connection String property are
 Mode
 Provider&Data Source
 Provider
 Data Source

Question 56.
The default datatype for VB is ?
 Integer
 Variant
 String
 Decimal

Question 57.
Event-driven languages are:
 Fortran baseed
 Are used to write procedural languages.
 Oop
 Designed to make programming GUI easier

Question 58.
Which is a valid statement for declaring a variable?
 Const form as Integer
 Const my froip as integer
 Dim Form A integer
 Dim myform as Integer

Question 59.
The sortcut key of "menu Editor" is ?
 CTRL+E
 CTRL +R
 CTRL+T
 F4

Question 60.
 Which selection process is an example of multiple branches from a single expression?
 if Then
 Select Case
 Do loop
 for next

Question 61.
ShortCut key of properties window?
 F5
 F4
 F7
 F6

Question 62.
What is full form of http://
 Hyper Text Transfer Protocol
 Hyper Test transfer Protocol
 Hyfer text Transport protocol
 None of Above

Question 63.
What is full form of RDBMS?
 Relational Database Management System
 Relational Database Management Store
 Relation Database Management System
 None of Above

Question 64.
How many types of Query in Ms-Access 2007?
 6
 5
 7

 3

Question 65.
What is Full Form of WWW.
 World Wide Web
 World Web Wide
 Worlt Wide Web
 None of Above

Question 66.
What is Shortcut key of Save of MS-Access 2007?
 Ctrl+S
 F12
 Office Button->Save
 All of Above

Question 67.
"Stretch" property is available for
 Image Control
 Text box
 Label
 Command Button

Question 68.
Visual Basic is a(n) ................................
 Object-oriented programming language
 Hyperlink programming language
 Procedural programming language
 Sequential programming language

Question 69.
  Which data type containing value-TRUE & FALSE
 Boolean
 String
 Double
 Single

Question 70.
Dim x, y as integer. What is x and y data type?
 x as varient and y as integer
 x as integer and y as integer
 x as integer and y as varient
 none of these