In SQL Server, which of the following SQL queries will show the currently installed version of SQL?

In SQL Server, which of the following SQL queries will show the currently installed version of SQL?

• Select version from @@version
• @@version
• Show @@version
• Select @@version 

EXPLANATION

Variables starting @@ are system variables. You need a select to be able to return the value, so the answer is "Select @@version". The other three answers are nonsense, as far as SQL is concerned.

SOURCE

https://www.mssqltips.com/sqlservertip/1140/how-to-tell-what-sql-server-version-you-are-running/

Read More

On an IBM i 7 server, which command do you use to work with active jobs?

On an IBM i 7 server, which command do you use to work with active jobs?

• WRKSYSSTS
• WRKSBS
• WRKACTJOB
• WRKSPLF 

 EXPLANATION

The Work with Active Jobs (WRKACTJOB) command allows you to work with performance and status information for the active jobs in the system.
The sequence of jobs can be changed with the Sequence (SEQ) parameter or through operations on the display. Other parameters allow the selection of jobs to be shown on the display. The selection parameters can also be changed by operations on the display.

SOURCE

http://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/cl/wrkactjob.htm

Read More

Which Microsoft License Key allows you to use it multiple times on different machines.

Which Microsoft License Key allows you to use it multiple times on different machines.

• VLSC
• ABS
• VLC
• MAK 

EXPLANATION

MAK (Multiple Activation Key) allows you to use the same key on multiple installations of Windows at a time.
VLC (Video Lan Client) is a powerful media player.
ABS (Antilock brake system or Absolute value, depending on which of the two kinds of people you are) is just a throw away answer.
VLSC (Volume Licensing Center) is Microsoft's site that people use to manage and retrieve their licenses and Software.

SOURCE

https://technet.microsoft.com/en-us/library/ff793435.aspx

Read More

By default, each ESXi 6.x host is provisioned with a certificate from which root certificate authority?

By default, each ESXi 6.x host is provisioned with a certificate from which root certificate authority?

• Verisign Certificate Authority
• DigiCert Certificate Authority
• VMware Certificate Authority
• RedHat Certificate Authority 

EXPLANATION

In vSphere 6.0 and later, the VMware Certificate Authority (VMCA) provisions your environment with certificates.
This includes machine SSL certificates for secure connections, solution user certificates for authentication to vCenter Single Sign-On, and certificates for ESX hosts that are added to vCenter Server.

SOURCE

https://pubs.vmware.com/vsphere-60/index.jsp

Read More

For sendmail on Linux, which of these commands is used to rebuild the /etc/aliases database?

For sendmail on Linux, which of these commands is used to rebuild the /etc/aliases database?

• rebuildaliases
• newaliases
• aliasesnew
• regenaliases 

EXPLANATION

newaliases command rebuilds /etc/aliases. It must be run each time this file is changed in order for the change to take effect.
Newaliases is identical to ''sendmail -bi''.

SOURCE

https://linux.die.net/man/1/newaliases.sendmail

Read More

What is Optical Character Recognition (OCR)?

What is Optical Character Recognition (OCR)?

• Social networking site
• Personal computer operating system
• Most appropriate software for calculating in computer
• Computer software designed to translate image of type written text.

EXPLANATION

 OCR (Optical Character Recognition) is a computer software designed to translate image of type written text.

SOURCE

https://en.wikipedia.org/wiki/Optical_character_recognition

Read More

What is the name for Microsoft's line of ERP and CRM solutions?

What is the name for Microsoft's line of ERP and CRM solutions?

• Exchange
• Office
• SharePoint
• Dynamics

EXPLANATION

The Microsoft Dynamics line of products includes a range of ERP & CRM solutions for all sizes of businesses, including GP, NAV, SL and C5, each with their own advantages for different environments.

SOURCE

https://en.wikipedia.org/wiki/Microsoft_Dynamics

Read More