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