Microsoft SQL Administration Online Certification Training

CPU Pressure is defined as the state where the CPU is occupied with currently assigned tasks and there are more tasks lined up in the queue which have not yet started.

RAID means Redundant Array of Inexpensive Disks and it is used to provide fault tolerance to database servers.

There are six RAID levels from 0 to 5 which offer different levels of performance and fault tolerance.

IP address is a 32-bit number

Five layers combine in TCP/IP protocol. These are – application, transport, internet, data, link and physical

It means reviewing the layers of the Network architecture, web client and web server application to determine the hardware and software configuration dependencies for the application under test.

Transmission Control Protocol and Internet Protocol

Ethernet networks and Token ring networks

Joins are used in queries to explain how different tables are related. They also allow selection of data from table. Different types of joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as LEFT OUTER JOINS, RIGHT OUTER JOINS and FULL OUTER JOINS.

• A candidate key is one that can identify each row of a table uniquely.
• If the table has more than one candidate key, one of them will become the primary key, and the rest are called alternate keys.
• A key formed by combining at least two or more columns is called composite key.