Shree Dhanvantary Pharmacy College, Kim

MCQ Bank

Department: B.Pharm
nd
Year/Semester: 2 semester
Name of Subject: Computer applications in pharmacy
Code of Subject: BP205T
Name Subject In charge: Mr. Anurag Dubey

1.Which of the following is the main function of the CPU?

A. Storing data
B. Executing instructions
C. Input and output
D. Networking
2.Which of the following is the primary storage device of a computer?

A. Hard disk
B. RAM
C. ROM
D. CD-ROM
Answer: B
3.Which of the following is an example of an output device?

A. Monitor
B. Keyboard
C. Mouse
D. Printer
Answer: A
4.Which of the following is an example of an input device?
A.Monitor
B.Keyboard
 C.Mouse
D.Printer
Answer: B
5.Which of the following is an operating system?

A. Microsoft Windows
B. Linux
C. macOS
D. All of the above
Answer: D

6.Which of the following is a word processing software?

A. Microsoft Word
B. Google Docs
C. LibreOffice Writer
D. All of the above
Answer: D
7. Which of the following is a spreadsheet software?

A. Microsoft Excel
B. Google Sheets
C. LibreOffice Calc
D. All of the above
Answer: D
8. Which of the following is a presentation software?

A. Microsoft PowerPoint o

B. Google Slides

C. LibreOffice Impress

D. All of the above

Answer: D
9. Which of the following is a database software?
 A. Microsoft Access
B. MySQ
C. Oracle
D. All of the above
Answer: D
10.Which of the following is a web browser?

A. Google Chrome
B. Mozilla Firefox
C. Microsoft Edge
D. All of the above
Answer: D
11.What is the full form of RAM?

A. Random Access Memory

B. Read Only Memory
C. Real Time Memory
D. Reduced Access Memory
Answer: A
12.What is the full form of ROM?

A. Read Only Memory

B. Random Access Memory
C. Real Time Memory
D. Reduced Access Memory
Answer: A

13.What is the full form of CPU?

A.Central Processing Unit

B.Central Processing Utility

C. Central Processing Unit

D.Central Processing Unit

Answer: A
14.What is the full form of GUI?

A. Graphical User Interface

B. Graphical Utility Interface
C. Graphical User Inference
D. Graphical User Insertion
Answer: A
15.What is the full form of OS?

A. Operating System
B. Operating Scheme
C. Operating Structure
D. Operating Solution
Answer: A
16.What is the full form of LAN?

A. Local Area Network

B. Local Access Network
C. Local Agreement Network
D. Local Adaptation Network
Answer: A
17.What is the full form of WAN?

A. Wide Area Network

B. Wide Access Network
C. Wide Agreement Network
D. Wide Adaptation Network
Answer: A
18.What is the full form of WWW?
A. World Wide Web
B. World Wide Worksheet
C. World Wide Wire
D. World Wide Word
Answer: A
19.What is the full form of HTTP?
 A. HyperText Transfer Protocol
B. HyperText Transfer Procedure
C. HyperText Transfer Process
D. HyperText Transfer Policy
Answer: A
20.What is the full form of HTTPS?

A. HyperText Transfer Protocol Secure

B. HyperText Transfer Procedure Secure
C. HyperText Transfer Process Secure
D. HyperText Transfer Policy Secure
Answer: A

21.What is the function of the BIOS?

A. It boots the computer.

B. It manages the hardware.

C. It provides a user interface.

D. All of the above.

Answer: D
22.Which of the following is a programming language?

A. Java
B. Python
C. C++
D. All of the above
Answer: D
23.Which of the following is a scripting language?

A. JavaScript
B. PHP
C. Ruby
D. All of the above
Answer: D
24.Which of the following is a markup language?

A. HTML
B. CSS
C. XML
D. All of the above
Answer: D
25.Which of the following is a database management system?

A. MySQL

B. Oracle

C. Microsoft SQL Server

D. All of Above

Answer: D
26.Which of the following is a cloud computing service?

A. Amazon Web Services

B. Microsoft Azure
C. Google Cloud Platform
D. All of the above
Answer: D
27.Which of the following is a social networking site?

A. Facebook
B. Twitter
C. LinkedIn
D. All of the above
Answer: D
28.Which of the following is a search engine?

A. Google
B. Bing
C. Yahoo!
D. All of the above
Answer: D
29.Which of the following is a video streaming service?

A. Netflix
B. Hulu
C. Amazon Prime Video
D. All of the above
Answer: D
30.Which of the following is a music streaming service?

A. Spotify
B. Apple Music
C. Amazon Music
D. All of the above
Answer: D
31.Which of the following is a cloud gaming service?

A. Google Stadia
B. NVIDIA GeForce Now
C. Amazon Luna
D. All of the above
Answer: D
32.Which of the following is a virtual reality headset?

A. Oculus Quest 2
B. HTC Vive
C. PlayStation VR
D. All of the above
Answer: D
33.What is the most common type of network?

A. LAN
B. WAN
C. MAN
D. PAN
Answer: A
34.What is the difference between an email and a chat?
 A. An email is a message that is sent over the internet, while a
chat is a real-time conversation that is held over the internet.
B. An email is a software program, while a chat is a hardware
device.

C. An email is a physical object, while a chat is a logical object.

D. All of the above.
Answer: A

Answer: A
35.What is a database?

A. A database is a collection of data that is organized so that it

can be easily accessed, managed, and updated.
B. A database is a software program that manages data.

C. A database is a physical object that stores data.

D. All of the above.
Answer: A
36.What is a relational database?

A. A relational database is a database that stores data in tables.

B. A relational database is a database that stores data in graphs.
C. A relational database is a database that stores data in trees.
D. All of the above.
Answer: A
37.What is a table in a relational database?
A. A table in a relational database is a collection of rows and columns.
B. A table in a relational database is a collection of records and fields.
C. A table in a relational database is a collection of objects and properties.
D. All of the above.
Answer: A
38.What is a row in a relational database?

A. A row in a relational database is a single record.

B. A row in a relational database is a single field.
C. A row in a relational database is a single object.
D. All of the above.
Answer: A
39.What is a column in a relational database?

A. A column in a relational database is a single field.

B. A column in a relational database is a single record.
C. A column in a relational database is a single object.
D. All of the above.
Answer: A
40.What is a primary key in a relational database?

A. A primary key in a relational database is a unique field that

identifies each record.
B. A primary key in a relational database is a field that cannot
be null.
C. A primary key in a relational database is a field that cannot
be duplicated.
D. All of the above.
Answer: D
41.What is a foreign key in a relational database?
A.A foreign key in a relational database is a field that references a
primary key in another table.
B.A foreign key in a relational database is a field that cannot be
null.
C. A foreign key in a relational database is a field that cannot
be duplicated.
D. All of the above.
Answer: A
42.What is a database management system (DBMS)?

A. A DBMS is a software program that manages data in a database.

B. A DBMS is a hardware device that manages data in a database.
C. A DBMS is a physical object that stores data in a database.
D. All of the above.
Answer: A
43.What are the three main types of DBMSs?

A. Relational DBMSs, hierarchical DBMSs, and network DBMSs.

B. Relational DBMSs, object-oriented DBMSs, and NoSQL DBMSs.
C. Hierarchical DBMSs, network DBMSs, and object-oriented DBMSs.
D. NoSQL DBMSs, object-oriented DBMSs, and relational DBMSs.
Answer: B
44.What is a NoSQL database?

A. A NoSQL database is a database that does not use the relational model.
B. A NoSQL database is a database that is not managed by a DBMS.
C. A NoSQL database is a database that is not stored on a physical device.
D. All of the above.
Answer: A
45.What is a query language?

A. A query language is a language that is used to interact with a database.

B. A query language is a language that is used to create a database.

C. A query language is a language that is used to delete a database.
D. All of the above.
Answer: A
46.What is SQL?

A. SQL is a query language that is used to interact with relational databases.

B. SQL is a query language that is used to create relational databases.
C. SQL is a query language that is used to delete relational databases. D. All of
the above.
Answer: A
47.What are the three main types of SQL queries?
A. SELECT, INSERT, and UPDATE.
B. SELECT, DELETE, and DROP.
C. INSERT, UPDATE, and DELETE.
D. All of the above.
Answer: A
48.What is a SELECT query?

A. A SELECT query is used to select data from a database. B. A

SELECT query is used to insert data into a database.
C. A SELECT query is used to update data in a database.
D. A SELECT query is used to delete data from a database.
Answer: A
49.What is an INSERT query?

A. An INSERT query is used to insert data into a database.

B. An INSERT query is used to select data from a database. C. An
INSERT query is used to update data in a database.
D. An INSERT query is used to delete data from a database.
Answer: A
50.What is an UPDATE query?

A. An UPDATE query is used to update data in a database.

B. An UPDATE query is used to select data from a database. C. An
UPDATE query is used to insert data into a database. D. An
UPDATE query is used to delete data from a database.
Answer: A
51.What is a DELETE query?

A. A DELETE query is used to delete data from a database. B. A

DELETE query is used to select data from a database.
C. A DELETE query is used to insert data into a database.
D. A DELETE query is used to update data in a database.
Answer: A

QUESTION ANSWER
NO.

1 B

2 B

3 A

4 B

5 D

6 D

7 D

8 D

9 D

10 D

11 A
12 A

13 A

14 A

15 A

16 A

17 A

18 A

19 A

20 A

21 D

22 D

23 D

24 D

25 D

26 D

27 D

28 D

29 D

30 D

31 D

32 D

33 A

34 A

35 A
36 A

37 A

38 A

39 A

40 D

41 A

42 A

43 B

44 A

45 A

46 A

47 A

48 A

49 A

50 A

51 A