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
- The tracks on a disk which can be accessed without repositioning the R/W heads is
- Cylinder
- Surface
- Cluster
- All of these
- Which of the following is the 1's complement of 10?
- 110
- 01
- 11
- 10
- Which unit interprets program instructions and initiate control operations?
- Input unit
- Storage unit
- Control unit
- ALU
- The first microprocessor built by the Intel Corporation
- 8008
- 8080
- 8085
- 4004
- SSI stands for
- Script Side Includes
- Server Script Includes
- Server Side Includes
- None of these
- The Machine that are connected to the Server
- Workstations
- Clients
- Nodes
- All of these
- 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
- 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
- The person contributing the idea of the stored program concept
- Charles Babbage
- John von Neumann
- Howard Aiken
- Basic Pascal
- The ASCII code for the character A
- 0110 0000
- 0110 0001
- 0100 0001
- 0100 0000
- Number of rows in a relation
- Cardinality
- Degree
- Attribute
- Tuple
- 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
- Which is not a type of Select Case test construct?
- Complex value
- Simple value
- Relational value with Is
- Range of values with To
- Convert binary number 1011101001010111 to hexadecimal number
- C8F916
- B85716
- BA5716
- C9F816
- 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
- The symbols used in an assembly language
- Mnemonics
- Codes
- Assembler
- All of these
- Which computer has been designed to be as compact as possible?
- Mini
- Super computer
- Mainframe
- Micro computer
- Which HTML tag does not use an end tag?
- <B>
- <Center>
- <HR>
- <U>
- Which of the following can store information in the form of microscopic pits on metal disks?
- Tape cassettes
- Laser disks
- RAM cartridge
- Punched cards
- Which VB property determines whether a control is displayed to the user?
- Hide
- Show
- Enabled
- Visible
- 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
- A computer has a 1024 K memory. What does the letter K stands for
- 512
- 1000
- 2048
- 1024
- An optical input device that interprets pencil marks on paper media is
- Punch card reader
- O.M.R.
- Optical scanners
- MICR
- In magnetic disks, data is organized on the platter in a concentric sets of rings called
- Track
- Sector
- Head
- Block
- With A = False and B= True, which statement evaluates as True
- A AND A
- A AND B
- B AND B
- B AND A
- 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
- The binary equivalent of the Octal number 12.64
- 1010.1011
- 1101.1010
- 1010.1101
- 1101.1110
- The following are functions of a DBMS except
- Creating databases
- Creating and processing forms
- Processing data
- Administrating databases
- Which selection process is an example of multiple branches from a single expression?
- Select Case
- If...Then
- Do...Loop
- For...Next
- A CPU's processing power is measured in
- IPS
- CIPS
- Nano-Seconds
- MIPS
- SQL stands for
- Sequential Query Language
- Structured Query Language
- Structured Question Language
- Sequential Question Language
- 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
- Which of the following is non-impact printer?
- Drum printer
- Line printer
- Laser printer
- Chain printer
- A networking device used to connect similar types of LANs
- Repeater
- Hub
- Bridge
- Modem
- 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
- When an input electrical signal A = 10100 is applied to a NOT gate, its output signal
- 11100
- 01011
- 10101
- 10100
- The institution set up by the Government of India to provide computer based information services to Government departments
- CDAC
- C-DIT
- DOEACC
- NIC
- Which of the following memory needs refreshing?
- DRAM
- SRAM
- ROM
- All of these
- A billionth of a second is defined as a
- Millisecond
- Microsecond
- Picosecond
- Nanosecond
- 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
- A tuple in relational algebra refers to
- Column
- Row
- Table
- Relation
- Which DOS command is used to delete the directory and all its contents in one step?
- DEL*.*
- RD
- CD
- DELTREE
- Which of the following is volatile?
- RAM
- ROM
- DVD
- Magnetic disk
- 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
- One byte can be used to encode any integer between 0 and
- 16
- 256
- 255
- 128
- Which of the following is not an Anti-virus software?
- McAfee
- Norton
- Trojan
- AVG
- A temporary storage area attached to the CPU for I/O operations
- Buffer
- Chip
- Register
- Core
- Which is a secondary memory device?
- Cache
- ALU
- RAM
- Magnetic Disk
- What is the HTML tag for creating a hyper link?
- A name
- A href
- A ref
- A url
- 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
- Each site hosted on internet has a specific address called
- WWW
- URL
- HTTP
- WAIS
- 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
- 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
- Group of instructions that directs a computer is called
- Storage
- Memory
- Program
- Logic
- 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
- Pick the odd one out
- Oracle
- DOS
- UNIX
- Windows
- What does IDE stands for
- Integrated Design Environment
- Integrated Development Environment
- Interior Development Environment
- Interior Design Environment
- What service is used to translate domain names to IP addresses?
- NFS
- SMB
- DNS
- NIS
- The binary equivalent of the Hexadecimal number 8BE is
- 100110101101
- 100010111110
- 100010111101
- None of these
- In a database system which of the following cannot be blank (Null)
- Primary key
- Foreign key
- Secondary key
- Composite key
- Which of the following holds data and instructions temporarily until the CPU needs it?
- Microprocessor
- Control unit
- Secondary memory
- Main memory
- How many times the test expression of a 'Select Case' is evaluated?
- 1
- 0
- 2
- Once for each case
- In event-driven programming an event is generated by
- The system
- A user's action
- The program itself
- All of these
- What SQL structure is used to limit column values of a table?
- The CHECK constraint
- The LIMIT constraint
- The VALUE constraint
- None of these
- 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
- Which of the following chips can be reprogrammed with special electric pulses?
- EPROM
- PROM
- EEPROM
- ROM
- Convert decimal number 1310 to it's octal number equivalent
- 178
- 158
- 138
- 118
- Pick the odd one out
- Mouse
- Touchpad
- Plotter
- Light pen
- 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
- Codes consisting of light and dark marks which may be optically read is known as
- Bar code
- Mnemonics
- Decoder
- None of these
- Who is the father of PHP?
- Richard Stallman
- Rasmus Lerdorf
- Maurice Wilkes
- Linus Torvalds
- 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
- The binary equivalent of the decimal number 25.4375
- 10001.1010
- 10011.1100
- 11001.0111
- None of these
- Which of the following is not a type of SQL constraint?
- PRIMARY KEY
- FOREIGN KEY
- UNIQUE
- ALTERNATE KEY
- Which PHP function is used to return the length of string?
- Strlength( )
- Str( )
- Len( )
- Strlen( )
- IPv4 uses __________ bit addresses.
- 64
- 32
- 128
- 256
- Translator which coverts an entire program into machine language at one time is called a/an
- Interpreter
- Simulator
- Assembler
- Compiler
- The topology with the highest reliability
- Bus
- Star
- Mesh
- Ring
- Which of the following is ternary operator in PHP?
- = = =
- ? :
- + =
- & &
- Which of the following command is used to delete a table from the database?
- Alter Table
- Delete from
- Drop Table
- Del
- The eastern most state of India
- Assam
- Arunachal Pradesh
- Mizoram
- Manipur
- National Planning Commission of India was formed in which year?
- 1950
- 1966
- 1970
- 1971
- The first Indian who got Nobel Prize for Economics?
- Jagdish Bhagwati
- Raghuram Rajan
- Amartya Sen
- Kaushik Basu
- Who passed Widow Remarriage Act?
- Lord Rippon
- Lord Lytton
- Lord Hastings
- Lord Dalhousie
- Who changed the capital of India from Calcutta to Delhi?
- Warren Hastings
- William Bentick
- Lord Hardinge II
- Lord Rippon
- Who started young Bengal movement?
- Rabindra Nath Tagore
- Swami Vivekananda
- Iswar Chandra Vidyasagar
- Henry Vivian Derozio
- Who was known as Grand Old man of India?
- W.C. Bannerjee
- Mahatma Gandhi
- Dadabai Naoroji
- G.K. Gokhale
- Tipu Sultan was killed in which war?
- 1st Panipat war
- Fourth Mysore war
- Karnal war
- Second Mysore war
- Jhansi Rani Regiment of INA was under the command of _________
- Captain Lakshmi
- Subash Bose
- Tilak
- Gokhale
- Aruna Asaf Ali was associated with _________
- Khilafat
- Quit India Movement
- Non Co-operation
- Civil Disobedience
- Gandhiji emerged as undisputed leader of congress in its ________ session.
- Calcutta
- Amaravati
- Pune
- Bombay
- Pradhan Mantri Jan Dhan Yojana is related to _________
- Health service
- Housing plan
- Education
- Financial services
- Lok Sabha speaker of India
- Sumitra Mahajan
- Sushama Swaraj
- Meera Kumar
- Smrithi Irani
- Who is the author of the book "Hope in a challenged Democracy : An Indian Narrative"?
- Pranab Mukherjee
- Hamid Ansari
- Prannoy Roy
- Ramnath Kovind
- The Safari park for white tigers in India
- Jaipur
- Jaisalmer
- Mukundpur
- Kaziranga
- Joan of Arc of Kerala
- Gowri Amma
- Annie Mascrene
- Suseela Gopalan
- Akkamma Cherian
- Who founded Jatinasini Sabha?
- Brahmananda Sivayogi
- Ananda Theerthan
- Vagbhatananda
- Agamananda
- Who was the author of Arulnool?
- Thycaud Ayya
- Chattampi Swamikal
- Vaikunta Swamikal
- Vagbhatananda
- The official newspaper of Yogakshema Sabha
- Kaumudi
- Vivekodayam
- Sujana nandini
- Mangalodayam
- The famous drama of Edassery
- Koottukrishy
- Aphante Makal
- Ritumati
- Pattabakki
0 Comments