System Software is the software that is directly related to coordinating computer operations and performs tasks associated with controlling and utilizing computer hardware. These programs assist in running application programs and are designed to control the operation of a computer system. System software directs the computer what to do, when to do and how to…
Digital computers are classified according to their computing capabilities. The various types of digital computers are discussed below: 1. Micro Computers: These are also known as Personal Computers. These type of digital computer uses a microprocessor (a CPU on a single chip) and include both desktops and laptops. These computers can work on small volume…
Hybrid Computers use both analog and digital technology. It has the speed of analog computer and the accuracy of a digital computer. It may accept digital or analog signals but an extensive conversion of data from digital to analog and analog to digital has to be done. Generally the analog components provide efficient processing of…
An analog computer works on continuously changeable aspects of physical phenomenon such as fluid pressure, mechanical motion and electrical quantities. These computers measure changes in continuous physical quantities say current and voltage. These computers are used to process data generated by ongoing physical processes. A thermometer is an example of an analog computer since it…
Digital Computers are capable of processing information in discrete form. In digital technology data which can be in the form of letters, symbols or numbers is represented in binary form i.e. 0s and 1s. Binary digits are easily expressed in a digital computer by the presence (1) or absence (0) of current or voltage. It…
When the computer is switched on, a copy of boot program is brought from ROM into the main memory. This process is called booting. The CPU first runs a jump instruction that transfers to BIOS (Basic Input output System) and it starts executing. The BIOS conducts a series of self diagnostic tests called POST (Power…
A trigger can be considered as a stored procedure that is run automatically by the database whenever some event (usually a table update) happens. Triggers can be classified in two categories depending on the level where it is triggered. They are: Row Level Trigger – An event is triggered whenever a row is inserted, updated…
A stored procedure is a set SQL statements compiled into a single execution plan which are ready for execution. A SQL stored procedure is similar to procedures in other programming languages. Following are some of the advantages of using stored procedure: 1. Modular Programming You can write a stored procedure once, then call it from…
Aggregate functions that calculate summary values, such as averages and sums, from the values in a particular column and return a single value for each set of rows to which the function applies. The aggregate functions are AVG, COUNT, COUNT(*), MAX, MIN and SUM. Aggregate functions can be applied either to all rows in a…