McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Commerce (B Com) .
| 151. |
In.............. models data are conceived in the form of table |
| A. | hierarchical database |
| B. | network database |
| C. | relational database |
| D. | none of these |
| Answer» C. relational database | |
| 152. |
An information system that directly support both the operational and managerial applications of end users |
| A. | eucs |
| B. | eis |
| C. | es |
| D. | dss |
| Answer» A. eucs | |
| 153. |
EUCS stands for............. |
| A. | executive uniform communication system |
| B. | end user computing system |
| C. | end user communication system |
| D. | executive usage computing system |
| Answer» B. end user computing system | |
| 154. |
An information system that provides strategic information tailored to the needs of top management. |
| A. | executive information system |
| B. | expert system |
| C. | decision support system |
| D. | business information system |
| Answer» A. executive information system | |
| 155. |
An executive information system with additional capabilities including data analysis, decision support, electronic mail, and personal productivity tools |
| A. | executive support system |
| B. | expert system |
| C. | decision support system |
| D. | management information system |
| Answer» A. executive support system | |
| 156. |
A computer based information system that uses its knowledge about specific complex application area to act as an expert consultant to users. |
| A. | executive support system |
| B. | expert system |
| C. | decision support system |
| D. | management information system |
| Answer» B. expert system | |
| 157. |
A set of programmes that uses data from master production schedule, inventory files and bill of materials to help and manage production and inventory |
| A. | material requirements planning |
| B. | manufacturing resource planning |
| C. | computer aided manufacturing |
| D. | pareto analysis |
| Answer» A. material requirements planning | |
| 158. |
The software that extends a production information system to other functional areas like finance, marketing, HR etc. |
| A. | material requirements planning |
| B. | manufacturing resource planning |
| C. | business information system |
| D. | management information system |
| Answer» B. manufacturing resource planning | |
| 159. |
An information system that process data arising from occurrence of business transactions |
| A. | business information system |
| B. | transaction processing system |
| C. | transaction support system |
| D. | business support system |
| Answer» B. transaction processing system | |
| 160. |
A database that stores and manages objects |
| A. | oodb |
| B. | olap |
| C. | oltp |
| D. | oss |
| Answer» A. oodb | |
| 161. |
In Ms Excel, Which function calculates the largest value in a set of numbers? |
| A. | average |
| B. | count |
| C. | minimum |
| D. | maximum |
| Answer» D. maximum | |
| 162. |
In Excel, What do you use to create a chart? |
| A. | pie wizard |
| B. | excel wizard |
| C. | data wizard |
| D. | chart wizard |
| Answer» D. chart wizard | |
| 163. |
What displays the content of the active cell? |
| A. | name box |
| B. | row headings |
| C. | formula bar |
| D. | task pane |
| Answer» C. formula bar | |
| 164. |
By default, your documents print in------------mode. |
| A. | landscape |
| B. | portrait |
| C. | page setup |
| D. | print view |
| Answer» B. portrait | |
| 165. |
A table in a relational database is known as |
| A. | field |
| B. | record |
| C. | entity |
| D. | relation |
| Answer» D. relation | |
| 166. |
Which of the following is not an example of word processor |
| A. | wordstar |
| B. | soft word |
| C. | ms word |
| D. | ms office |
| Answer» D. ms office | |
| 167. |
............ is the process of manipulation text using computer |
| A. | powerpoint |
| B. | access |
| C. | word processing |
| D. | animation |
| Answer» C. word processing | |
| 168. |
............. is a facility in MS Word to create multiple letters and mails |
| A. | form letters |
| B. | mail merge |
| C. | dsd |
| D. | goal seek |
| Answer» B. mail merge | |
| 169. |
............... is simply speaking a spread sheet application. |
| A. | ms excel |
| B. | qpro |
| C. | lotus 123 |
| D. | all of these |
| Answer» D. all of these | |
| 170. |
Spread sheet type document is also known as.......... |
| A. | draft document |
| B. | data source document |
| C. | work book |
| D. | tuples |
| Answer» C. work book | |
| 171. |
In Excel each work book will consists of............. work sheets by default |
| A. | 5 |
| B. | 10 |
| C. | 2 |
| D. | 3 |
| Answer» D. 3 | |
| 172. |
Which of the following is/are components of DBMS |
| A. | dml |
| B. | ddl |
| C. | data dictionary |
| D. | all of these |
| Answer» D. all of these | |
| 173. |
In DBMS ... is a field or combination of fields that uniquely identify each record in a table. |
| A. | referential integrity |
| B. | primary key |
| C. | relation |
| D. | tuple |
| Answer» B. primary key | |
| 174. |
A primary key which is appeared in related tables is known as.............of related or secondary table |
| A. | super key |
| B. | candidate key |
| C. | foreign key |
| D. | alternate key |
| Answer» C. foreign key | |
| 175. |
In DBMS ... ensures the validity of the relationship between two table remain intact. |
| A. | referential integrity |
| B. | primary key |
| C. | relation |
| D. | tuple |
| Answer» A. referential integrity | |
| 176. |
MS Access is a ............ application |
| A. | spreadsheet |
| B. | word |
| C. | slide presentation |
| D. | dbms |
| Answer» D. dbms | |
| 177. |
Which of the following is an object in MS Access |
| A. | query |
| B. | forms |
| C. | report |
| D. | any of the above |
| Answer» D. any of the above | |
| 178. |
.............. is a series of commands that is recorded so it can be played back, or executed later. |
| A. | query |
| B. | goal seek |
| C. | macro |
| D. | scenario manager |
| Answer» C. macro | |
| 179. |
A ............. is a predetermined formula in Excel. |
| A. | module |
| B. | function |
| C. | macro |
| D. | none of these |
| Answer» B. function | |
| 180. |
Which of the following is “What-if-analysis in excel? |
| A. | goal seek |
| B. | scenario manager |
| C. | both of these |
| D. | none of these |
| Answer» C. both of these | |
| 181. |
Ms Excel is an application to prepare............ |
| A. | chart |
| B. | spreadsheets |
| C. | graph |
| D. | slides |
| Answer» B. spreadsheets | |
| 182. |
MS Power point is an application to prepare............... |
| A. | chart |
| B. | spreadsheets |
| C. | graph |
| D. | slides |
| Answer» D. slides | |
| 183. |
Ms Offdice is a................ |
| A. | shareware |
| B. | firmware |
| C. | open software |
| D. | an application suit |
| Answer» D. an application suit | |
| 184. |
Which of the following is a financial function in excel? |
| A. | correl |
| B. | max |
| C. | d- count |
| D. | npv |
| Answer» D. npv | |
| 185. |
Which of the following is a statistical function in excel? |
| A. | st dev |
| B. | correl |
| C. | covar |
| D. | any of the above |
| Answer» D. any of the above | |
| 186. |
In Excel, More than one data can be entered in a single cell by using............. facility |
| A. | solver |
| B. | goal seek |
| C. | consolidation |
| D. | scenario |
| Answer» D. scenario | |
| 187. |
Questions can be raised in Ms Access by using............ |
| A. | queries |
| B. | form |
| C. | report |
| D. | find |
| Answer» A. queries | |
| 188. |
Data storage in Ms Access is as............. |
| A. | table |
| B. | diagram |
| C. | chart |
| D. | commands |
| Answer» A. table | |
| 189. |
In MS Access rows are technically called.......... |
| A. | record |
| B. | attributes |
| C. | tuples |
| D. | field |
| Answer» C. tuples | |
| 190. |
In MS Access columns are technically called.......... |
| A. | record |
| B. | attributes |
| C. | tuples |
| D. | field |
| Answer» B. attributes | |
| 191. |
In Ms Access, actions can be automated by using........... |
| A. | arguments |
| B. | macro |
| C. | query |
| D. | all of these |
| Answer» B. macro | |
| 192. |
In MIS, SDLC stands for............ |
| A. | software development labour cost |
| B. | software development life cycle |
| C. | system development labour cost |
| D. | system development life cycle |
| Answer» D. system development life cycle | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.