Which of the following are built-in functions in SQL?

Which of the following are built-in functions in SQL?

• SUM, AVG, MIN, MAX, MULT
• SUM, AVG, MULT, DIV, MIN
• SUM, AVG, MIN, MAX, NAME
• COUNT, SUM, AVG, MAX, MIN 

 

 

EXPLANATION

COUNT, SUM, AVG, MAX, and MIN are all built-in functions in SQL.

Read More

What is a small program or function that automates a specific task called?

What is a small program or function that automates a specific task called?

• Macro
• Nano
• Micro
• Mongo 

 

EXPLANATION

A macro is a small program, or script, that automates common tasks. These scripts are usually run within programs and can often be created by the user. For example, a user might record a macro for Microsoft Word that inserts his entire address when he presses a custom key combination.

SOURCE

https://techterms.com/definition/macro

Read More

How many usable IP addresses are in a single Class C block?

How many usable IP addresses are in a single Class C block?

• 24
• 508
• 36000
• 254

EXPLANATION

There are 256 actual addresses, but the 0 and 255 host addresses are not usable, giving you only 254 usable addresses. The .255 is used as the broadcast address, anything sent to that address should be answered by all devices in the same IP Block. The .0 address is reserved as the network address and is not usable as a host address.

Read More

Which of the Following is NOT a Sync Type when Syncing Files and Folders using SyncToy, FreeFileSync and other File Syncing Tools?

Which of the Following is NOT a Sync Type when Syncing Files and Folders using SyncToy, FreeFileSync and other File Syncing Tools?

• Dedupe
• Contribute (Update)
• Sync (Two-Way Sync)
• Mirror 

 

EXPLANATION

Dedupe is a Storage Technology which operates on a block level to save storage space using pointers to data blocks. It is not a file level operation.
Contribute / Update -> Updates Files from the Left Folder Path to the Right without deleting any files or folders. Renamed, Modified and New Files and Folders are added from Left to Right.
Sync (Two-Way Sync) - New items, Renames, Modifications and Deletions are synced from Left to Right and Right to Left Paths (both directions).
Mirror - Copies and Overwrites all file and folder items from the Left Path to The Right Path - creates a mirror copy from Left to Right File Paths. Useful for Backups to removable storage such as USB External Hard Drives.

SOURCE

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

Read More

Which of the following is NOT an RFID frequency band?

Which of the following is NOT an RFID frequency band?

• 865-868 MHz
• 902-928 MHz
• 470-512 MHz
• 13.56 MHz 

 

EXPLANATION

470–512 MHz is in use in the US for low-band TV channels 14–20 (also shared for land mobile 2-way radio use in some areas). https://en.wikipedia.org/wiki/Ultra_high_frequency#United_States
All other frequencies mentioned are used for RFID communication: https://en.wikipedia.org/wiki/Radio-frequency_identification

Read More

What do you call a series of SCSI devices working together through a host adapter?

What do you call a series of SCSI devices working together through a host adapter?

• An SCSI controller
• An SCSI chain
• Cabled SCSI
• RAID 

EXPLANATION

A series of SCSI devices working together through a host adapter is called an SCSI chain. The host adapter provides the interface between the SCSI chain and the PC.

Read More

If you want to cluster MySQL databases, what software do you use?

If you want to cluster MySQL databases, what software do you use?

• MySQL Cluster
• Apache Hadoop
• Kubernetes
• Beowulf 

 EXPLANATION

MySQL Cluster provides shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.

Read More