Sunday, 6 August 2017

Computer Questions


Q1. Choose the odd one out:
(a) Brute force attack
(b) Virtual Reality
(c) Unethical Phreaker
(d) Keystroke logging
(e) Cross-site Scripting

S1. Ans.(b)
Sol. Except Virtual Reality all other are obvious security threats to computers and data.

Q2. The type of threats on the security of a computer system or network are ……………………..
i) Interruption   ii) Interception     iii) Modification
iv) Creation       v) Fabrication 
(a) i, ii, iii and iv only
(b) ii, iii, iv and v only
(c) i, ii, iii and v only
(d) iii, iv and v only
(e) All i, ii, iii, iv and v

S2. Ans.(c)
Sol. Except Creation all other actions performed by unauthorised and suspicious person.

Q3. State whether true or false:
i) A worm mails a copy of itself to other systems.
ii) A worm executes a copy of itself on another system.
iii) A worm cannot be spread without a human action, (such as running an infected program) to keep it going.
(a) True, False, True
(b) False, True, True
(c) True, True, False
(d) False, False, False
(e) True, True, True

S3. Ans.(c)
Sol. Worms spread from computer to computer, but unlike a virus, it has the capability to travel without any human action.

Q4. Which of the following would most likely not be a symptom of a virus?
(a) Existing program files and icons disappear
(b) The CD-ROM stops functioning
(c) The web browser opens to an unusual home page
(d) Odd message or images are displayed on the screen
(e) None of these

S4. Ans.(b)
Sol. Except option (b) all others are the symptoms of a computer virus.

Q5. VIRUS stands for___________.
(a) Vital Information Resources Under Siege
(b) Viral Important Record User Searched
(c) Very Interchanged Result Until Source
(d) Very Intelligent Resources Under Search
(e) None of these

S5. Ans.(a)
Sol. VIRUS stands for Vital Information Resources Under Siege

Q6. A virus that migrates freely within a large population of unauthorized email user is called a __________.
(a) worm
(b) flame war
(c) macro
(d) plagiarism
(e) None of these

S6. Ans.(c)
Sol. A macro virus is a virus that is written in a macro language: a programming language which is embedded inside a software application (e.g., word processors and spreadsheet applications)

Q7. The first Computer Virus is:
(a) Creeper
(b) Sasser
(c) Blaster
(d) All of the above
(e) None of these

S7. Ans.(a)
Sol. Creeper virus is a computer virus that is most commonly recognized as the first computer virus.

Q8. Which of the following statements is incorrect about the UNIQUE KEY constraint?
(a) Unique key columns do not accept duplicate values.
(b) One table can have only one unique key.
(c) By default, unique key columns accept null values unless the NOT NULL constraint is specified.
(d) The same combinations of columns should not make both unique and primary keys.
(e) None of these

S8. Ans.(b)
Sol. Since one table can have at the most one primary key to avoid duplicates in other columns of the table, unique key can be defined. We can make one or more unique keys in a single table.

Q9. Which of the following heading elements displays text with the same size as the normal text written in an HTML document?
(a) <H1>
(b) <H2>
(c) <H3>
(d) <H4>
(e) <H5>

S9. Ans.(d)
Sol. The text written within the H4 element has the same size as the normal plain text, whereas the text written within the H1, H2 and H3 elements are larger than the normal text. Text written within the H5 and H6 elements has smaller size than the normal text.

Q10. Which of the following HTML tags is a logical style tag?
(a) <B>
(b) <I>
(c) <SMALL>
(d) <ABBR>
(e) None of these

S10. Ans.(d)
Sol. In HTML, logical style tags specify that the enclosed text has a specific meaning, context, or usage. The <ABBR> is a logical style tag, which conveys to the Web browser that the text enclosed within this tag is an abbreviation.

Q11. What does DDoS stand for?
(a) Data Denial-of-Service
(b) Distributed Denial-of-Service
(c) Distributed Data of Server
(d) Distribution of Data Service
(e) None of these

S11. Ans.(b)
Sol. Distributed Denial-of-Service (DDoS) attack is a type of attack that is carried out by using multiple computers. These DDoS attacks aim at targeting computer networks of an organisation, such as Digital Subscriber Line (DSL) and cable.

Q12. Which of the following statements is incorrect about a message-switched network?
(a) It reduces traffic congestion.
(b) It allows prioritizing of messages.
(c) It allows broadcasting of messages.
(d) It is an inexpensive network.
(e) It is not compatible with videoconferencing.

S12. Ans.(d)
Sol. In a message-switched network, a packet containing the entire message is transmitted over the network. It is a more expensive network.

Q13. Which of the following statements is false in the context of client/server network?
(a) It is expensive to set up.
(b) It requires a specialized server.
(c) It is a slow network.
(d) It is highly secure.
(e) It is a congested network.

S13. Ans.(c)
Sol. The client/server network contains a centralised server that manages and controls all the other nodes of the network. It is expensive as it requires NOS and a specialized server system. It is highly secure and processes good speed. However, it becomes congested when more clients simultaneously request for a service to the server.

Q14. A pathway inside a computer that carries data between hardware components is called _____________.
(a) carrier signal
(b) data bus
(c) digital signal
(d) analog signal
(e) switching

S14. Ans.(b)
Sol. A data bus connects internal components to the motherboard and acts as a carrier for the data.

Q15. Which of the following is related to simplex communication?
(a) Single wire and two-sided communication
(b) Television
(c) Two-wire communication
(d) Walkie-talkie
(e) None of these

S15. Ans.(b)
Sol. Television is an example of simplex communication.

Data Interpretation


Directions (Q.1-5): Study the following table carefully and answer the questions given below: 

Marks obtained by the six students in five subjects in annual examination


Q1. Who stood first in the examination? 
(a) F
(b) E
(c) A
(d) B
(e) D

Q2. What is difference between overall percentage marks obtained by B and E? 
(a) 26.67
(b) 24.66
(c) 23.22 
(d) 27.64
(e) 25.33

Q3. How many students obtained more marks than average marks in Physics by all the students? 
(a) 2
(b) 4
(c) 1
(d) 6
(e) 3

Q4. Marks obtained by B in Chem. and Eng. together are approximately what percent of the total marks obtained by F in all subjectstogether? 
(a) 57.76
(b) 58.26
(c) 60.23
(d) 59.14
(e) 49.95

Q5. How many students obtained less than 70% marks in aggregate? 
(a) 3
(b) 2
(c) 1
(d) 4
(e) None of these

Directions (Q.6-10): Study the table carefully and answer the question given below: 

Number of new employees and also who left the company, since 2010


Q6. What is the difference between the total number of Technicians added to the company and total number of accountants added to company during year 2011-2015? 
(a) 84
(b) 88
(c) 89
(d) 93
(e) None of these

Q7. What is total number of peons and operators together in company in 2014? 
(a) 2626
(b) 2296
(c) 2532
(d) 2438
(e) None of these

Q8. The number of Technician in 2013 is what percent more/less than number of Accountants in 2012? 
(a) 16.23%
(b) 17.85%
(c) 18.21%
(d) 16.81%
(e) 15.34%

Q9. What is average of total number of employees of all categories in year 2012? 
(a) 1005
(b) 1310 
(c) 1205
(d) 1195
(e) None of these

Q10. The total number of managers in 2014 in company is what approximately percent of an accountant in that year? 
(a) 67.31%
(b) 72.32%
(c) 69.17%
(d) 68.56%
(e) 64.67%

Directions (Q.11-15): What should come in place of question-mark (?) in the following question? 

 
 
 
 

Solutions 































 





















Data Interpretation


Directions (Q.1-5): Study the following table and bar graph to answer the questions given below it.
Percentage of appeared and qualified candidates in a competitive examination from different institutes

Appeared Candidates = 36000
Institute
%of appeared candidates
A
12%
B
18%
C
20%
D
15%
E
10%
F
25%

Q1. What is the ratio of the qualified candidates from institutes A, B and C together to the appeared candidates from institutes D, E and F?
(a) 52 : 225
(b) 26 : 125
(c) 125 : 26
(d) 13 : 200
(e) None of these

Q2. What percent of the candidates from institute ‘E’ has been declared qualified out of the total candidates appeared from this institute?
(a) 16%
(b) 26%
(c) 16.66%
(d) 18%
(e) None of these

Q3. What is the approximate percentage of students qualified w.r.t. to those appeared from the institutes B and C together?
(a) 20
(b) 21
(c) 22
(d) 23
(e) 24

Q4. Which institute has the highest percentage of candidates qualified w.r.t. to those appeared?
(a) A
(b) B
(c) C
(d) D
(e) None of these

Q5. What is the average number of appeared candidates from the institutes A, B and F together?
(a) 19800
(b) 2200
(c) 6600
(d) 8600
(e) None of these

Directions (Q.6-10): In the following number series only one number is wrong. Find out the wrong number.
Q6. 5    15    30    135    405    1215    3645
(a) 15
(b) 30
(c) 405 
(d) 3645
(e) None of these

Q7. 36     54       18        27         9         18.5        4.5
(a) 4.5
(b) 18.5
(c) 54
(d) 18
(e) 27

Q8. 582       605       588       611        634       617      600
(a) 634
(b) 611
(c) 605
(d) 600
(e) 582

Q9. 46080       3840       384      48     24     2       1
(a) 1
(b) 2
(c) 24
(d) 384
(e) 48

Q10. 1        8         27         64        124         216        343
(a) 8
(b) 27
(c) 64
(d) 124
(e) 216

Directions (Q.11-15): Study the following graph carefully to answer the questions that follow: 
Number of Girls and Boys participating in a rally from five different schools


Q11. What is the total number of girls participating in the rally from schools A and C together? 
(a) 825 
(b) 875 
(c) 950 
(d) 975 
(e) None of these 

Q12. The number of boys participating in the rally from school B is what percent of the total number of children participating in the rally from that school? (Rounded off to two digits after decimal.) 
(a) 48.84 %
(b) 47.37 %
(c) 49.28 %
(d) 46.46 %
(e) None of these 

Q13. The number of girls participating in the rally from School E is approximately what percent of the number of boys participating in the rally from the same school? 
(a) 81 %
(b) 106 %
(c)122 %
(d) 98 %
(e) 114 %

Q14. What is the respective ratio of total number of girls participating in the rally from schools D and C together to the total number of boys participating in the rally from schools A and B together? 
(a) 23 : 18 
(b) 43 : 35 
(c) 41 : 38 
(d) 21 : 20 
(e) None of these 

Q15. What is the average number of girls participating in the rally from all schools together? 
(a) 500 
(b) 460
(c) 525 
(d) 505 
(e) None of these 

SOLUTIONS