In SQL, how do you combine the contents of 2 (or more) queries, into a single, combined table without omitting duplicates?

In SQL, how do you combine the contents of 2 (or more) queries, into a single, combined table without omitting duplicates?

• UNION
• UNION ALL
• FULL JOIN
• JOIN 

 

EXPLANATION

The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table. A UNION statement effectively does a SELECT DISTINCT on the results set.
Here's a good, quick resource: http://www.codefari.com/2015/10/what-is-difference-between-union-and.html

SOURCE

http://www.codefari.com/2015/10/what-is-difference-between-union-and.html

Read More

Which of the following technologies is required to run Hyper-V on Windows 2012 R2?

Which of the following technologies is required to run Hyper-V on Windows 2012 R2?

• Hardware Enforced Data Execution Prevention (DEP)
• Hyper-threading
• DirectX
• MMX4 

 

EXPLANATION

Hyper-V virtualization technology requires specific hardware. You can identify systems that support x64-based architecture and Hyper-V by searching the Windows Server Catalog for Hyper-V: Windows Server catalog.
Hyper-V Server has hardware requirements that are similar to those for the Hyper-V role in other editions of Windows Server. Hardware-enforced Data Execution Prevention (DEP) must be available and enabled. Specifically, you must enable the Intel XD (“execute disable”) bit or the AMD NX (“no execute”) bit.

SOURCE

https://technet.microsoft.com/en-us/library/cc731898(v=ws.11).aspx

Read More

In Windows Server, which of the following is NOT a domain-level Flexible Single Master Operation (FSMO) role?

In Windows Server, which of the following is NOT a domain-level Flexible Single Master Operation (FSMO) role?

• Domain Naming Master
• Relative ID (RID) Master
• Infrastructure Master
• Primary Domain Controller (PDC) Emulator 

EXPLANATION

There are five FSMO Roles represented in a typical Windows Active Directory, three domain-level, two enterprise-level. The forest/enterprise level roles are Schema Master and Domain Naming Master. The domain roles are PDC Emulator, Infrastructure Master, and RID Master.
A more detailed breakdown of FSMO roles can be found here.

Read More

Which of the following is the most common trunking protocol used in virtual LANs?

Which of the following is the most common trunking protocol used in virtual LANs?

• 802.1t
• 802.1z
• 802.1X
• 802.1Q 

 

EXPLANATION

IEEE 802.1Q is the networking standard that supports VLANs on an Ethernet network. The standard defines a system of VLAN tagging for Ethernet frames and the accompanying procedures to be used by bridges and switches in handling such frames
 

Read More

Which one of these is NOT a VoIP protocol?

Which one of these is NOT a VoIP protocol?

• H.248
• MXLP
• SRTP
• SIP 

 

EXPLANATION

SIP, SRTP, and H.248 are all valid VoIP proptocols. MXLP, however, just sounds cool.
https://www.packetizer.com/ipmc/papers/understanding_voip/voip_protocols.html

SOURCE

https://www.packetizer.com/ipmc/papers/understanding_voip/voip_protocols.html

Read More

Which VMware vSphere feature, when configured, streams a guest VM's changes to an exact replica VM on another host to prevent outages and data loss?

Which VMware vSphere feature, when configured, streams a guest VM's changes to an exact replica VM on another host to prevent outages and data loss?

• DRS
• High Availability
• Fault Tolerance
• Distributed Virtual Switching

EXPLANATION

VMware's Fault Tolerance (FT) feature allows you to protect a VM with an exact copy on another host machine. All of the changes are synced to the copy, so if the host fails in any way, vSphere will activate this copy. The effect is instantaneous, and allows you to provide constant uptime for mission-critical VMs.
You can read about Fault Tolerance, as well as its requirements and restrictions here: https://www.vmware.com/products/vsphere/features/fault-tolerance

Read More

Motherboards that support more than four sticks of RAM may require what to function properly?

Motherboards that support more than four sticks of RAM may require what to function properly?

• Buffered RAM
• Dual-channel RAM
• ECC RAM
• DDR3 RAM 

 

EXPLANATION

Motherboards that support more than four sticks of RAM may require buffered RAM to function properly.This helps you get around the electrical hassles, by adding a buffering chip to the DRAM stick that acts as an intermediary between the DRAM and the MCC.

SOURCE

https://www.coursehero.com/file/p7tjkcd/a-The-motherboard-requires-SDRAM-not-RDRAM-b-The-motherboard-requires-DDR-SDRAM/

Read More