How do you delete a login on SQL Server?

How do you delete a login on SQL Server?

• DISABLE LOGIN login_name
• DELETE LOGIN login_name
• A login cannot be deleted but only disabled
• DROP LOGIN login_name

EXPLANATION

In order to delete a login on SQL Server, you write "DROP LOGIN login_name."

Read More

What is the minimum size of the IPv6 packet header?

What is the minimum size of the IPv6 packet header?

• 40 octets
• 36 octets
• 32 octets
• 48 octets             

EXPLANATION

The IPv6 packet header has a minimum size of 40 octets. Options are implemented as extensions. This provides the opportunity to extend the protocol in the future without affecting the core packet structure.
RFC 2460; Internet Protocol, Version 6 (IPv6) Specification, S. Deering, R. Hinden (December 1998)
https://en.wikipedia.org/wiki/IPv6

Read More

Many mobile devices use what to measure the pitch, roll, and yaw of the device?

Many mobile devices use what to measure the pitch, roll, and yaw of the device?

• Piezometer
• Barometer
• Transducer
• Gyroscope

EXPLANATION

Many mobile devices include a gyroscope to add an extra dimension to the information supplied by the accelerometer. The gyroscope tracks rotation or twist, measuring the angular rotational velocity. This helps your device orient itself in space.

Read More

Which of the following domain trust types does not extend beyond the trusted and trusting domains?

Which of the following domain trust types does not extend beyond the trusted and trusting domains?

• Shortcut
• Forest
• Internet
• External             

EXPLANATION

An external trust provides access to resources located on an NT4 domain or a domain in a non-trusted forest. It is not transitive.
Forest trusts provide access to resources in any domain in the forest. Forest trusts are transitive.
Shortcut trusts are used to improve user login times between two domain in a forest. These trusts are also transitive.
Internet trusts do not exist

SOURCE

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

Read More

A static virtual local area network (VLAN) assigns VLANs to which of the following?

A static virtual local area network (VLAN) assigns VLANs to which of the following?

• Trunks
• Physical ports
• IP addresses
• MAC addresses 

 

EXPLANATION

Static VLANs assign VLANs to physical ports. Assigning each port to a VLAN means that whatever computer plugs into that port, it will always be a member of that port's VLAN.
Dynamic VLANs assign VLANs based on MAC addresses

Read More

What is the maximum length for a cat 5e cable run before experiencing packet loss or latency?

What is the maximum length for a cat 5e cable run before experiencing packet loss or latency?

• 500 feet
• 200 meters
• 100 meters
• 100 feet 

EXPLANATION

The maximum length for a cable segment is 100 meters. If longer runs are required, the use of active hardware such as a repeater or network switch is necessary.
https://en.wikipedia.org/wiki/Category_5_cable

Read More

On Windows, what is the MMC.exe?

On Windows, what is the MMC.exe?

• Microsoft Management Console
• Microsoft Managed Console
• Microsoft Management Control
• Microsoft Managed Control 

 

EXPLANATION

MMC.exe is the Microsoft Management Console application and is used to display various management plug-ins accessed from the Control Panel, such as the Device Manager.

Read More