Computer application exam questions and answers
ভূমিকা
আসসালামু আলাইকুম। প্রিয় পাঠক জমজম আইটির পক্ষ থেকে আপনাকে স্বাগতম। আপনি অনেক
খোঁজাখুজির পর নিশ্চয়ই Computer application exam questions and answers জানার
জন্যই আমাদের এই সাইটটিতে এসেছেন।
হ্যাঁ আজকে আমি সঠিকভাবে Computer application exam questions and answers করতে হয় তা নিয়ে আলোচনা করব। এই লেখার মূল বিষয়বস্তু সম্পর্কে জানতে
পুরো আর্টিকেলটি পড়ে ফেলুন।
What is MCQ on Computer Application Multiple Choice Questions
MCQ (Multiple Choice Question) is a type of assessment question that has
multiple answer choices, but only one correct answer. MCQs are commonly used
in various fields, including education, psychology, and business. In computer
applications, MCQs are often used to assess students' understanding of
computer concepts, software applications, and programming languages.
Computer application exam questions and answers
Here is 100+ MCQ on Computer Application Multiple Choice Questions and
answers
1. What is the purpose of a word processor?
(a) To create and edit documents
(b) To manage spreadsheets
(c) To create presentations
(d) To browse the internet
2. What is the most common file format for word documents?
(a) .docx
(b) .xlsx
(c) .pptx
(d) .html
3. What is a spreadsheet program used for?
(a) To create and edit documents
(b) To manage spreadsheets
(c) To create presentations
(d) To browse the internet
4. What is the most common file format for spreadsheets?
(a) .docx
(b) .xlsx
(c) .pptx
(d) .html
5. What is a presentation program used for?
(a) To create and edit documents
(b) To manage spreadsheets
(c) To create presentations
(d) To browse the internet
6. What is the most common file format for presentations?
(a) .docx
(b) .xlsx
(c) .pptx
(d) .html
7. What is a web browser used for?
(a) To create and edit documents
(b) To manage spreadsheets
(c) To create presentations
(d) To browse the internet
8. What is the most common web browser?
(a) Google Chrome
(b) Mozilla Firefox
(c) Microsoft Edge
(d) Safari
9. What is an operating system?
(a) A software program that allows you to run other programs
(b) A type of computer hardware
(c) A type of software application
(d) A type of computer network
10. What is the most common operating system for personal computers?
(a) Windows
(b) macOS
(c) Linux
(d) Chrome OS
True/False Questions
A computer application is a program that performs a specific task.
(True)
All computer applications are written in the same programming language.
(False)
A word processor can be used to create and edit documents.
(True)
A spreadsheet program can be used to manage spreadsheets.
(True)
A presentation program can be used to create presentations.
(True)
A web browser can be used to browse the internet.
(True)
An operating system is a software program that allows you to run other
programs.
(True)
The most common operating system for personal computers is Windows.
(True)
A computer application can be used to perform a variety of tasks.
(True)
A computer application can be installed on a computer or accessed online.
(True)
Short Answer Questions
What are the three main types of computer applications?
(a) Productivity applications, multimedia applications, and web applications
What is the purpose of a file format?
(a) To standardize the way data is stored in a file
What is the difference between a file and a program?
(a) A file is a container for data, while a program is a set of instructions
that tells the computer what to do with data.
What is a user interface?
(a) The way that a user interacts with a computer program
What is a network?
(a) A group of interconnected computers that can share resources
I hope these questions and answers are helpful. Please let me know if you
have any other questions.
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
IT questions and answers
Which of the following is the primary storage device of a computer?
A. Hard disk
B. RAM
C. ROM
D. CD-ROM
Answer: B
Which of the following is an example of an output device?
A. Monitor
B. Keyboard
C. Mouse
D. Printer
Answer: A
Which of the following is an example of an input device?
A. Monitor
B. Keyboard
C. Mouse
D. Printer
Answer: B
Which of the following is an operating system?
A. Microsoft Windows
B. Linux
C. macOS
D. All of the above
Answer: D
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
Which of the following is a spreadsheet software?
A. Microsoft Excel
B. Google Sheets
C. LibreOffice Calc
D. All of the above
Answer: D
Which of the following is a presentation software?
A. Microsoft PowerPoint
B. Google Slides
C. LibreOffice Impress
D. All of the above
Answer: D
Which of the following is a database software?
A. Microsoft Access
B. MySQL
C. Oracle
D. All of the above
Answer: D
Which of the following is a web browser?
A. Google Chrome
B. Mozilla Firefox
C. Microsoft Edge
D. All of the above
Answer: D
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
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
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
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
What is the full form of OS?
A. Operating System
B. Operating Scheme
C. Operating Structure
D. Operating Solution
Answer: A
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
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
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
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
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
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
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
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
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
What is the difference between a denial-of-service attack and a distributed
denial-of-service attack?
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
Computer application exam questions and answers
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
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
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
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
Which of the following is a programming language?
A. Java
B. Python
C. C++
D. All of the above
Answer: D
Which of the following is a scripting language?
A. JavaScript
B. PHP
C. Ruby
D. All of the above
Answer: D
Which of the following is a markup language?
A. HTML
B. CSS
C. XML
D. All of the above
Answer: D
Which of the following is a database management system?
A. MySQL
B. Oracle
C. Microsoft SQL Server
D. All of the above
Answer: D
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
Which of the following is a social networking site?
A. Facebook
B. Twitter
C. LinkedIn
D. All of the above
Answer: D
Which of the following is a search engine?
A. Google
B. Bing
C. Yahoo!
D. All of the above
Answer: D
Which of the following is a video streaming service?
A. Netflix
B. Hulu
C. Amazon Prime Video
D. All of the above
Answer: D
Which of the following is a music streaming service?
A. Spotify
B. Apple Music
C. Amazon Music
D. All of the above
Answer: D
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
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
What is the most common type of network?
A. LAN
B. WAN
C. MAN
D. PAN
Answer: A
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
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
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
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.
D. All of the above.
Answer: A
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
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
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
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
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
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.
D. All of the above.
Answer: A
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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.
D. All of the above.
Answer: A
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
What is the difference between a cloud computing service and a server less
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 server less
computing is a hardware device.
C. A cloud computing service is a physical object, while a server less
computing is a logical object.
D. All of the above.
Answer: A
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
Basic computer mcqs with answers
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
What is the difference between a cloud computing service and a managed
service?
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
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
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
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
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.
Answer: A
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
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
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
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
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.
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
what is a database management system
A database management system (DBMS) is a software application that interacts
with users, applications, and the database itself to capture and analyze data.
A DBMS is designed to manage the storage, retrieval, and security of data.
Storage: A DBMS stores data in a structured format, making it easy to
retrieve and analyze.
Retrieval: A DBMS provides users with a variety of ways to retrieve
data, including by using queries, forms, and reports.
Security: A DBMS protects data from unauthorized access, modification,
or deletion.
DBMSs are used in a wide variety of applications, including:
E-commerce: DBMSs are used to store customer information, product
information, and order details.
Banking: DBMSs are used to store customer information, account
information, and transaction history.
Healthcare: DBMSs are used to store patient information, medical
records, and prescription history.
Manufacturing: DBMSs are used to store inventory information,
production schedules, and quality control data.
Some of the most popular DBMSs include:
MySQL: MySQL is an open-source DBMS that is popular for its ease of use
and affordability.
Oracle Database: Oracle Database is a commercial DBMS that is known for its
scalability and performance.
Microsoft SQL Server: Microsoft SQL Server is a commercial DBMS that is
popular for its compatibility with Microsoft Windows operating systems.
PostgreSQL: PostgreSQL is an open-source DBMS that is known for its
feature-richness and extensibility.
The choice of DBMS depends on a number of factors, including the size and
complexity of the database, the required performance, and the budget.
Here are some of the benefits of using a DBMS:
Improved data organization: A DBMS organizes data in a structured
format, making it easy to find and use.
Increased data security: A DBMS protects data from reauthorized access,
modification, or deletion.
Enhanced data integrity: A DBMS ensures that data is accurate and
consistent.
Improved data availability: A DBMS makes data available to users when
they need it.
Reduced data redundancy: A DBMS can eliminate redundant data, which can
save storage space.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
উপসংহার:
প্রিয় পাঠক আজ Computer application exam questions and answers নিয়ে আলোচনা করলাম। আগামীতে অন্য কোন টপিক নিয়ে হাজির হবো।
জমজম আইটিরনীতিমালা মেনে কমেন্ট করুন। প্রতিটি কমেন্ট রিভিউ করা হয়।
comment url