JAMB UTME - Computer Studies - 2022

In SQL, which command is used to remove a stored function from the database?

Antwortdetails

The command used to remove a stored function from the database in SQL is the "DROP FUNCTION" command.

This command is used to permanently remove a stored function from the database. For example, if you have a stored function named "my_function", you can remove it with the following SQL statement:

DROP FUNCTION my_function;

It is important to note that once you drop a stored function, all references to it in your database will be lost and it cannot be recovered. So, it should be used with caution.

Which process is used by large retailers to study trends?

Antwortdetails

Large retailers use data mining to study trends. Data mining is the process of analyzing large amounts of data and identifying patterns and trends in that data to make informed decisions. This can involve looking at customer behavior, sales data, market trends, and other types of data to gain insights into what products are popular, what customers are looking for, and how the market is changing. The goal of data mining is to help retailers make informed decisions about their business and stay ahead of the competition.

Which program translates programs to a simpler language that the computer can execute.

Antwortdetails

The program that translates programs to a simpler language that the computer can execute is called a compiler. A compiler is a program that takes the source code of a program written in a high-level programming language and translates it into machine code or executable code that the computer can understand and execute. The process of compiling involves several steps, including lexical analysis, syntax analysis, semantic analysis, code optimization, and code generation. When a programmer writes a program in a high-level programming language such as Java or Python, the code is not directly executable by the computer. Instead, the code must be translated into machine code, which is a low-level language that the computer can understand and execute. This is where the compiler comes in. The compiler takes the source code written in the high-level programming language and converts it into machine code that can be executed by the computer. The advantage of using a compiler is that the resulting executable code is usually faster and more efficient than code interpreted by an interpreter, which we will discuss next. Additionally, since the code is already translated into machine code, it can be executed multiple times without the need for further translation, making it faster to execute. Overall, a compiler is a program that translates high-level programming code into machine code that a computer can execute, allowing programmers to write code in a more human-readable language and then have it translated into a language that the computer can understand and execute.

Which of these is not a programming language

Antwortdetails

ios is not a programming language. HTML, Java, and C++ are all programming languages, while ios is an operating system created by Apple Inc. for its mobile devices, such as the iPhone and iPad. Programming languages are used to write computer programs, while operating systems provide a platform for those programs to run on.

The acronym from DATABASE MANAGEMENT SYSTEM is ________________

Antwortdetails

The acronym for DATABASE MANAGEMENT SYSTEM is DBMS, which stands for "Database Management System". A database is an organized collection of data that can be stored, accessed, and managed easily. However, managing large amounts of data can be complicated, which is where a Database Management System comes in. A DBMS is a software system that allows users to create, modify, and manipulate databases. It provides tools to organize and store data efficiently, as well as tools to retrieve and analyze that data. In summary, DBMS is an abbreviation for Database Management System, a software system used to manage and organize data efficiently.

Destruction of files for malicious reasons such as access by fraudulent people is classified as being

Antwortdetails

Destruction of files for malicious reasons, such as access by fraudulent people, is classified as "unauthorized access". This means that someone who is not authorized to access the files has gained access to them, and has intentionally damaged or deleted the files. This type of access is illegal and is a violation of the owner's rights to the information stored in the files.

Microsoft word serves the purpose of ________

Antwortdetails

Microsoft Word serves the purpose of creating documents, which can be anything from simple letters or memos to complex reports, resumes, or even books. It provides a user-friendly platform for users to write, edit, format, and style text, as well as insert images, tables, and other elements to enhance the document's appearance and functionality. Microsoft Word is a popular word processing software used in a wide range of industries, including education, business, and personal use. It allows users to save their documents on their computer or in the cloud, making it easy to access, edit, and share their work from anywhere. Overall, Microsoft Word is a powerful tool for anyone who needs to create or manage written content.

The most basic network is _________

Antwortdetails

The most basic network is a Personal Area Network or PAN. A PAN is a network that connects devices located within a relatively small area, typically within a person's personal space. This can include devices like smartphones, tablets, laptops, and other wearable devices. A PAN can be created using different types of technologies like Bluetooth or Wi-Fi, which allow devices to communicate with each other and share resources such as files, internet connection, and printers, among others. For example, if you have a smartphone and a wireless headset, you can create a PAN by connecting your phone to the headset via Bluetooth. This allows you to make and receive phone calls hands-free. In summary, a PAN is the most basic network as it connects devices within a small personal area and is easy to set up and use. It is the foundation upon which larger and more complex networks like LAN, WAN, and MAN are built.

What does LAN stand for?

Antwortdetails

LAN stands for "Local Area Network". A Local Area Network (LAN) is a computer network that connects devices in a relatively small area, such as a single building or a group of adjacent buildings. A LAN is used for sharing resources, such as printers, files, and internet connections, among the connected devices. Typically, a LAN is set up using Ethernet cables or Wi-Fi connections, and it may include a router, switch or hub to manage the flow of data between the connected devices. A LAN can be used in a variety of settings, including homes, schools, and businesses, where it can provide a more efficient way of sharing resources and communicating between devices. In summary, LAN stands for "Local Area Network", which is a computer network that connects devices in a small area, such as a building or group of buildings, and is used for sharing resources among the connected devices.

Which can be the input and output devices both?

Antwortdetails

There are some devices that can be used as both input and output devices. These are: 1. Touch screen monitor: A touch screen monitor can be used as both an input and output device. It can display information to the user and also accept input from them through touch. 2. Digitizer: A digitizer is another device that can act as both an input and output device. It is used to convert analog signals, such as handwriting or sketches, into digital form. It can also display the digital output on a screen. In contrast, devices like a scanner and speaker are typically designed to perform just one function. A scanner is primarily an input device that converts physical documents into digital images, while a speaker is an output device that produces sound. To summarize, touch screen monitors and digitizers can be used as both input and output devices, while scanners and speakers are typically limited to a single function.

A display listing of program options which users can select is called?

Antwortdetails

A display listing of program options which users can select is called a menu. A menu is a list of options or choices that are presented to the user within a software program or an operating system. The user can then select one of the options from the menu to perform a specific task or access a specific feature. The menu is typically displayed as a list of text items or sometimes as a list of icons.

The device primarily used to provide hardcopy is the?

Antwortdetails

The device primarily used to provide hardcopy is the "printer". A printer is a device that produces a physical or hardcopy of electronic documents or images, typically on paper. It can be connected to a computer or other device through a cable or wireless connection, and it can print text, graphics, or images in black and white or color. Printers come in many different types, including inkjet, laser, and thermal, and they can be used in homes, offices, and other settings. Card readers, computer consoles, and CRTs (cathode ray tubes) are not primarily used to provide hardcopy. A card reader is a device used to read information from a magnetic stripe or chip on a plastic card, such as a credit card. A computer console is the part of a computer system that contains the keyboard, monitor, and other components used to interact with the computer. A CRT is an older type of display technology that was used in older computer monitors and televisions, but has largely been replaced by newer technologies such as LCD and LED displays.

In Microsoft Excel, sheet tabs can be renamed by ______

Antwortdetails

Sheet tabs in Microsoft Excel can be renamed by double-clicking on the sheet tab and entering the new name. To do this, simply click on the sheet tab that you want to rename and wait for it to become active. Then, double-click on the tab, and the name will become editable. Type in the new name you want for the sheet and press the Enter key or click outside the tab to save the changes.

Programming language COBOL works best for use in

Antwortdetails

COBOL, which stands for COmmon Business Oriented Language, is a programming language that is specifically designed for commercial applications. It was developed in the 1950s for business data processing, and it remains a popular choice for applications related to finance, banking, insurance, and other industries that handle large amounts of data. COBOL is known for its straightforward syntax and ability to process large amounts of data efficiently, making it a good choice for commercial applications that need to manage and manipulate financial records, inventory, and other types of business data.

Microsoft PowerPoint is a ________________ application

Antwortdetails

Microsoft PowerPoint is a presentation software application. This means that it is a program used to create visual aids or slideshows that are intended to enhance a live presentation. It allows users to create and design professional-looking slides that can contain text, images, videos, charts, and graphs. These slides can be used to convey information, ideas, or messages in a clear and visually appealing way. PowerPoint is often used in business, education, and other settings where presentations are a common means of communication. It is not a graphing or gaming software, nor is it considered a productivity software in the same sense as a word processor or spreadsheet program.

Typically, an ATM is used for

Antwortdetails

An ATM, or Automated Teller Machine, is typically used for withdrawing cash. It is a machine that allows customers of a financial institution to perform financial transactions, such as withdrawing cash, checking their account balance, or depositing money, without the need to visit a bank branch. ATMs are widely available and can be found in many public places such as shopping centers, airports, and gas stations. They provide customers with convenient access to their money 24 hours a day, seven days a week.

Which of the following is an example of software

Antwortdetails

An example of software is Operating Systems. Software is a set of instructions that tell a computer what to do. It is a type of computer program that is designed to perform specific tasks on a computer or other electronic device. Operating systems are a type of software that controls the basic functions of a computer, such as managing its memory and processing power, and providing a platform for other software to run on. A Joystick, Keyboard, and Mouse are examples of hardware, which are physical devices that are used to input information into a computer or other electronic device.

From where can the name of a user account be changed?

Antwortdetails

The name of a user account can be changed from the Control Panel in most operating systems, including Windows and macOS. In Windows, you can access the Control Panel by clicking on the Start menu and selecting "Control Panel" from the list of options. Once in the Control Panel, you can navigate to the "User Accounts" section and select the user account whose name you want to change. From there, you can click on the "Change your account name" option and enter the new name for the account. Similarly, in macOS, you can access the System Preferences by clicking on the Apple menu and selecting "System Preferences" from the list of options. Once in the System Preferences, you can navigate to the "Users & Groups" section and select the user account whose name you want to change. From there, you can click on the "Full Name" field and enter the new name for the account. In summary, the name of a user account can be changed from the Control Panel or System Preferences of your operating system. The exact steps to do so may vary slightly depending on the operating system, but in general, you can navigate to the "User Accounts" or "Users & Groups" section and select the account whose name you want to change.

___________ is when someone steals another persons identity.

Antwortdetails

The correct answer is "Identity Theft." Identity theft occurs when someone pretends to be another person by stealing their personal information, such as their name, social security number, or credit card information, in order to commit fraud or other illegal activities. The thief may use this information to open bank accounts, make purchases, or apply for loans in the victim's name, causing financial harm and damaging the victim's credit score. It can happen both in the physical world (e.g. someone stealing your mail or wallet) and online (e.g. someone hacking into your social media or email account). It is important to take steps to protect your personal information and monitor your financial accounts to prevent identity theft.

A collection of facts and figures is known to be _________

Antwortdetails

The correct answer is "Data". Data refers to a collection of facts, figures, or information that can be processed or analyzed to gain insights or make informed decisions. Data can come in different forms, such as numbers, text, images, audio, or video. It can be stored in various formats, including spreadsheets, databases, documents, or files. For example, if you have a list of customer names, addresses, and phone numbers in a spreadsheet, this is considered data. If you store this information in a database, it becomes a structured collection of data that can be easily accessed and manipulated. However, whether the data is sequenced or structured depends on how it is organized, and it is not a defining characteristic of data itself.

Java is a ______ language

Antwortdetails

Java is a high-level programming language. This means that it is designed to be easy to read and write for humans, and provides a higher level of abstraction from the hardware than lower-level languages. High-level languages like Java typically have built-in libraries and features that allow developers to write code more efficiently and focus on solving problems rather than worrying about low-level details like memory management or machine architecture. Additionally, high-level languages are typically platform-independent, which means that Java code can be compiled and run on different operating systems without needing to be rewritten.

What differs a system software from application software?

Antwortdetails

System software and application software are two broad categories of computer software, each with different functions and purposes. System software is a collection of programs that control and manage the basic operations of a computer system. It is designed to provide a platform for other software applications to run on. System software includes operating systems, device drivers, utilities, and other tools that enable the computer to operate and perform its functions. On the other hand, application software refers to programs that are designed to perform specific tasks or applications for the user. These programs are used for word processing, spreadsheets, photo editing, web browsing, and other specialized tasks. Application software is often created by third-party developers and can be installed and used by end-users. The main difference between system software and application software is the purpose they serve. System software is responsible for managing the hardware and providing a platform for other software to run on, while application software is designed to perform specific tasks for the user. Other differences between system software and application software include: - Ability to multi-task: System software is designed to manage and allocate system resources, while application software is designed to perform specific tasks. Therefore, system software has more multitasking capabilities than application software. - Minimal in terms of space: System software is usually larger in terms of size and requires more storage space than application software. - Presence of cache memory: System software may use cache memory to improve the performance of the computer system, while application software does not typically use cache memory. - Unique programs installed by the creators to help run the computer: System software includes programs that are installed by the computer manufacturer or operating system developer to help run the computer, such as device drivers and system utilities. Application software does not include these types of programs.

The Caps key on a keyboard is used to___________

Antwortdetails

The Caps key on a keyboard is used to switch between upper and lower case letters. When you press the Caps key, it changes the letter case of the letters you type from lowercase to uppercase or vice versa. This means that if you type with the Caps key on, all the letters you type will appear in uppercase. Similarly, if you type with the Caps key off, all the letters you type will appear in lowercase. This feature is particularly useful when you want to emphasize certain words or phrases, such as in titles or headings. It can also be used to make your text easier to read by adding some variety to the letter case. For example, when typing a password or other sensitive information, you may want to use a combination of upper and lower case letters to make it more secure. In summary, the Caps key is used to switch between uppercase and lowercase letters in order to make text easier to read, emphasize words, or add security to sensitive information.

Which of the following is an example of output device

Antwortdetails

The example of an output device is a speaker. An output device is any device that receives information or data from a computer or electronic device and presents or displays it to the user in a perceivable format. In the case of a speaker, it receives sound data from a computer or electronic device and produces audible sound waves that can be heard by the user. Speakers are commonly used to play music, watch videos or movies, and listen to audio from video games. On the other hand, a keyboard and mouse are examples of input devices because they allow the user to input data or commands into a computer or electronic device. Similarly, a microphone is also an input device as it converts sound waves into electrical signals that can be processed by a computer or electronic device.

The arrow displayed on the screen of a computer is called

Antwortdetails

The arrow displayed on the screen of a computer is called a "Cursor". The cursor is a graphical representation of the position where text or data can be inserted or edited on the computer screen. It is typically displayed as a blinking vertical line, a block or a underline depending on the type of application or software being used. The cursor can be moved around the screen using the computer mouse, touchpad, or keyboard keys. When the cursor is moved, the text or data following it also moves accordingly. The term "pointer" can also refer to the arrow displayed on the screen, but it is a more general term that can refer to any graphical element used to indicate a position or selection on the screen. The term "indicator" is less commonly used and generally refers to a specific type of visual cue used to provide information to the user.

Which part of a processor contains the hard ware necessary to perform all the operations required by a computer?

Antwortdetails

The part of a processor that contains the hardware necessary to perform all the operations required by a computer is the "Data path". The data path, also known as the "Arithmetic Logic Unit" (ALU), is a component of the processor that performs arithmetic and logical operations on data. It is responsible for carrying out the instructions of the computer program, performing calculations, and manipulating data. The controller, registers, and cache are also important components of a processor, but they do not contain the hardware necessary to perform all the operations required by a computer. The controller, also known as the "Control Unit", is responsible for directing the flow of data and instructions within the processor, as well as between the processor and other components of the computer. Registers are high-speed storage locations within the processor that store data temporarily for processing. Cache is a small amount of high-speed memory that stores frequently used data and instructions, making them quickly accessible to the processor. Therefore, out of the given options, the data path or ALU is the part of the processor that contains the hardware necessary to perform all the operations required by a computer.

How many different values can a bit have?

Antwortdetails

A bit is the smallest unit of digital information in computing, and it can have two possible values: 0 or 1. This is because a bit is used to represent a binary digit, which can be either on or off, true or false, or high or low. So, the answer is 2. To give an example, imagine a light switch that can either be turned on or off. We can use a bit to represent the state of the switch, where 0 represents the switch being off, and 1 represents the switch being on. In this case, a single bit is enough to represent the two possible states of the switch. Similarly, in computing, a single bit is enough to represent two possible states of any digital information.

_______ is the process of finding errors and fixing them within a program.

Antwortdetails

The process of finding errors and fixing them within a program is called debugging. When a program is being developed, it may contain errors, also known as bugs, that prevent it from functioning properly. Debugging is the process of identifying and fixing these errors. Debugging can involve a number of techniques, such as analyzing error messages, reviewing code, and stepping through the program line by line to find where errors occur. Once an error is identified, the programmer can make changes to the code to correct the issue. Compiling is the process of translating source code into machine code, which can then be executed. Execution is the process of running a program. Scanning, in the context of programming, typically refers to the process of analyzing code for security vulnerabilities rather than identifying and fixing errors. In summary, debugging is the process of identifying and fixing errors in a program, whereas compiling, executing, and scanning are different processes that serve different purposes in the development and operation of a program.

What is considered the brain of the computer?

Antwortdetails

The brain of the computer is considered to be the "Central Processing Unit" (CPU). The CPU is the primary component of a computer that performs most of the processing and calculations required to run programs and applications. It is responsible for executing instructions and controlling the operations of the computer's other hardware components, such as the memory, input/output devices, and storage devices. The CPU is often referred to as the "brain" of the computer because it performs many of the same functions that the human brain does, such as processing information, making decisions, and controlling the body (or in the case of the computer, the hardware components). It is located on the motherboard of the computer, and it consists of a small chip that contains millions of transistors and circuits that work together to perform calculations and operations at incredible speeds. While the monitor/display screen, mouse, and printer are all important components of a computer system, they do not serve the same function as the CPU. The monitor/display screen displays the output from the computer, the mouse is an input device used to control the cursor on the screen, and the printer is a device used to produce hardcopy output from the computer.

The super computers are mainly used for

Antwortdetails

Supercomputers are high-performance computers designed for handling extremely complex and large-scale computational tasks. They are mainly used for mathematical intensive scientific applications, such as simulating complex physical phenomena, weather forecasting, and drug discovery. Supercomputers can perform a vast number of calculations in a short amount of time, which is essential for solving complex problems. These computers are designed to handle massive amounts of data and perform complex algorithms, making them ideal for handling input-output intensive processing tasks. Although they can retrieve data and manipulate records like any other computer, their true power lies in their ability to perform mathematical calculations and simulations that would be impossible for regular computers. Supercomputers are used in a wide range of fields, including aerospace, automotive, energy, finance, and healthcare, to name a few. Their use has led to breakthroughs in many fields and has contributed significantly to scientific and technological advancements.

An inventory management program can assist with ________

Antwortdetails

An inventory management program can assist with all of the above: distribution, purchasing, and planning. Inventory management involves keeping track of a company's stock of goods and materials, and making sure that there are enough items on hand to meet customer demand without having too much excess inventory that ties up capital. A good inventory management program can help with distribution by providing real-time updates on inventory levels and locations, allowing companies to quickly and accurately fulfill customer orders. It can also assist with purchasing by tracking inventory levels and alerting staff when it's time to reorder supplies, helping to ensure that stock is always available when needed. Additionally, an inventory management program can assist with planning by providing data and analytics on sales trends, inventory turnover, and other key performance indicators. This information can help companies make informed decisions about which products to stock, when to order supplies, and how much inventory to keep on hand. Overall, a well-designed inventory management program can help companies save time, reduce waste, and improve efficiency.

In Boolean algebra, the bar sign (-) indicates ....................

Antwortdetails

The bar sign (-) in Boolean algebra indicates the NOT operation. The NOT operation is a unary operator that negates or inverts a Boolean value. If the input value is "true", the output of the NOT operation will be "false". And if the input value is "false", the output of the NOT operation will be "true". In essence, the NOT operation changes the truth value of the input. This operation is also sometimes referred to as the "complement" or "inverse" operation.

Which of the following system software resides in the main memory always?

Antwortdetails

The system software that always resides in the main memory is the Operating System (OS). In many operating systems, the loader resides permanently in memory. The OS manages the resources of the computer and acts as an interface between the user and the hardware. It is responsible for tasks such as memory management, process management, file management, and input/output operations. Text editors, assemblers, linkers, and loaders are all types of system software, but they do not always reside in the main memory. They are typically loaded into memory when needed, and can be swapped out of memory when other processes need more memory. This is because main memory is a limited resource and the OS dynamically allocates it to different processes as needed.

Which of the following is termed as the minimum error code?

Antwortdetails

Gray codes are less error-prone because they only change in one-bit position at a time. Hence, they are considered as the minimum error code.

The actual physical network of wires, cables and satellite that connects computers and resources throughout the world is the _______________

Antwortdetails

The actual physical network of wires, cables, and satellites that connects computers and resources throughout the world is the Internet. The Internet is a global network of connected devices that enables communication and exchange of information between computers. It enables devices to connect and share resources such as websites, email, files, and other digital content. The Internet uses a variety of communication protocols and technologies, including wired and wireless connections, to facilitate this communication and exchange of information. The Internet is a vital part of our daily lives, providing access to information and enabling us to communicate and collaborate with others from anywhere in the world.

Computer applications are example of ___________

Antwortdetails

Computer applications are an example of software. Software refers to the programs, data, and instructions that tell a computer what to do and how to do it. Computer applications are specific types of software that are designed to perform particular tasks or solve particular problems. Examples of computer applications include web browsers, word processors, email clients, and games. Computer applications are different from computer hardware, which refers to the physical components of a computer, such as the processor, memory, and storage devices. Computer utilities and program packages are different types of software that can be used to manage and maintain a computer system, but they are not the same as computer applications, which are designed for specific tasks and are often used by end-users. In summary, computer applications are a type of software, which refers to the programs, data, and instructions that tell a computer what to do and how to do it. Computer applications are designed to perform specific tasks or solve specific problems, and examples include web browsers, word processors, email clients, and games.

Total types of data that can be read by document reader are

Antwortdetails

Document readers are devices or software programs that can analyze and interpret written or printed text on a document. These devices can read different types of data from documents such as marks, handwritten and printed characters, and printed lines. Marks can include things like checkmarks or ticks that people might use to indicate a selection on a form or questionnaire. Handwritten characters are any letters, numbers or symbols that are written by hand, whereas printed characters are those that are produced by a printer. Printed lines refer to the lines of text that are printed on a page. Therefore, the correct answer is "all of the above" as document readers can read all of these types of data from documents.

A computer can't boot if it does not have ____________

Antwortdetails

A computer cannot boot if it does not have an operating system (OS). An operating system is the most basic software that runs on a computer and is responsible for managing and coordinating all the activities of the computer hardware and software. It is the first program that runs when the computer starts up, and it is responsible for initializing the hardware and loading other software, such as device drivers and applications. Without an operating system, the computer would not be able to perform any useful tasks, as it would not have the necessary software to control and manage its hardware components. Examples of popular operating systems include Microsoft Windows, macOS, and Linux.

What does a linker program do?

Antwortdetails

A linker program is a software tool that links different parts of a computer program together. Think of a computer program as a puzzle with many pieces. The linker takes all those pieces and puts them together to make the complete program. The linker performs tasks such as combining object files, resolving symbol references, and creating the final executable file. The linker program takes care of the following tasks: 1. Linking the program with other programs needed for its execution. For example, if a program uses a library like the C standard library, the linker will link the program with that library so that the program can use its functions. 2. Relocating the program to execute from a specific memory area allocated to it. This means that the linker will place the program in a specific area of the computer's memory so that it can be executed. 3. Interfacing the program with the entities generating its input data. This means that the linker will make sure that the program can receive data from other parts of the system, such as user input or data from a file. In summary, the linker program is responsible for putting all the pieces of a computer program together so that it can be executed correctly.

Which of the listed is not a type of computer application?

Antwortdetails

"Joy stick" is not a type of computer application. A computer application, also known as an application or app, is a program that runs on a computer and provides a specific set of functions for the user to perform. Examples of computer applications include Microsoft Word for word processing, Firefox for web browsing, and VLC media player for playing audio and video files. A joy stick, on the other hand, is a device used to control movement in computer games or simulations. It typically consists of a stick that can be moved in different directions to control the movement of an object on the screen. Joy sticks are not considered applications because they do not provide specific functions like a word processor or media player, but rather serve as input devices for other applications.