Laboratory Technical Assistant Computer Application VHSE 135/2017 Answer Key

CA

Post : Laboratory Technical Assistant Computer Application
Department : Vocational Higher Secondary Education
Category Code : 135/17
Qualification :VHSE; ITI
Question Paper Code : 94/2017/OL
Date of Test : 17-11-2017



  1. The tracks on a disk which can be accessed without repositioning the R/W heads is
    • Cylinder
    • Surface
    • Cluster
    • All of these

  2. Which of the following is the 1's complement of 10?
    • 110
    • 01
    • 11
    • 10

  3. Which unit interprets program instructions and initiate control operations?
    • Input unit
    • Storage unit
    • Control unit
    • ALU

  4. The first microprocessor built by the Intel Corporation
    • 8008
    • 8080
    • 8085
    • 4004

  5. SSI stands for
    • Script Side Includes
    • Server Script Includes
    • Server Side Includes
    • None of these

  6. The Machine that are connected to the Server
    • Workstations
    • Clients
    • Nodes
    • All of these

  7. Which statement is used in conjunction with the aggregate functions to group the result-set by one or more columns?
    • Order By
    • Group By
    • LIKE
    • WHERE

  8. Which Do....Loop statement should be used to process test scores where a test score over 10 is a signal to stop the processing?
    • Do Until Score > 10
    • Do While Score > 10
    • Loop Until Score > 10
    • Loop While Score > 10

  9. The person contributing the idea of the stored program concept
    • Charles Babbage
    • John von Neumann
    • Howard Aiken
    • Basic Pascal

  10. The ASCII code for the character A
    • 0110 0000
    • 0110 0001
    • 0100 0001
    • 0100 0000

  11. Number of rows in a relation
    • Cardinality
    • Degree
    • Attribute
    • Tuple

  12. An advantage of overlapped processing activity
    • More effective use of the CPU
    • Increased processing activities for the entire system
    • Better coordination of I/O activities
    • All of these

  13. Which is not a type of Select Case test construct?
    • Complex value
    • Simple value
    • Relational value with Is
    • Range of values with To

  14. Convert binary number 1011101001010111 to hexadecimal number
    • C8F916
    • B85716
    • BA5716
    • C9F816

  15. ASCII stands for
    • American security code for information interchange
    • American standard code for information interchange
    • American Scientific code for information interchange
    • American standard code for interchange information

  16. The symbols used in an assembly language
    • Mnemonics
    • Codes
    • Assembler
    • All of these

  17. Which computer has been designed to be as compact as possible?
    • Mini
    • Super computer
    • Mainframe
    • Micro computer

  18. Which HTML tag does not use an end tag?
    • <B>
    • <Center>
    • <HR>
    • <U>

  19. Which of the following can store information in the form of microscopic pits on metal disks?
    • Tape cassettes
    • Laser disks
    • RAM cartridge
    • Punched cards

  20. Which VB property determines whether a control is displayed to the user?
    • Hide
    • Show
    • Enabled
    • Visible

  21. Batch files contain a group of MS-DOS commands that are run in successive order. What filename extension identifies batch files
    • BAT
    • COM
    • EXE
    • SYS

  22. A computer has a 1024 K memory. What does the letter K stands for
    • 512
    • 1000
    • 2048
    • 1024

  23. An optical input device that interprets pencil marks on paper media is
    • Punch card reader
    • O.M.R.
    • Optical scanners
    • MICR

  24. In magnetic disks, data is organized on the platter in a concentric sets of rings called
    • Track
    • Sector
    • Head
    • Block

  25. With A = False and B= True, which statement evaluates as True
    • A AND A
    • A AND B
    • B AND B
    • B AND A

  26. Which is true about the primary key?
    • Every table should have a primary key
    • A primary key exclusively identifies each row in a table
    • A primary key can be made of multiple fields
    • All of these

  27. The binary equivalent of the Octal number 12.64
    • 1010.1011
    • 1101.1010
    • 1010.1101
    • 1101.1110

  28. The following are functions of a DBMS except
    • Creating databases
    • Creating and processing forms
    • Processing data
    • Administrating databases

  29. Which selection process is an example of multiple branches from a single expression?
    • Select Case
    • If...Then
    • Do...Loop
    • For...Next

  30. A CPU's processing power is measured in
    • IPS
    • CIPS
    • Nano-Seconds
    • MIPS

  31. SQL stands for
    • Sequential Query Language
    • Structured Query Language
    • Structured Question Language
    • Sequential Question Language

  32. What is the byte capacity of a drum which is 5 inch high, 10 inch diameter, and which has 40 tracks per inch and bit density of 600 bits per inch?
    • 471000 bytes
    • 942000 bytes
    • 3768000 bytes
    • 58875 bytes

  33. Which of the following is non-impact printer?
    • Drum printer
    • Line printer
    • Laser printer
    • Chain printer

  34. A networking device used to connect similar types of LANs
    • Repeater
    • Hub
    • Bridge
    • Modem

  35. What was the name of the first stored program electronic computer which was built in 1949 at Cambridge University in England?
    • EDSAC
    • EDVAC
    • UNIVAC
    • MARK-I

  36. When an input electrical signal A = 10100 is applied to a NOT gate, its output signal
    • 11100
    • 01011
    • 10101
    • 10100

  37. The institution set up by the Government of India to provide computer based information services to Government departments
    • CDAC
    • C-DIT
    • DOEACC
    • NIC

  38. Which of the following memory needs refreshing?
    • DRAM
    • SRAM
    • ROM
    • All of these

  39. A billionth of a second is defined as a
    • Millisecond
    • Microsecond
    • Picosecond
    • Nanosecond

  40. Kishor was asked to prepare a multimedia presentation as part of NSS project. Which of the following software can be made use of
    • Notepad
    • Excel
    • Power point
    • Access

  41. A tuple in relational algebra refers to
    • Column
    • Row
    • Table
    • Relation

  42. Which DOS command is used to delete the directory and all its contents in one step?
    • DEL*.*
    • RD
    • CD
    • DELTREE

  43. Which of the following is volatile?
    • RAM
    • ROM
    • DVD
    • Magnetic disk

  44. The SQL ALTER statement can be used to
    • Change the table data
    • Change the table structure
    • Add rows to the table
    • Delete rows from the table

  45. One byte can be used to encode any integer between 0 and
    • 16
    • 256
    • 255
    • 128

  46. Which of the following is not an Anti-virus software?
    • McAfee
    • Norton
    • Trojan
    • AVG

  47. A temporary storage area attached to the CPU for I/O operations
    • Buffer
    • Chip
    • Register
    • Core

  48. Which is a secondary memory device?
    • Cache
    • ALU
    • RAM
    • Magnetic Disk

  49. What is the HTML tag for creating a hyper link?
    • A name
    • A href
    • A ref
    • A url

  50. A multi programming system is one that can
    • Share hardware resources with many programs simultaneously
    • Run very fast
    • Compute many programs simultaneously
    • Use many operating systems

  51. Each site hosted on internet has a specific address called
    • WWW
    • URL
    • HTTP
    • WAIS

  52. An on-line commercial site such as Flipkart.com is an example of a/an
    • Single-user database application
    • Multiuser database application
    • Data mining database application
    • E-commerce database application

  53. A foreign key
    • Has nothing to do with the primary key
    • Has different values than the primary key
    • Is related to the primary key of a different table
    • Is found in tables that don't have a primary key

  54. Group of instructions that directs a computer is called
    • Storage
    • Memory
    • Program
    • Logic

  55. Which of the following statement is not correct for PHP?
    • It is a server side scripting language
    • A PHP file may contain text, html tags or scripts
    • It is compatible with most of the common servers used today
    • It can run on windows and Linux systems only

  56. Pick the odd one out
    • Oracle
    • DOS
    • UNIX
    • Windows

  57. What does IDE stands for
    • Integrated Design Environment
    • Integrated Development Environment
    • Interior Development Environment
    • Interior Design Environment

  58. What service is used to translate domain names to IP addresses?
    • NFS
    • SMB
    • DNS
    • NIS

  59. The binary equivalent of the Hexadecimal number 8BE is
    • 100110101101
    • 100010111110
    • 100010111101
    • None of these

  60. In a database system which of the following cannot be blank (Null)
    • Primary key
    • Foreign key
    • Secondary key
    • Composite key

  61. Which of the following holds data and instructions temporarily until the CPU needs it?
    • Microprocessor
    • Control unit
    • Secondary memory
    • Main memory

  62. How many times the test expression of a 'Select Case' is evaluated?
    • 1
    • 0
    • 2
    • Once for each case

  63. In event-driven programming an event is generated by
    • The system
    • A user's action
    • The program itself
    • All of these

  64. What SQL structure is used to limit column values of a table?
    • The CHECK constraint
    • The LIMIT constraint
    • The VALUE constraint
    • None of these

  65. The ALU and control unit of most of the microcomputers are combined and manufactured on a single silicon chip called
    • Microprocessor
    • Monochip
    • ALU
    • Control unit

  66. Which of the following chips can be reprogrammed with special electric pulses?
    • EPROM
    • PROM
    • EEPROM
    • ROM

  67. Convert decimal number 1310 to it's octal number equivalent
    • 178
    • 158
    • 138
    • 118

  68. Pick the odd one out
    • Mouse
    • Touchpad
    • Plotter
    • Light pen

  69. The normalization process
    • Used to remove redundant data
    • Used to make the storage of data more efficient
    • Not recommended for most databases
    • Used to remove redundant data and make the storage of data more efficient

  70. Codes consisting of light and dark marks which may be optically read is known as
    • Bar code
    • Mnemonics
    • Decoder
    • None of these

  71. Who is the father of PHP?
    • Richard Stallman
    • Rasmus Lerdorf
    • Maurice Wilkes
    • Linus Torvalds

  72. The main purpose of time sharing techniques used in computers is to make the best use of
    • I/O device
    • CPU
    • Secondary storage
    • Main memory

  73. The binary equivalent of the decimal number 25.4375
    • 10001.1010
    • 10011.1100
    • 11001.0111
    • None of these

  74. Which of the following is not a type of SQL constraint?
    • PRIMARY KEY
    • FOREIGN KEY
    • UNIQUE
    • ALTERNATE KEY

  75. Which PHP function is used to return the length of string?
    • Strlength( )
    • Str( )
    • Len( )
    • Strlen( )

  76. IPv4 uses __________ bit addresses.
    • 64
    • 32
    • 128
    • 256

  77. Translator which coverts an entire program into machine language at one time is called a/an
    • Interpreter
    • Simulator
    • Assembler
    • Compiler

  78. The topology with the highest reliability
    • Bus
    • Star
    • Mesh
    • Ring

  79. Which of the following is ternary operator in PHP?
    • = = =
    • ? :
    • + =
    • & &

  80. Which of the following command is used to delete a table from the database?
    • Alter Table
    • Delete from
    • Drop Table
    • Del

  81. The eastern most state of India
    • Assam
    • Arunachal Pradesh
    • Mizoram
    • Manipur

  82. National Planning Commission of India was formed in which year?
    • 1950
    • 1966
    • 1970
    • 1971

  83. The first Indian who got Nobel Prize for Economics?
    • Jagdish Bhagwati
    • Raghuram Rajan
    • Amartya Sen
    • Kaushik Basu

  84. Who passed Widow Remarriage Act?
    • Lord Rippon
    • Lord Lytton
    • Lord Hastings
    • Lord Dalhousie

  85. Who changed the capital of India from Calcutta to Delhi?
    • Warren Hastings
    • William Bentick
    • Lord Hardinge II
    • Lord Rippon

  86. Who started young Bengal movement?
    • Rabindra Nath Tagore
    • Swami Vivekananda
    • Iswar Chandra Vidyasagar
    • Henry Vivian Derozio

  87. Who was known as Grand Old man of India?
    • W.C. Bannerjee
    • Mahatma Gandhi
    • Dadabai Naoroji
    • G.K. Gokhale

  88. Tipu Sultan was killed in which war?
    • 1st Panipat war
    • Fourth Mysore war
    • Karnal war
    • Second Mysore war

  89. Jhansi Rani Regiment of INA was under the command of _________
    • Captain Lakshmi
    • Subash Bose
    • Tilak
    • Gokhale

  90. Aruna Asaf Ali was associated with _________
    • Khilafat
    • Quit India Movement
    • Non Co-operation
    • Civil Disobedience

  91. Gandhiji emerged as undisputed leader of congress in its ________ session.
    • Calcutta
    • Amaravati
    • Pune
    • Bombay

  92. Pradhan Mantri Jan Dhan Yojana is related to _________
    • Health service
    • Housing plan
    • Education
    • Financial services

  93. Lok Sabha speaker of India
    • Sumitra Mahajan
    • Sushama Swaraj
    • Meera Kumar
    • Smrithi Irani

  94. Who is the author of the book "Hope in a challenged Democracy : An Indian Narrative"?
    • Pranab Mukherjee
    • Hamid Ansari
    • Prannoy Roy
    • Ramnath Kovind

  95. The Safari park for white tigers in India
    • Jaipur
    • Jaisalmer
    • Mukundpur
    • Kaziranga

  96. Joan of Arc of Kerala
    • Gowri Amma
    • Annie Mascrene
    • Suseela Gopalan
    • Akkamma Cherian

  97. Who founded Jatinasini Sabha?
    • Brahmananda Sivayogi
    • Ananda Theerthan
    • Vagbhatananda
    • Agamananda

  98. Who was the author of Arulnool?
    • Thycaud Ayya
    • Chattampi Swamikal
    • Vaikunta Swamikal
    • Vagbhatananda

  99. The official newspaper of Yogakshema Sabha
    • Kaumudi
    • Vivekodayam
    • Sujana nandini
    • Mangalodayam

  100. The famous drama of Edassery
    • Koottukrishy
    • Aphante Makal
    • Ritumati
    • Pattabakki

%

Post a Comment

0 Comments