For every unique constraint on a column, SQL server will create which of the following?

For every unique constraint on a column, SQL server will create which of the following?

• An entry for that column
• A non-clustered index for that column
• A clustered index for that column
• A filtered index 

 

EXPLANATION

For every unique constraint on a column, SQL server creates a non-clustered index. A non-clustered index has a structure separate from the data rows. It contains non-clustered index key values and each key value entry has a pointer to the data row that contains the key value.

Read More

Unix time is the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC) on what date?

Unix time is the number of seconds that have elapsed since 00:00:00 Coordinated Universal Time (UTC) on what date?

• Saturday, January 1, 2000
• Sunday, December 28, 1969
• Thursday, January 1, 1970
• Monday, January 1, 1900 

 

EXPLANATION

Unix time counts the number of seconds that have elapsed since 00:00:00 UTC on January 1, 1970. It is used in Unix-like operating systems and file formats. Because it doesn't deal with leap seconds, it is not a true representation of UTC. Check out Unix time for yourself by typing "date +%s" on the command line.

Fun fact: December 28, 1969, is Linus Torvalds' birthday, which makes him older than Unix.

Read More

Which are Fax over IP Protocols?

Which are Fax over IP Protocols?

• k.30 and k.38
• M.16 and M.204
• H.323 and H.404
• t.30 and t.38 

 

EXPLANATION

t.30 and t.38 are fax over ip protocols

SOURCE

https://www.3cx.com/pbx/foip/ 

Read More

What Azure BGP Private ASN are reserved?

What Azure BGP Private ASN are reserved?

• 65515, 65517, 65518, 65519, 65520
• 54000, 54100, 54200, 54300, 54400
• 60001, 60002, 60003, 60004, 60005
• 67715, 67717, 67718, 67719, 67720 

 

EXPLANATION

Private and Public Azure ASN's can be foudn here:
https://docs.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-bgp-overview

SOURCE

https://docs.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-bgp-overview

Read More

Which of the following standards relates to a video compression standard?

Which of the following standards relates to a video compression standard?

• G.711
• G.729
• H.264
• H.323 

H.264 is an industry standard for video compression, the process of converting digital video into a format that takes up less capacity when it is stored or transmitted. Video compression (or video coding) is an essential technology for applications such as digital television, DVD-Video, mobile TV, video conferencing and internet video streaming.

SOURCE

https://www.vcodex.com/h264-resources/

Read More

In VMware ESXi, when expanding a virtual disk, which of the follwing should not exist?

In VMware ESXi, when expanding a virtual disk, which of the follwing should not exist?

• A new virtual machine
• Backup
• Snapshots
• Available space 

 

EXPLANATION

The Prerequisites for expanding a virtual disk are:

■ Power off the virtual machine.

■ Verify that the virtual disk is not mapped or mounted. You cannot expand a virtual disk while it is mapped or mounted.

■ Verify that the virtual machine has no snapshots.

■ Verify that the virtual machine is not a linked clone or the parent of a linked clone.

SOURCE

https://pubs.vmware.com/workstation-9/index.jsp?topic=%2Fcom.vmware.ws.using.doc%2FGUID-73BEB4E6-A1B9-41F4-BA37-364C4B067AA8.html

Read More

What does the x stand for in AGP 8x?

What does the x stand for in AGP 8x?

• Times Graphic Speed
• Times FSB Speed
• Times CPU Speed
• Times original AGP Speed [Times the bus speed ]

EXPLANATION

AGP (Accelerated Graphics Port) is a high-speed 32-bit port from Intel for attaching a display adapter to a PC. It provides a direct connection between the card and memory, and only one AGP slot is on the motherboard.
AGP was introduced as a higher-speed alternative to PCI display adapters, and it freed a PCI slot for another peripheral device. The brown AGP slot is slightly shorter than the white PCI slot and is located about an inch farther back. AGP is superseded by PCI Express.

Read More