Class Notes
By
ABHISHEK MAJEE
Date: 08/01/2024
Computer Application
100 MCQ on Computer Application
1. Which of the following is the main function of the CPU?
○ A. Storing data
○ B. Executing instructions
○ C. Input and output
○ D. Networking
○ Answer: B
2. Which of the following is the primary storage device of a computer?
○ A. Hard disk
2
○ 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
○ 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. MySQL
○ C. Oracle
○ D. All of the above
○ Answer: D
10. Which of the following is a web browser?
○ A. Google Chrome
3
○ 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
4
○ 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 difference between RAM and ROM?
○ A. RAM is volatile memory, while ROM is non-volatile memory.
○ B. RAM is permanent memory, while ROM is temporary memory.
○ C. RAM is used to store data, while ROM is used to store instructions.
○ D. RAM is used to store programs, while ROM is used to store data.
○ Answer: A
22. 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
23. What is the difference between a virus and a worm?
○ A. A virus needs a host program to run, while a worm can run independently.
○ B. A virus can only spread through removable media, while a worm can
spread over a network.
○ C. A virus is a self-replicating program, while a worm is not.
○ D. All of the above.
○ Answer: C
24. What is the difference between a Trojan horse and a backdoor?
○ A. A Trojan horse is a malicious program that masquerades as a legitimate
program, while a backdoor is a hidden way into a computer system.
○ B. A Trojan horse can only steal data, while a backdoor can also be used to
control the computer system.
○ C. A Trojan horse is installed by the user, while a backdoor is installed by the
attacker.
○ D. All of the above.
○ Answer: A
25. What is the difference between a denial-of-service attack and a distributed denial-of-
service attack?
5
○ A. A denial-of-service attack is an attack that makes a website or service
unavailable, while a distributed denial-of-service attack is an attack that uses
multiple computers to make a website or service unavailable.
○ B. A denial-of-service attack is an attack that is launched from a single
computer, while a distributed denial-of-service attack is an attack that is
launched from multiple computers.
○ C. A denial-of-service attack is an attack that is launched by a hacker, while a
distributed denial-of-service attack is an attack that is launched by a botnet.
○ D. All of the above.
○ Answer: A
26. What is the difference between a firewall and an antivirus software?
○ A. A firewall protects a computer from unauthorized access, while an antivirus
software protects a computer from malware.
○ B. A firewall is a hardware device, while an antivirus software is a software
program.
○ C. A firewall is used to filter network traffic, while an antivirus software is used
to scan files for malware.
○ D. All of the above.
○ Answer: A
27. What is the difference between a web browser and an email client?
○ A. A web browser is used to access websites, while an email client is used to
send and receive emails.
○ B. A web browser is a software program, while an email client is a hardware
device.
○ C. A web browser is used to view web pages, while an email client is used to
compose and read emails.
○ D. All of the above.
○ Answer: A
28. What is the difference between a file and a folder?
○ A. A file is a unit of data, while a folder is a container for files.
○ B. A file is a physical object, while a folder is a logical object.
○ C. A file can only be opened by one program, while a folder can be opened by
multiple programs.
○ D. All of the above.
○ Answer: A
29. What is the difference between a hard disk drive and a solid-state drive?
○ A. A hard disk drive uses spinning disks to store data, while a solid-state drive
uses flash memory to store data.
○ B. A hard disk drive is slower than a solid-state drive.
○ C. A hard disk drive is more durable than a solid-state drive.
○ D. All of the above.
○ Answer: A
30. Which of the following is a programming language?
○ A. Java
○ B. Python
○ C. C++
○ D. All of the above
○ Answer: D
6
31. Which of the following is a scripting language?
○ A. JavaScript
○ B. PHP
○ C. Ruby
○ D. All of the above
○ Answer: D
32. Which of the following is a markup language?
○ A. HTML
○ B. CSS
○ C. XML
○ D. All of the above
○ Answer: D
33. Which of the following is a database management system?
○ A. MySQL
○ B. Oracle
○ C. Microsoft SQL Server
○ D. All of the above
○ Answer: D
34. 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
35. Which of the following is a social networking site?
○ A. Facebook
○ B. Twitter
○ C. LinkedIn
○ D. All of the above
○ Answer: D
36. Which of the following is a search engine?
○ A. Google
○ B. Bing
○ C. Yahoo!
○ D. All of the above
○ Answer: D
37. Which of the following is a video streaming service?
○ A. Netflix
○ B. Hulu
○ C. Amazon Prime Video
○ D. All of the above
○ Answer: D
38. Which of the following is a music streaming service?
○ A. Spotify
○ B. Apple Music
○ C. Amazon Music
○ D. All of the above
○ Answer: D
7
39. 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
40. 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
41. What is the most common type of network?
○ A. LAN
○ B. WAN
○ C. MAN
○ D. PAN
○ Answer: A
42. What is the difference between a LAN and a WAN?
○ A. A LAN is a local area network, while a WAN is a wide area network.
○ B. A LAN is a private network, while a WAN is a public network.
○ C. A LAN is a network that covers a small area, while a WAN is a network that
covers a large area.
○ D. All of the above.
○ Answer: D
43. What is the difference between a MAN and a WAN?
○ A. A MAN is a metropolitan area network, while a WAN is a wide area
network.
○ B. A MAN is a network that covers a city, while a WAN is a network that
covers a country or continent.
○ C. A MAN is a private network, while a WAN is a public network.
○ D. All of the above.
○ Answer: B
44. What is the difference between a client and a server?
○ A. A client is a computer that requests resources from a server, while a server
is a computer that provides resources to clients.
○ B. A client is a software program that requests resources from a server, while
a server is a hardware device that provides resources to clients.
○ C. A client is a physical object, while a server is a logical object.
○ D. All of the above.
○ Answer: A
45. What is the difference between a web server and an application server?
○ A. A web server is a server that delivers web pages, while an application
server is a server that runs applications.
○ B. A web server is a hardware device, while an application server is a software
program.
○ C. A web server is a physical object, while an application server is a logical
object.
8
○ D. All of the above.
○ Answer: A
46. What is the difference between a proxy server and a firewall?
○ A. A proxy server is a server that acts as an intermediary between a client and
a server, while a firewall is a device that protects a network from unauthorized
access.
○ B. A proxy server is a hardware device, while a firewall is a software program.
○ C. A proxy server is a physical object, while a firewall is a logical object.
○ D. All of the above.
○ Answer: A
47. What is the difference between a router and a switch?
○ A. A router is a device that connects networks, while a switch is a device that
connects devices on the same network.
○ B. A router is a hardware device, while a switch is a software program.
○ C. A router is a physical object, while a switch is a logical object.
○ D. All of the above.
○ Answer: A
48. What is the difference between a hub and a switch?
○ A. A hub is a device that connects devices on the same network, while a
switch is a device that connects devices on the same network and forwards
traffic to the correct device.
○ B. A hub is a hardware device, while a switch is a software program.
○ C. A hub is a physical object, while a switch is a logical object.
○ D. All of the above.
○ Answer: A
49. What is the difference between a modem and a router?
○ A. A modem is a device that converts analog signals to digital signals and vice
versa, while a router is a device that connects networks.
○ B. A modem is a hardware device, while a router is a software program.
○ C. A modem is a physical object, while a router is a logical object.
○ D. All of the above.
○ Answer: A
50. What is the difference between a Wi-Fi and a Bluetooth?
○ A. Wi-Fi is a wireless network that uses radio waves to transmit data, while
Bluetooth is a wireless network that uses radio waves to transmit data over a
short distance.
○ B. Wi-Fi is a faster network than Bluetooth.
○ C. Wi-Fi is a more secure network than Bluetooth.
○ D. All of the above.
○ Answer: A
51. What is the difference between a web browser and a search engine?
○ A. A web browser is a software program that allows users to view web pages,
while a search engine is a website that allows users to search for information
on the web.
○ B. A web browser is a hardware device, while a search engine is a software
program.
○ C. A web browser is a physical object, while a search engine is a logical
object.
9
○ D. All of the above.
○ Answer: A
52. What is the difference between a website and a web page?
○ A. A website is a collection of web pages, while a web page is a single
document that is displayed on the web.
○ B. A website is a software program, while a web page is a hardware device.
○ C. A website is a physical object, while a web page is a logical object.
○ D. All of the above.
○ Answer: A
53. What is the difference between a URL and a web address?
○ A. A URL is a Uniform Resource Locator, while a web address is a way to
identify a website on the internet.
○ B. A URL is a software program, while a web address is a hardware device.
○ C. A URL is a physical object, while a web address is a logical object.
○ D. All of the above.
○ Answer: A
54. What is the difference between a domain name and a top-level domain?
○ A. A domain name is the address of a website on the internet, while a top-level
domain is the last part of a domain name.
○ B. A domain name is a software program, while a top-level domain is a
hardware device.
○ C. A domain name is a physical object, while a top-level domain is a logical
object.
○ D. All of the above.
○ Answer: A
55. What is the difference between a static website and a dynamic website?
○ A. A static website is a website that does not change, while a dynamic website
is a website that changes depending on the user's input.
○ B. A static website is a software program, while a dynamic website is a
hardware device.
○ C. A static website is a physical object, while a dynamic website is a logical
object.
○ D. All of the above.
○ Answer: A
56. What is the difference between a blog and a wiki?
○ A. A blog is a website that is updated regularly with new content, while a wiki
is a website that allows users to collaborate on content.
○ B. A blog is a software program, while a wiki is a hardware device.
○ C. A blog is a physical object, while a wiki is a logical object.
○ D. All of the above.
○ Answer: A
57. 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
10
58. What is the difference between a social network and a social media platform?
○ A. A social network is a website that allows users to connect with each other,
while a social media platform is a website that allows users to share content
with each other.
○ B. A social network is a software program, while a social media platform is a
hardware device.
○ C. A social network is a physical object, while a social media platform is a
logical object.
○ D. All of the above.
○ Answer: A
59. What is the difference between a cloud computing service and a platform as a
service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a platform as a service is a service that
provides access to a platform over the internet.
○ B. A cloud computing service is a software program, while a platform as a
service is a hardware device.
○ C. A cloud computing service is a physical object, while a platform as a service
is a logical object.
○ D. All of the above.
○ Answer: A
60. What is the difference between a cloud computing service and an infrastructure as a
service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while an infrastructure as a service is a service
that provides access to infrastructure over the internet.
○ B. A cloud computing service is a software program, while an infrastructure as
a service is a hardware device.
○ C. A cloud computing service is a physical object, while an infrastructure as a
service is a logical object.
○ D. All of the above.
○ Answer: A
61. What is the difference between a cloud computing service and a disaster recovery as
a service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a disaster recovery as a service is a service
that provides access to disaster recovery solutions over the internet.
○ B. A cloud computing service is a software program, while a disaster recovery
as a service is a hardware device.
○ C. A cloud computing service is a physical object, while a disaster recovery as
a service is a logical object.
○ D. All of the above.
○ Answer: A
62. What is the difference between a cloud computing service and a security as a
service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a security as a service is a service that
provides access to security solutions over the internet.
11
○ B. A cloud computing service is a software program, while a security as a
service is a hardware device.
○ C. A cloud computing service is a physical object, while a security as a service
is a logical object.
○ D. All of the above.
○ Answer: A
63. What is the difference between a cloud computing service and a machine learning as
a service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a machine learning as a service is a service
that provides access to machine learning solutions over the internet.
○ B. A cloud computing service is a software program, while a machine learning
as a service is a hardware device.
○ C. A cloud computing service is a physical object, while a machine learning as
a service is a logical object.
○ D. All of the above.
○ Answer: A
64. What is the difference between a cloud computing service and a blockchain as a
service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a blockchain as a service is a service that
provides access to blockchain solutions over the internet.
○ B. A cloud computing service is a software program, while a blockchain as a
service is a hardware device.
○ C. A cloud computing service is a physical object, while a blockchain as a
service is a logical object.
○ D. All of the above.
○ Answer: A
65. What is the difference between a cloud computing service and a big data as a
service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a big data as a service is a service that
provides access to big data solutions over the internet.
○ B. A cloud computing service is a software program, while a big data as a
service is a hardware device.
○ C. A cloud computing service is a physical object, while a big data as a service
is a logical object.
○ D. All of the above.
○ Answer: A
66. What is the difference between a cloud computing service and a virtual machine as a
service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a virtual machine as a service is a service
that provides access to virtual machines over the internet.
○ B. A cloud computing service is a software program, while a virtual machine as
a service is a hardware device.
○ C. A cloud computing service is a physical object, while a virtual machine as a
service is a logical object.
12
○ D. All of the above.
○ Answer: A
67. What is the difference between a cloud computing service and a container as a
service?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a container as a service is a service that
provides access to containers over the internet.
○ B. A cloud computing service is a software program, while a container as a
service is a hardware device.
○ C. A cloud computing service is a physical object, while a container as a
service is a logical object.
○ D. All of the above.
○ Answer: A
68. What is the difference between a cloud computing service and a serverless
computing?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a serverless computing is a service that
provides access to computing resources without the need to manage servers.
○ B. A cloud computing service is a software program, while a serverless
computing is a hardware device.
○ C. A cloud computing service is a physical object, while a serverless
computing is a logical object.
○ D. All of the above.
○ Answer: A
69. What is the difference between a cloud computing service and a content delivery
network?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a content delivery network is a service that
delivers content over the internet.
○ B. A cloud computing service is a software program, while a content delivery
network is a hardware device.
○ C. A cloud computing service is a physical object, while a content delivery
network is a logical object.
○ D. All of the above.
○ Answer: A
70. What is the difference between a cloud computing service and a web application
firewall?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a web application firewall is a service that
protects web applications from attacks.
○ B. A cloud computing service is a software program, while a web application
firewall is a hardware device.
○ C. A cloud computing service is a physical object, while a web application
firewall is a logical object.
○ D. All of the above.
○ Answer: A
71. What is the difference between a cloud computing service and a managed service?
13
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a managed service is a service that provides
management of computing resources over the internet.
○ B. A cloud computing service is a software program, while a managed service
is a hardware device.
○ C. A cloud computing service is a physical object, while a managed service is
a logical object.
○ D. All of the above.
○ Answer: A
72. What is the difference between a cloud computing service and a hybrid cloud?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a hybrid cloud is a deployment model that
combines public cloud and private cloud resources.
○ B. A cloud computing service is a software program, while a hybrid cloud is a
hardware device.
○ C. A cloud computing service is a physical object, while a hybrid cloud is a
logical object.
○ D. All of the above.
○ Answer: A
73. What is the difference between a cloud computing service and a multi-cloud?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a multi-cloud is a deployment model that
uses multiple cloud providers.
○ B. A cloud computing service is a software program, while a multi-cloud is a
hardware device.
○ C. A cloud computing service is a physical object, while a multi-cloud is a
logical object.
○ D. All of the above.
○ Answer: A
74. What is the difference between a cloud computing service and a private cloud?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a private cloud is a deployment model that
provides computing resources to a single organization.
○ B. A cloud computing service is a software program, while a private cloud is a
hardware device.
○ C. A cloud computing service is a physical object, while a private cloud is a
logical object.
○ D. All of the above.
○ Answer: A
75. What is the difference between a cloud computing service and a community cloud?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a community cloud is a deployment model
that provides computing resources to a specific community of organizations.
○ B. A cloud computing service is a software program, while a community cloud
is a hardware device.
○ C. A cloud computing service is a physical object, while a community cloud is
a logical object.
○ D. All of the above.
14
○ Answer: A
76. What is the difference between a cloud computing service and a mainframe?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a mainframe is a large computer that can
handle a lot of data.
○ B. A cloud computing service is a software program, while a mainframe is a
hardware device.
○ C. A cloud computing service is a physical object, while a mainframe is a
logical object.
○ D. All of the above.
○ Answer: A
77. What is the difference between a cloud computing service and a supercomputer?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while a supercomputer is a very powerful
computer that can handle complex calculations.
○ B. A cloud computing service is a software program, while a supercomputer is
a hardware device.
○ C. A cloud computing service is a physical object, while a supercomputer is a
logical object.
○ D. All of the above.
○ Answer: A
78. What is the difference between a cloud computing service and a grid computing?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while grid computing is a distributed computing
model that uses multiple computers to solve a problem.
○ B. A cloud computing service is a software program, while grid computing is a
hardware device.
○ C. A cloud computing service is a physical object, while grid computing is a
logical object.
○ D. All of the above.
○ Answer: A
79. What is the difference between a cloud computing service and a peer-to-peer
computing?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while peer-to-peer computing is a distributed
computing model that uses computers to share resources with each other.
○ B. A cloud computing service is a software program, while peer-to-peer
computing is a hardware device.
○ C. A cloud computing service is a physical object, while peer-to-peer
computing is a logical object.
○ D. All of the above.
○ Answer: A
80. What is the difference between a cloud computing service and a distributed
computing?
○ A. A cloud computing service is a service that provides access to computing
resources over the internet, while distributed computing is a computing model
that distributes tasks across multiple computers.
15
○ B. A cloud computing service is a software program, while distributed
computing is a hardware device.
○ C. A cloud computing service is a physical object, while distributed computing
is a logical object.
○ D. All of the above.
○ Answer: A
81. 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
82. 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
83. 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
84. 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
85. 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
86. 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
87. 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.
16
○ C. A foreign key in a relational database is a field that cannot be duplicated.
○ D. All of the above.
○ Answer: A
88. 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
89. 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
90. 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
91. 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
92. 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
93. 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
94. 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
95. 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.
17
○ 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
96. 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
97. 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
98. What is a join query?
○ A. A join query is used to combine data from two or more tables.
○ B. A join query is used to select data from a single table.
○ C. A join query is used to insert data into a single table.
○ D. A join query is used to delete data from a single table.
○ Answer: A
99. What is a subquery?
○ A. A subquery is a query that is nested within another query.
○ B. A subquery is a query that is used to select data from a single table.
○ C. A subquery is a query that is used to insert data into a single table.
○ D. A subquery is a query that is used to delete data from a single table.
○ Answer: A
100. What is a stored procedure?
○ A. A stored procedure is a set of SQL statements that are stored in the
database.
○ B. A stored procedure is a set of SQL statements that are executed on the
client machine.
○ C. A stored procedure is a set of SQL statements that are executed on the
server machine.
○ D. All of the above.
○ Answer: A