1. In which
communication method oral
and written form of lanaguage is used?
A) Verbal
B) Non-Verbal
C) Visual
D) All of these
Answer
is A) Verbal communication method
2. This is the backbone
of a communication cycle.
A) Channel
B) Message
C) Feedback
D) All of these
Answer
is C) Feedback
3. Due to noise people
aren't able to understand the speaker. What type of barrier is it?
A) Mechanical
B) Linguistic
C) Psychological
D) Physical
Answer
is D) Physical
4. What is called giving
response after understaning a message in communication cyle?
A) Channel
B) Encoding
C) Feedback
D) Decoding
Answer
is C) Feedback
5. This is the process in which message is translated and understood
its meaning.
A) Decoding
B) Encoding
C) Translating
D) None of these Answer is
A) Decoding
6. This is called graphical
method of communication.
A) Verbal
B) Non-Verbal
C) Visual
D) None of these
Answer
is C) Visual communication method
7. In this communication method body movement and face expression is used.
A) Non-Verbal
B) Verbal
C) Visual
D) All of these
Answer
is A) Non-Verbal
8. In this process thoughts are convered into understandable
format.
A) Encoding
B) Decoding
C) Translation
D) Language
Answer
is A) Encoding
9. What is called a group of words that gives complete meaing?
A) Paragrap
B) Sentence
C) Passage
D) Idea
Answer
is B) Sentence
10. Which feedback is mostly used for informal and formative assesment?
A) Non-Verbal
B) Written
C) Verbal
D) All of these
Answer is C) Verbal
11. Climate fluctuating, your job or relationship is
___ factor of stress.
A)
Internal
B) External
C) Mental
D) Thinking
Answer is B) External
12. Lack of self-confidence, stage fear or illness is
___ factor of stress.
A)
External
B) Mental
C) Emotional
D) Internal
Answer is D) Internal
13. Which is not a good
stress management technique?
A)
Shouting
B) Nature Walk
C) Talking with friends
D) Meditation
Answer is A) Shouting
14. ___ is the thinking skill that
focuses on the ability to accurately
judge your own performance and hebaviour & respond appropriately.
A)
Self - Awareness
B) Understanding
C) Intelligence
D) All of these
Answer is A) Self - Awareness
15. This is the ability
to do what needs to be
done, without
influence from other people or situation.
A)
Self - Awareness
B) Self - Decipline
C) Self - Regulation
D) Self - Motivation
Answer is D) Self - Motivation
16. What is called an interface between computer and
user?
A)
Software
B) Hardware
C) Application
D) All of these
Answer is A) Software
17. In __ operating
system, the user sends commands and instruction to computer in character form.
A)
GUI
B) TUI
C) Command
D) CUI
Answer is D) CUI (Character
User Interface)
18. In ___ Operating system, the interface is graphical, the user interact with figures and
graphs on the screen.
A)
GUI
B) CUI
C) TUI
D) None of these
Answer is A) GUI (Graphical
User Interface)
19. Which OS(operating
system) provides access to a single user at a time?
A)
Single - User
B) Multiple - User
C) DOS
D) Single - User & DOS
Answer is D) Single - User and
DOS
20. Which OS (operating system) allows access to two or more users to run
the same program at the same time on a network?
A)
Multi - Tasking
B) Linux
C) Single - User
D) Multi - Tasking & Linux
Answer is D) Multi - Tasking
and Linux
21. Which OS (operating system) allows access to two or more users to run
the same program at the same time on a network?
A)
Multi - User
B) Linux
C) Single - User
D) Multi - User & Linux
Answer is D) Multi - User and
Linux
22. Which OS allows the computer to work on more than one application by switching among
them?
A)
Distributed
B) Multi - Tasking
C) Real - Time
D) Many -Tasking
Answer is B) Multi - Tasking
23. Which OS processing is carried independently in more than one location?
A)
Reat Time
B) Multi - Tasking
C) Distributed
D) Multi - User
Answer is C) Distributed
24. Which OS processes instruction and produces a
response within a specific time?
A)
Multi - Tasking
B) Distributed
C) Real Time
D) Single User
Answer is C) Real Time
25. What is file
extension?
A)
Last Name of File
B) First Name of File
C) MIddle Name of File
D) All of these
Answer is A) Last Name of File
26. OS facilitates
___ for proper file system that helps to organize and obtain grouped
information.
A)
FAT (file allocation table)
B) NTFS (new file allocation
table)
C) EXT (extended file system)
D) All of these
Answer is D) All of these; FAT
& NTFS => Window OS; EXT => Linux
27. What is the file extension of MS Word, MS Excel, MS PowerPoint and MS Access
A)
.doc, .xls, .ppt, .accdb
B) .dox, .exe, .ptp, .msd
C) .txt, exe, .pdf, .she
D) None of these
Answer is A) .doc, .xls, .ppt,
.accdb
28. What is the file extension of open office text, open office database, open office spreadsheet?
A)
.doc, .accdb, .xls
B) .odt, .odb, .ods
C) .odw, odd, odt
D) None of these
Answer is B) .odt, .odb, .ods
29. File name can contain ____
characters?
A)
254
B) 255
C) 256
D) 256
Answer is B) 255
30. What is called a software developed to harm a computer?
A)
Application Application
B) Utility Software
C) Virus
D) All of these
Answer is C) Virus
Chapter - Digital Document
31. This is a set of
pre-defined formatting options that can be applied in open office
writer.
A)
Style
B) Template
C) Formatting
D) Designs
Answer is A) Style
32. Which window is used to apply, create and edit formatting styles?
A)
Style Windows
B) Formatting Window
C) Style and Formatting Window
D) Design Window
Answer is C) Style and
Formatting Window
33. Which style is used to formate:
character, words
and phrase in a paragraph?
A)
Paragraph Styles
B) Frame Styles
C) Page Style
D) Character Styles
Answer is D) Character Styles
34. What style is used to apply font, layout and numbering
of a paragraph in a document?
A)
Character Styles
B) Paragraph Styles
C) Page Styles
D) Frame Styles
Answer is B) Paragraph Styles
35. Which style is used to format frame's layout, position and graphics of a document?
A)
Page Styles
B) Frame Styles
C) Paragraph Styles
D) Character Styles
Answer is B) Frame Styles
36. Which style is used to formate page labout, page number and header and footer of a
document?
A)
Paragraph Styles
B) Character Styles
C) Page Styles
D) Frame Styles
Answer is C) Page Styles
37. Which style is used to apply bullets and numbering in a document?
A)
Numbering and List Styles
B) Page Styles
C) Frame Styles
D) Character Styles
Answer is A) Numbering and
List Styles
38. Which function key is used for
'Styles and Formatting' window in open office?
A)
F10
B) F11
C) F12
D) F13
Answer is B) F11
39. Which is used to quickly
apply the selected style from 'Styles and Formatting' window to the text in a
document?
A)
Fill Formate Mode
B) Create New Style
C) Update Styles
D) Drag and Drop Mode
Answer is A) Fill Formate Mode
40. Which is used to create a new style in 'Styles and Formatting' window in open office?
A)
New Styles
B) Create Styles
C) Design Styles
D) New Style from Selection
Answer is D) New Style from
Selection
41. What is refered to the
collection and the integration of data from multiple worksheets or workbooks into a single worksheet?
A)
Consolidating Data
B) Sorting Data
C) Subtotal
D) Combine Data Answer is A) Consolidating Data
42. This is used to automatically create groups and apply inbuilt functions
like SUM, COUNT, AVERAGE
to summarize data.
A)
Analysis
B) Subtotal
C) Total Data
D) Scenaio Answer is B) Subtotal
43. Which tab gives
consolidating data option
in open office Calc?
A)
File Tab
B) View Tab
C) Data Tab
D) Edit Tab Answer is C) Data Tab
44. Which function
isn't available in consolidating data?
A)
Sum and Count
B) Max and Min
C) Average and Product
D) Percentage Answer is D) Percentage
45. Which option isn't present in more button
in consolidating data?
A)
Header and Footer
B) Link to source Data
C) Column Lable
D) Row Label Answer is A) Header and Footer
46. In which tab
subtotal option is available in open office Calc?
A)
File Tab
B) Edit Tab
C) View Tab
D) Data Tab Answer is D) Data Tab
47. Which function isn't available in subtotal in open
office Calc?
A)
Max and Min
B) Sum and Count
C) Average and Product
D) Percentage Answer is D) Percentage
48. Which option is used to make a group of items in
subtotal?
A)
Group By
B) Join By
C) Add By
D) Collect By Answer is A) Group By
49. In which tab
scenario option is available in open office Calc?
A)
File Tab
B) Data Tab
C) Tools Tab
D) Window Tab Answer is C) Tools Tab
50. Which tool is used to test 'what if' question?
A)
Solver Tool
B) Goal Seek
C) Subtotal Tool
D) Scenario Tool Answer is D) Scenario Tool
51. Which of the following
application is not appropriate to store data about ABC Bank customers?
A)
Open Office Base
B) MS Access
C) Open Office Writer
D) MS Excel Answer is C) Open Office Writer
52. When you open a new spreadsheet, by default, it has a sheet named
________ which is managed using tabs at the bottom of the spreadsheet.
A)
Sheet1
B) Untitled1
C) Worksheet1
D) New Sheet Answer is A) Sheet1
53. Reviewers and authors can
add their ______ to explain their changes in the cell of Spreadsheet.
A) Comments
B) Hyperlink
C) Worksheet
D) Macros
54. In Calc, Arguments
passed to a macro from Calc are always ___________.
A)
Cell Reference
B) Value
C) Both a and b
D) Sheet Reference Answer is B) Value
55. In a spreadsheet using to
create a hyperlink to a web
FTP or Telnet, click on the __________ icon available in Hyperlink
dialog box.
A)
Browser
B) Hyperlink
C) Internet
D) Mail & News Answer is C) Internet
56. A _________ refers to a
cell or a range of cells on a worksheet and can be used to find the
values or data that you want formula to calculate.
A)
Cell reference
B) Sheet Reference
C) Block
D) Autofill Answer is A) Cell reference
57. ________ function takes
data from a series of worksheets or workbooks and summaries it into a single worksheet that you can
update easily.
A)
Data Combination
B) Data Consolidation
C) Data Merging
D) Data Concatenation Answer is B) Data Consolidation
58. __________ store data in a
single table which is suitable to store less amount of Data.
A)
Flat File
B) Relational
C) Mini File
D) Single File Answer is A) Flat File
59. Which function
cannot be performed through Subtotal in a Spreadsheet?
A)
Sum
B) Product
C) Average
D) Percentage Answer is D) Percentage
60. Scenarios are a tool to test ____
questions.
A)
Auto
B) Goal Seek
C) What-if
D) Drop Down Answer is C) What-if
61. _______ provides a way to
combine data from same or
multiple worksheet.
A)
Subtotal
B) Consolidate
C) Solver
D) All of these Answer is B) Consolidate
62. In ____ tag the consolidate
option is available in Open Office Calc.
A)
Data Tab
B) Tool Tab
C) Insert Tab
D) Formula Tab Answer is A) Data Tab
63. ____ is the by default function in
consolidating data in Open Office Calc.
A)
Min
B) Product
C) Average
D) Sum Answer is D) Sum
64. ______ function is
not available in consolidating data in Open Office Calc.
A)
Count
B) Average
C) Product
D) Percentage Answer is D) Percentage
65. ____ option is not present in more options
in consolidating data in Open Office Calc.
A)
Row Lables
B) Headings
C) Column Lables
D) Link to data source Answer is B) Headings
66. ____ symbol is used before
writting a formuls in Open Office Calc.
A)
&
B) %
C) =
D) @ Answer is C) =
67. ____ is used to
automatically create groups and apply inbuilt function in Open Office Calc.
A)
Consolidate
B) Subtotal
C) Autosum
D) None of these Answer is B) Subtotal
8. In ____ tag subtotal
option is available in Open Office Calc.
A)
Data Tab
B) Tool Tab
C) Function Tab
D) Insert Tab Answer is A) Data Tab
69. ____ is the by default function in Subtotal in Open Office Calc.
A)
Sum
B) Product
C) Average
D) Percentage Answer is A) Sum
70. ____ function is not present in subtotal in Open Office
Calc.
A)
Subtract
B) Count
C) Max
D) Average Answer is A) Subtract
71. ___________ database is a type of
database that stores data
in several tables.
A)
Flat
B) Relational
C) both (a) and (b)
D) None of them Answer is B) Relational
72. In database _________ helps
us to retrieve the
filtered data based upon some conditions.
A)
Forms
B) Reports
C) Queries
D) Table Answer is C) Queries
73. Rudrakshh wants that the name column of a table must not be left blank. Help him to
identify the field property for this purpose.
A)
Length
B) Default
C) Entry Required
D) Format Answer is C) Entry Required
74. ___________ can be set for a field if the user doesn't provide any value while entering
the values in the table.
A)
Required
B) Default
C) Primary Key
D) Format Answer is B) Default
75. Aadya wants to create a connection
between two or more tables.
Suggest her the option to accomplish the task.
A)
Table
B) Form
C) Relationships
D) Sorting Answer is C) Relationships
76. _____________ data type takes the values in the form of 0 and 1 in the
database.
A)
Integer
B) Text
C) Boolean
D) Memo Answer is C) Boolean
77. ____________statement is used
to retrieve records
in a database.
A)
Alter
B) Update
C) Select
D) Create Answer is C) Select
78. A ___________ represents a single, data item
in a table.
A)
Row
B) Column
C) Datatype
D) Primary Key Answer is A) Row
79. Database servers are
referred to as _______________.
A)
Front-ends
B) Back-ends
C) Clients
D) Model Answer is B) Back-ends
80. A table is a set of data elements that is organized using a model of vertical ___________ and
horizontal ____________.
A)
Rows, Tables
B) Columns, Rows
C) Rows, Columns
D) Forms, Reports Answer is B) Columns, Rows
81. _____ is the full form of
SQL.
A)
Structured Query Language
B) Structure Quick Language
C) Structure Query Language
D) Smart Query Lanaguage Answer is A) Structured Query Language
82. What is the full form of
DDL?
A)
Default Defination Language
B) Detailed Default Language
C) Data Defination Language
D) Default Defined Language Answer is C) Data Defination Language
83. ( +, -, *, /, %
) operators are called _____
A)
Logical Operators
B) Arithmatical Operators
C) Relational Operators
D) Maths Signs Answer is B) Arithmatical Operators
84. ( <, > <=,
>=, <> ) operators are called _______
A)
Logical Operators
B) Arithmatical Operators
C) Relational Operators
D) Comparision Operators Answer is D) Comparision Operators
85. ( AND, OR, NOT,
BETWEEN, ALL) operators are called _____
A)
Logical Operators
B) Arithmatical Operators
C) Relational Operators
D) Comparision Operators Answer is A) Logical Operators
86. _____ isn't DDL
command in SQL.
A)
Create
B) Delete
C) Alter
D) Drop Answer is B) Delete
87. ____ is a DDL command in DDL.
A)
Rename
B) Insert
C) Update
D) Select Answer is A) Rename
88. ____ and _____ are the DDL commands in SQL.
A)
Drop, Alter
B) Update, Insert
C) Delete, Drop
D) Select, Create Answer is A) Drop, Alter
89. Which is DDL commands in SQL?
A)
Create
B) Rename
C) Drop
D) All the these Answer is D) All the these
90. Which is DDL commands in SQL?
A)
Insert
B) Update
C) Select
D) None of these Answer is D) None of these
91. _____ DDL command is used to
build a table in SQL.
A)
Make
B) Form
C) Develop
D) Create Answer is D) Create
92. ____ key setup a
relationship among tables in a database.
A)
Primary Key
B) Foreign Key
C) Composite Key
D) Main Key Answer is B) Foreign Key
93. ____ key helps to access records in a
table in a database.
A)
Primary Key
B) Foreign Key
C) Composite Key
D) Main Key Answer is A) Primary Key
94. A table can have only one ____ key in a
table in a database.
A)
Primary Key
B) Foreign Key
C) Composite Key
D) Main Key Answer is A) Primary Key
95. A table can have
more than one ____ keys in a table in a database.
A)
Primary Key
B) Foreign Key
C) Composite Key
D) Main Key Answer is C) Composite Key
96. _____ key has the same properties like a primary
key in a table in database.
A)
Primary Key
B) Foreign Key
C) Composite Key
D) Main Key Answer is C) Composite Key
97. ____ key has the unique
record and doesn't remain
empty in a table in a database.
A)
Primary Key
B) Foreign Key
C) Composite Key
D) Main Key Answer is A) Primary Key
98. ____ DDL command is used to delete the structure
of a table in SQL.
A)
Drop
B) Update
C) Delete
D) Select Answer is A) Drop
99. ____ DDL command is used to rename a table in SQL.
A)
Create
B) Rename
C) Name
D) Update Answer is B) Rename
100. ____ DDL command is used to update the struture of a
table in SQL.
A)
Change
B) Update
C) Select
D) Alter Answer is D) Alter
Sport |
Use above Table for MCQS
101. Which DDL command is used
to build a table "Sport " in SQL?
A) Create table Sport (Roll No
Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int);
B) Make table Sport (Roll No
Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int)
C) Build table Sport (Roll No
Char(3), Class Char(3), Name varchar(15), Game char(5), Marks Int);
D) Create Sport (Roll No Char(3),
Class Char(3), Name varchar(15), Game char(5), Marks Int);
Answer is A) Create table
Sport (Roll No Char(3), Class Char(3), Name varchar(15), Game char(5), Marks
Int);
102. This DML command is used to enter record in table "Sport" in
SQL.
A)
Enter into Sport values ( 11, 9, "Surjeet", "Cricket",
"B", 68);
B) Put into Sport ( 11, 9,
"Surjeet", "Cricket", "B", 68);
C) Insert in Sport value ( 11, 9,
"Surjeet", "Cricket", "B", 68);
D) Insert into Sport values ( 11,
9, "Surjeet", "Cricket", "B", 68);
Answer is D) Insert into Sport
values ( 11, 9, "Surjeet", "Cricket", "B", 68);
103. ____ is the DML command to display all record from table
"Sport" in SQL.
A)
Display record from table Sport:
B) Select * from Sport;
C) Select all record from Sport;
D) Select * from table Sport; Answer is B) Select * from Sport;
104. Which DML command is used to display "Class
& Name" columns from table "Sport" in SQL?
A)
Select class, Name from table Sport;
B) Query class, Name from Sport;
C) Select class, Name from Sport;
D) Display class, Name from
Sport; Answer is C) Select
class, Name from Sport;
105. Replace
Grade = A where class = 9 using DML command in SQL.
A)
Change table Sport set Grade = "A" where class = 9;
B) Update Sport replace Grade =
"A" check class = 9;
C) Update table set Grade =
"A" where class = 9
D) Update Sport set Grade =
"A" where class = 9; Answer
is D) Update Sport
set Grade = "A" where class = 9;
106. _____ is the DML command to display all records of class = 8 students in SQL.
A)
Show all from Sport Where class = 8;
B) Select * from Sport Where
class = 8;
C) Display all from Sport Where
class = 8;
D) Select * from table Sport
Where class = 8
Answer is B) Select * from
Sport Where class = 8;
107. Which DML command is used to display all record, who have got Marks >=70, from table "Sport" in
SQL.
A)
Selct * from Sport where marks >= 70;
B) Selct * from Sport check marks
>= 70;
C) Display all from Sport where
marks >= 70;
D) Display all from Sport find
marks >= 70; Answer is A) Selct * from Sport where marks >= 70;
108. ____ DML command is used to delete the record of
"Surjeet" from table "Sport" in SQL.
A)
Drop from Sport Where Name = "Surjeet";
B) Delete from Sport cheeck Name
= "Surjeet";
C) Delete from Sport Where Name =
"Surjeet";
D) Delete from table Sport Where
Name = "Surjeet";
Answer is C) Delete from Sport
Where Name = "Surjeet";
109. This DDL command is used to delete the
table "Sport" in SQL.
A)
Drop table Sport;
B) Delete table Sport;
C) Drop Sport table;
D) Drop table Sport Answer is A) Drop table Sport;
110. Which DDL command is used to delete one column
"Class" from table "Sport" in SQL?
A)
Drop column class from Sport:
B) Drop column class from table
Sport
C) Delete column class from
Sport;
D) Alter table Sport drop column class; Answer is D) Alter table Sport drop
column class;
111. What is called a computer network setup in a building?
A)
Local Area Network
B) Metro Area Network
C) Personal Area Network
D) Wide Area Network Answer is A) Local Area Network
112. What is called a Computer Network connecting cities?
A)
Wide Area Network
B) Local Area Network
C) Personal Area Network
D) Metro Area Network Answer is D) MetroPOLITAN Area Network
113. Internet is which type of
Computer Network?
A)
Local Area Network
B) Wide Area Network
C) Metro Area Network
D) Personal Area Network Answer is B) Wide Area Network
114. What is called a short range of Computer Network for personal use?
A)
Local Area Network
B) Wide Area Network
C) Metro Area Network
D) Personal Area Network Answer is D) Personal Area Network
115. Which is not the advantage of
Computer network?
A)
Computer Hardware sharing.
B) Computer Software sharing.
C) Message sharing
D) Security issues Answer is D) Security issues
116. In which Network Architecture
all computers are equal?
A)
Peer to Peer
B) Client - Server
C) Ring Network
D) Star Network
Answer is A) In Peer to Peer
Architecture all computers are equal.
117. What is called a Geometrical
arrangement of computers in a network?
A)
Tree Topology
B) Client - Server
C) Topology
D) Peer to Peer Answer is C) A Geometical arrangment of
computer in a network is called Topology.
118. In which Network Architecture one computer serves and other computers request for
resources?
A)
Bus Topology.
B) Mesh Topology.
C) Tree Network.
D) Client - Server. Answer is D) In Client - Server
Architecture server always serves and clients request for resources.
119. In which topology a single
communication channel is called backbone of a network?
A)
Star Topology
B) Bus Topology
C) Ring Topology
D) Tree Topology
Answer is B) In Bus Topology
all computer are connected with a single communcation chanel called backbone.
120. In which topology different
networks are connected
with a single communication channel?
A)
Bus Topology
B) Mesh Topology
C) Tree Topology
D) Star Topology
Answer is C) In Tree Topology
different computer networks are connected with a single channel.
121. Which device is called dumb in computer
network?
A)
Switch
B) Router
C) Bridge
D) Hub Answer is D) Hub is called Dumb Device.
122. Which device is installed
at the entrance of a LAN?
A)
Firewall
B) Repeater
C) Switch
D) Router Answer is A) Firewall is installed at the
entrance of a LAN.
123. Which device is used to connect two different part
of a LAN?
A)
Repeater
B) Switch
C) Bridge
D) Router Answer is C) Bridge is used to connect
two different part of a LAN.
124. Which device is used to join LAN to WAN?
A)
Router
B) Switch
C) Hub
D) Modem Answer is A) Router is used to join LAN
to WAN.
125. Which device is called an intelligent device?
A)
Hub
B) Modem
C) Router
D) Switch Answer is D) Switch is called an
intelligent device.
126. What is called a Program which
steal your computer
information?
A)
Trojan Horse
B) Worm Virus
C) Program Virus
D) Spyware Answer is D) Spyware steal your
information.
127. A virus which disguise
as a genuine software?
A)
Malware
B) Worm Virus
C) Trojan Horse
D) Boot Virus Answer is C) Trojan Horse disguise as
a genuine software.
128. What is the symptom of computer virus in a
computer?
A)
Computer Restart.
B) All of these.
C) Hard Disc gets out of memeory.
D) Computer runs slower than
normal speed. Answer is B) All of
these.
129. What is called when someone gets email that you have won a prize, please give your bank details?
A)
Black Mail
B) Spam
C) Thief
D) Phishing Answer is D) Phishing
130. What is called getting unwanted flood of emails
in your email inbox?
A)
Spam emails
B) Flood of emails
C) Unwanted emails
D) Malware emails Answer is A) Spam emails.
No comments:
Post a Comment