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