New Articles for MCSE, MCSD, MCAD, CIW, CompTIA, Oracle, SCJP certifications
All articles for IT certification
Tips and How Tos for IT certification
What is the WITH CHECK OPTION clause?
The WITH CHECK OPTION clause is used with the CREATE VIEW statement. Creating a view with the WITH CHECK OPTION clause forces all data modification statements, executed against the view, to be cancelled, if they have modified rows in a way that can cause them to disappear from the view....
continue reading "What is the WITH CHECK OPTION clause?" »
What is CMOS?
CMOS stands for Complimentary Metal Oxide Semiconductor. It is a chip installed on the motherboard, which stores hardware configuration of the computer. When the computer is booted, the hardware is checked according to the CMOS configuration. If the hardware is not configured according to the...
continue reading "What is CMOS?" »
What is Locals window?
in MCDBA
Locals window is a debugging window. It displays the value of variables within the scope of the current procedure. As execution switches from procedure to procedure, the contents of the Locals window change to reflect only the variables applicable to the current procedure. It can be used to see...
continue reading "What is Locals window?" »
What is a CMOS battery?
in A+ 2003
A Complementary Metal Oxide Semiconductor (CMOS) battery is installed on the motherboard. It provides backup to CMOS to store computer hardware configuration, date, and time settings when a computer's main power is off.
Note: Incorrect date and time on the computer indicate failure of the CMOS...
continue reading "What is a CMOS battery?" »
What is POST?
in A+ 2003
Power On Self Test (POST) is a function performed by a chip known as ROM BIOS that is plugged into a computer's motherboard. When a computer is turned on or restarted, it begins the Power On Self Test (POST) routine. The POST routine determines the available amount of real memory and verifies the...
continue reading "What is POST?" »
What is virtual memory?
Virtual memory is a temporary storage in the hard disk for storing additional data in the RAM. When the physical memory (RAM) is exhausted, operating systems (such as Windows 95/98, NT, and 2000) move the data corresponding to older processes from the RAM to the virtual memory area on the hard...
continue reading "What is virtual memory?" »
What is a broadcast storm?
Broadcast storm is a situation in which one or more network devices send jabber packets constantly and increase traffic. A faulty network interface card (NIC) that sends jabber packets can be detected by the network monitor software.
A faulty NIC and a down server that serves network resources...
continue reading "What is a broadcast storm?" »
What is Plug and Play feature?
Plug and Play feature is a combination of hardware and software support, which enables a computer to recognize and adapt to hardware configuration changes without user intervention. The Plug and Play system requires the interaction of the operating system, Basic Input/Output System (BIOS),...
continue reading "What is Plug and Play feature?" »
What is System File Checker utility?
The System File Checker utility is used to verify the integrity of the operating system files, to restore them if they are corrupt, and to extract compressed files (such as drivers) from installation disks. It can also be used to backup the existing files before restoring the original files.
continue reading "What is System File Checker utility?" »
What is TCP/IP?
Transmission Control Protocol/Internet Protocol (TCP/IP) is a suite of standard protocols that govern how data passes between networks. It can be used to provide communication between the basic operating systems, on local and wide-area networks (WANs). It is considered the primary protocol of the...
continue reading "What is TCP/IP?" »
