UKPSC Solved Assistant programmer Paper Download Now
By Vikash Suyal | Practice Set | Oct 28, 2017
Part – I COMPUTER SCIENCE Set A Practice set
- Any computer is controlled by
- Hardware (b) Information (c) Instructions (d) Memory
2. Storage mapping is done by
(a) Operating System
(b)Compiler
(c) Linker
Loader
- The input and output device in a computer system is
- Printer (b) Touch Screen (c) Keyboard (d) Mouse
- Computer memory consists of
- RAM (b) ROM (c) PROM (d) All of the above
- The BIOS is the abbreviation of
- Best Input Output System (b) Basic Input Output Symbol
(c) Base Input Output System (d) Basic Input Output System
- Which of the memory has the shortest access time ?
- Cache Memory (b) Virtual Memory
(c) Secondary Memory (d) All of the above
- What do you call a single point on a computer screen ?
- Bit (b) Element (c) Pixel (d) Cell
- Through which of the device, the main components of Computer communicate with each other ?
- System Bus (b) Monitor (c) Memory (d) Keyboard
- The main electronic components used in fourth generation computers were
- Integrated circuits (b) VLSI
(c) Vacuum tubes and valves (d) None of the above
- The abbreviation bps stands for
- Bytes per second (b) Bandwidth per second
(c) Bits per second (d) Baud rate per second
- The silicon chips used for data processing are called
- ROM chips (b) RAM chips
(c) PROM chips (d) Microprocessor
- IBM PC and clones belong to the
- Second generation (b) Third generation
(c) Fourth generation (d) Fifth generation
- When a PC is started, which of the following program is executed ?
- DOS (b) BIOS
(c) Startup (d) None of the above
14. Working area of CPU is | ||
(a) Program Counter | (b) | Instruction Register |
(c) Information Decoder | (d) | Accumulator |
- Which of the following layer is not in OSI model ?
- Physical layer (b) Internet layer
- (c) Network layer (d) Transport layer
- IPv4 address is
- 8 bits (b) 16 bits (c) 32 bits (d) 48 bits
- What is the Port number for HTTP ?
- (a) 80 (b) 99 (c) 82 (d) 23
- Which layer of OSI model is responsible for dialog control and token management ?
- Physical layer (b) Data-link layer
- (c) Network layer (d) Session layer
- DHCP stands for
- Dynamic Host Control Protocol
- Dynamic Host Configuration Protocol
- Dynamic Host Connection Protocol
- None of the above
- A computer network uses a star topology if
- Computers are arranged in closed
- All computers attach to a central
- All computers attach to a single long
- None of the
- Fiber Distributed Data Interface (FDDI) is an example of
- Token ring (b) Token bus
- (c) Star topology (d) Multipoint network
- Error detection at the data-link layer is achieved by
- Bit stuffing (b) Cyclic Redundancy check
- (c) Hamming codes (d) Equalization
- NIC stands for
- New Internet Connection (b) Network Interface Card
- (c) Network Interface Connection (d) Net Interface Card
- Switch is related to
- Network layer (b) Application layer
- (c) Session layer (d) Data-link layer
- File virus attaches itself to
- Backup file (b) Source file (c) Object file (d) Executable file
- In asymmetric key cryptography, the private key is kept by
- Sender (b) Receiver
(c) Sender & Receiver both | (d) | All connected devices to the network |
27. URL stands for (a) Unique Reference Label | (b) | Uniform Reference Label |
(c) Uniform Resource Locator | (d) | Unique Resource Locator |
28. Digital signature is a (a) Scanned signature | (b) | Signature in binary form |
(c) Encrypting Information (d) None of the above
29. All of the following are top level domains, except (a) .com (b) .edu (c) .org | (d) | .army |
30. The first page of a website is called as (a) Main page (b) Home page (c) First page | (d) | Design page |
- Which of the following protocol is used for transferring e-mail message from one machine to another ?
- FTP (b) SNMP (c) SMTP (d) RPC
- A computer which stores the different webpages is called as
- Service provider (b) Web server
(c) Web browser (d) None of these
- In the e-mail address abc@gmail.com what is ‘abc’ ?
- Client computer (b) Server Name
(c) Domain Name (d) User Name
- Google is a
35. | (a) LAN Navigator (c) Hardware Part The main function of a browser is to | (b) (d) | Search Engine None of the above | |
(a) Compile HTML (c) Interpret CGI program | (b) (d) | Interpret HTML None of the above | ||
36. | Error reporting protocol is (a) ARP (b) TCP | (c) | UDP (d) | ICMP |
37. HTTP is a protocol to (a) Copy files between computers. | (b) | Transfer webpages to a browser. | ||
(c) Limit access to company data. | (d) | None of the above |
- Telnet is a
- Network of Telephones (b) Television Network
(c) Remote login (d) None of the above
- Which protocol is used for browsing websites ?
- HTTP (b) FTP (c) SMTP (d) TELNET
- Virtual memory is
- An extremely large main
- An extremely large secondary
- An illusion of an extremely large
- A type of memory used in super-computers.
- The delay between job submission and job completion is called
- Turn around time (b) In-process time
(c) Response time (d) Waiting time
- The module that gives the control of CPU to the process selected by short-term scheduler is
- Dispatcher (b) Scheduler
(c) Context switcher (d) All of the above
- The substitution made by the Operating System between processes to allocate space is
- Swapping (b) Deadlock (c) Fragmentation (d) Paging
- Which of the following system software resides in main memory always ?
(a) Text editor (b) Assembler | (c) Linker | (d) Loader |
44. 45. | ×®Ö´®Ö ´Öë ÃÖê ÛúÖî®Ö ÃÖÖ ×ÃÖÙü´Ö ÃÖÖò°™ü¾ÖêµÖ¸ü ´ÖãÜµÖ ´Öê´ÖÖê¸üß ´Öë Æü´Öê¿ÖÖ ¸üÆüŸÖÖ Æîü ? (a) ™êüŒÃÖ™ü ‹›üß™ü¸ü (b) †ÃÖê´²Ö»Ö¸ü (c) ×»Ö®Ûú¸ü A program which merges many object modules is called (a) Linker (b) Loader (c) Interpreter | (d) (d) | »ÖÖê›ü¸ü Compiler | ||
46. | MS-DOS is a (a) Multi User Operating System | (b) | Time Sharing Operating System | ||
(c) Single User Operating System | (d) | None of the above | |||
- The time during which a job is processed by the computer is
- Delay time (b) Real time (c) Execution time (d) Down time
- A translator which reads an entire program written in a high level language and converts it into machine language code is
- Assembler (b) Compiler
(c) Translator (d) System Software
- In computer which language is used to write source program ?
- English (b) Hindi (c) Symbolic (d) High level
- When a computer is first turned on or restarted, a specific type of absolute loader is executed, called a
- Boot loader (b) Compile and Go loader
(c) Bootstrap loader (d) Start loader
- Dijkstra’s banking algorithm in an operating system solves the problem of
- Deadlock Avoidance (b) Deadlock Recovery
(c) Mutual Exclusion (d) Context Switching
- Which command of MS-DOS is used to search for a specific string of text in one or more files ?
- SEARCH (b) SORT (c) FIND (d) MORE
- Which command is used to delete the directory and all its contents in one step ?
- DEL *·* (b) RD (c) DELTREE (d) DELDIR
- JPEG stands for
- Joint Photo Experiment Group (b) Joint Photographic Experts Group
(c) Joint Photographic Enlarge Group (d) Joint Photogenic Experts Group
- MIDI stands for
- Multimedia Instrument Digital Interface
- Musical Instrument Design Interface
- Musical Instrument Digital Instruction
- Musical Instrument Digital Interface
- Which of the following program is not popular desktop publishing program ?
- Adobe PageMaker (b) Microsoft Publisher
(c) Lotus AmiPro (d) Quark Xpress
- Program used to create or modify bitmap images is called
- Illustration program (b) Paint program
(c) Graphical modifier (d) Bit publishing package
- Raster images are also known as
- Bitmap images (b) Vector images
(c) Clip-art images (d) Multimedia images
59. | Corel Draw is an example of a (a) Groupware Application | (b) | Bit Publishing Package |
(c) Paint Program | (d) | Graphics Suite | |
60. | Microsoft front page is an example of (a) Authorizing Streaming Program | (b) | Graphical map editor |
(c) Webpage Editor | (d) | Robotics authoring program |
- Data is filled up into a MS-ACCESS database using
- Data sheet view (b) Advance filter view
(c) Design view (d) Relationship view
- The default value for text field size in MS –Access is
- 50 characters (b) 55 characters (c) 60 characters (d) 80 characters
- In a relational schema, each tuple is divided into fields called
- Relations (b) Domains (c) Queries (d) None of these
- Arranging data in a specific order is called
- Merging (b) Sorting (c) Classification (d) Verification
- Relational calculus is a
- Procedural language (b) Non-procedural language
(c) Data definition language (d) High level language
- In E-R diagram, attributes are represented by
- Rectangle (b) Square (c) Ellipse (d) Triangle
- In the architecture of database system external level is
- Physical level (b) Logical level (c) Conceptual level (d) View level
- E-R modelling technique is
- Top-down approach (b) Bottom-up approach
(c) Left-right approach (d) None of the above
- Data integrity refers to
- Non-duplication of data (b) Accuracy of data
(c) Security of data (d) Centralised data
- Which is not a component of relational database ?
- Entity (b) Attribute (c) Table (d) Hierarchy
- Name the extension of an access database
- .dat (b) .mdb (c) .txt (d) .exe
- Which SQL Query is used to remove a table and all its data from the database ?
- Create table (b) Drop table (c) Alter table (d) None of these
- Which of the following is not an aggregate function ?
- MIN (b) MAX (c) SELECT (d) AVG
- Which of the following is not used for modification in the database ?
- DELETION (b) SORTING (c) INSERTION (d) UPDATING
- What is Unicode ?
- Standard Font (b) Software
(c) Character Encoding System (d) Keyboard Layout
- Which attribute is used to specify the link URL in HTML ?
- src (b) href (c) rel (d) link
- What is the correct syntax in HTML for creating a link on a webpage ?
- < A HREF = “abc.html” > (b) < LINK SRC = “abc.html” >
(c) < HYPER SRC = “abc.html” > (d) < BODY SRC = “abc.html”>
- Tags that are not directly displayed on the page are written in which of the following section ?
- < html > (b) < head > (c) < title > (d) < body >
- What is the correct HTML tag for inserting a line break ?
- < br > (b) < break > (c) < new line > (d) < lb >
- How can you make an e-mail link in HTML ?
- < mail href = “yyy@xxx” > (b) < mail > yyy@xxx</mail >
(c) < a href = “mail to : xxx@yyy” > (d) < a href = “xxx@yyy” >
- Which of the following converts ordinary text into hypertext ?
- XML (b) HTML (c) JavaScriptü (d) HTTP
- What is the correct syntax for inserting image in HTML ?
- < background img = “background.gif ” >
- < body background = “background.gif ” >
- < img src = “background.gif ” >
- None of these
- Which is not a markup language, but a language for defining markup language ?
- HTML (b) DHTML (c) SGML (d) None of these
- Which attribute is used to specify the relationship between current document and the linked document ?
- rel (b) target (c) href (d) relation
- HTML stands for
- Hyper Text Makeup Language (b) Hyper Technical Markup Language
(c) Hyper Text Markup Language (d) None of the above
- Choose the correct HTML tag to make the text
(a) <B> (b) <I> (c) <P> (d) <H1>
- Architecture of the database can be viewed as
- two levels (b) three levels (c) four levels (d) one level
- In relational model, cardinality is termed as
- Number of tuples (b) Number of attributes
(c) Number of tables (d) Number of constraints
- Raster is a synonym for the term
- Matrix (b) Array (c) Model (d) All of the above
- Graphics that contain movement are often referred as
- Motion (b) Premier Adobe (c) Flash (d) Animation
Part – II
- Trojan Horse is
- A code segment that misuses its file (b) Good for file accessing
(c) Name of special file directory (d) None of these
- To switch to the next task, press the following keys in windows :
- Alt + Ctrl (b) Alt + Esc (c) Alt + Del (d) Alt + Tab
- Which is not the filename extension of an image ?
- .gif (b) .jpg (c) .png (d) .ppt
- Which of the following extension suggests that the file is a backup copy ?
- .bak (b) .bas (c) .srt (d) .img
- Date and time are available on the desktop at
- My Computer (b) Task bar
(c) Recycle bin (d) None of the above
- In MS-DOS how a floppy or hard disk can be formatted ?
- Clean (b) Spooling
(c) Format (d) None of the above
- What is the name of the application used to manage files and folders in windows ?
- Internet Explorer (b) Document Explorer
(c) Analytical Explorer (d) Windows Explorer
- Which of the following shows the file, which is deleted recently ?
- Desktop (b) My Document
(c) Recycle Bin (d) All of these
- Which of the following attribute prevents changes to files and folders ?
- Hidden (b) Read only
(c) System (d) None of the above
- “Phone and Modem” option comes under
- Control Panel (b) My Computer
(c) Recycle Bin (d) None of the above
- Pointing device is used as
- Input device (b) Input and Output device
(c) Both (a) & (b) (d) None of the above
- For accessing the network, the most appropriate icon to use is
- Recycle Bin (b) Network Neighborhood
(c) My Computer (d) None of the above
- Which of the following is not a multimedia input device ?
- Digital Camera (b) Video Camera
(c) Music input system (d) Keyboard
- To install any software in Windows, use
- Add/Remove Hardware of Control Panel
- Add/Remove Programs of Control Panel
- Administrative Tools of Control Panel
- None of the above
- Which of the following option is clicked to display the RAM size and CPU details of computer ?
- My Computer ® System (b) My Document ® System
(c) Control Panel ® System (d) None of the above
- Data can be imported into MS-Access database from
- Excel file (b) Word file (c) PowerPoint file (d) HTML file
- The MPEG stands for
- Movie Picture Experts Group (b) Moving Platform Experts Group
(c) Multiple Platform Experts Group (d) Moving Picture Experts Group
- Which of the following is not a database key ?
- Index key (b) Candidate key (c) Unique key (d) Primary key
- Graphics for word processor
- Peripheral (b) Clip Art (c) Highlight (d) Execute
- Special effects used to introduce slides in a presentation are called
- Effects (b) Custom Animations
(c) Transitions (d) Present Animations
- means changing font
- Leading (b) Tracking (c) Editing (d) Scaling
- Which shortcut keys insert a new slide in current presentation ?
- Ctrl + M (b) Ctrl + S (c) Ctrl + A (d) All of these
- If you select Insert >> Picture >> From file, then you
- Insert clip arts only (b) Insert picture only
(c) both (a) & (b) (d) None of these
- To add a slide in PowerPoint presentation, which option is to be selected ?
- File ® add new slide (b) File ® open
(c) File ® new (d) Insert ® new slide
- Which of the following is not an option when printing handouts per page ?
- Two slides (b) Three slides (c) Five slides (d) Six slides
- Keys you press when some text is to be copied are
- Ctrl + A (b) Ctrl + C (c) Alt + C (d) Alt + D
- Thesaurus tool in MS-Word is used for
- Spelling suggestions (b) Grammar options
(c) Synonyms and Antonyms word (d) All of the above
- To send email to a large group at one time, we use
- List serv (b) Group (c) Alias (d) Mail Sever
- In MS-Word which key underline the selected text ?
- Ctrl + W (b) Ctrl + Z
|
(c) Ctrl + U (d) None of the above
(c) ¯ÖÖ¾Ö¸ü¯ÖÖ‡Ó™ü ±úÖ‡»Ö ÃÖê (d) HTML ±úÖ‡»Ö ÃÖê
(a) »ÖßØ›üÝÖ (b) ™ÒîüØÛúÝÖ (c) ‹ê×›üØ™üÝÖ (d) ÃÛêúØ»ÖÝÖ
- Which of the following command of MS-Excel converts a column of data into row ?
- Orientation (b) Cut and Paste
(c) Paste Special ® Transpose (d) All of these
- The database schema is written in
- DDL (b) HLL (c) DML (d) DCL
- Which of the following is the default extension of an Excel Worksheet ?
- .exw (b) .xls (c) .wks (d) None of these
- Which of the following function of Excel get the column and row total automatically ?
- Cell ( ) (b) Auto Sum ( )
(c) Auto SumX( ) (d) None of these
- A formula entered into a cell in MS-Excel must begin with the sign
(a) + or – (b) * or + (c) = or * (d) + or =
- To open the format cell dialog Box in MS-Excel, press the keys
(a) Alt + 1 (b) Ctrl + 1 | (c) | Ctrl+Shift+1 (d) F1 | |||
127. | Report generator is used to (a) update files | (b) | data entry | ||
(c) print files on paper | (d) | delete files | |||
128. | Portrait and Landscape are (a) Paper size | (b) | Paper layout | ||
(c) Style | (d) | Paper orientation | |||
129. | Which of the following function number ? (a) UPPER ( ) (b) CELL ( ) | of MS-Excel (c) | is used to get the absolute value SUM ( ) (d) ABS ( ) | of | a |
- How to specify cell range from A9 to A99 in MS-Excel ?
(a) (A9, A99) (b) (A9 to A99) (c) (A9 : A99) (d) (A9 – A99)
- Which of the following is an absolute cell reference in MS-Excel ?
(a) !A!1 (b) $A$1 (c) #a#1 (d) A1
- is a table consisting of rows and
- Worksheet (b) Cell (c) Workbook (d) Range
- Which of the following Operating System does not implement multi-tasking truly ?
- Windows 98 (b) Windows NT (c) Windows XP (d) MS-DOS
- In MS-Word the option “Mail Merge” comes under
- Insert Menu (b) Format Menu
(c) Tools Menu (d) None of the above
- In MS-Word paragraph comes under the
- Insert Menu (b) Format Menu
(c) View Menu (d) None of the above
136. | Microsoft Office is a | ||
(a) Desktop Application (b) | Operating System | ||
(c) Command Window (d) | None of the above | ||
137. | A popular presentation program for Windows in | MS-Office is | |
(a) MS-Word (b) | MS-PowerPoint | ||
(c) MS-Access (d) | None of the above | ||
138. | In MS-Word, what is the smallest and largest | font size available in font size tool | on |
formatting toolbar ? | |||
(a) 8 and 68 (b) 6 and 72 (c) | 6 and 68 (d) 8 and 72 |
- In MS-Word, on which page the header or the footer is printed by default ?
- On first page (b) On last page
(c) On alternate page (d) On every page
- In MS-Word, the ‘Font’ command comes under
- Format Menu (b) File Menu
(c) Edit Menu (d) None of the above
- In MS-Word, which key is used to select all the text in the document ?
- Ctrl + T (b) Ctrl + A (c) Ctrl + F (d) Ctrl + N
- The default font size in MS-Word-2007 page is
(a) 8 (b) 9 (c) 10 (d) 11
- In MS-Word the default values for the top and left margin respectively are
(a) 0.5², 1² (b) 1², 1.25² (c) 1.25², 1.25² (d) 1², 1.5²
- When the pointer is positioned on a Word, it is shaped like a hand, which shows
- Grammar error (b) Hyperlinking
(c) Screen tip (d) Formatting error
- What is the default font type used in MS-Word-2007 document ?
- Calibri (Body) (b) Arial
(c) Algerian (d) Bold
- What is the extension of MS-PowerPoint files ?
- .fil (b) .dot (c) .txt (d) .ppt
- In MS-Word, which of the following option is not available in Insert ?
- Chart (b) Clip Art (c) Graph (d) Word Art
- Which of the following line spacing is invalid in MS-Word ?
(a) Single (b) | Double | (c) | Triple (d) | Multiple | |
149. | Print option is in . (a) File tab (b) | Insert tab | (c) | Page layout tab (d) | View tab |
- In MS-Word cut, copy and paste are in group in the home
- Font (b) Page Setup (c) Clip board (d) Editing
Download word file for your offline use : ukpsc computer programmer qp set a
download answer key : ukpsc computer programmer qp set a - answer key