What is the largest partition size supported by native DOS running FAT16?

What is the largest partition size supported by native DOS running FAT16?

• 3GB
• 2GB
• 1GB
• 512MB 

EXPLANATION

Due to the mathematical limitations of FAT16, without an overlay file or special driver the largest partition size is 2GB.The limit on partition size was dictated by the 8-bit signed count of
sectors per cluster, which originally had a maximum power-of-two value of 64. With the standard hard disk sector size of 512 bytes, this gives a maximum of 32 KiB cluster size, thereby fixing the "definitive" limit for the FAT16 partition size at 2 GiB for sector size 512.

SOURCE

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

Read More

What is the not equals operator in Excel?

What is the not equals operator in Excel?

• NOT()
• <>
• >=
• !=

 

EXPLANATION

When comparing two pieces of data in Excel, what operator would you use to test if they were not equal?
If I were comparing cells A1 to B1, my formula would be:

=A1___B1

NOT() is a function, not an operator.

SOURCE

https://support.office.com/en-us/article/Calculation-operators-and-precedence-in-Excel-48be406d-4975-4d31-b2b8-7af9e0e2878a#tblID0EABCAFAAA

Read More

In SQL, what is the effect of the TRUNCATE TABLE statement?

In SQL, what is the effect of the TRUNCATE TABLE statement?

• To delete all of the rows contained within a table
• To drop all of the tables in a database
• To shorten all textual values in a column to a specified number of characters
• To drop all of the columns defined on a table 

 

EXPLANATION

TRUNCATE TABLE table-name;

TRUNCATE removes all of the rows from the specified table without logging the individual row deletions, without scanning the table, and makes freed disk space available to the operating system immediately, without requiring a subsequent VACUUM operation.
TRUNCATE TABLE is similar to a DELETE statement with no WHERE clause, which also removes all of the rows from a table; however, TRUNCATE is faster and uses fewer resources. TRUNCATE is most useful when working with very large tables where an unqualified DELETE could adversely affect database performance.

Read More

Which of these is an advantage of Manchester Encoding?

Which of these is an advantage of Manchester Encoding?

• It uses less bits than the original signal
• It is named after an English City
• Very easy to understand
• The signal is self-synchronizing 

EXPLANATION

"In data transmission, Manchester encoding is a form of digital encoding in which data bits are represented by transitions from one logical state to the other. This is different from the more common method of encoding, in which a bit is represented by either a high state such as +5 volts or a low state such as 0 volts".
"The chief advantage of Manchester Encoding is the fact that the signal synchronizes itself." (See link for further reading).

http://searchnetworking.techtarget.com/definition/Manchester-encoding

Read More

Which of these files will not fit in a 32GB flashdrive formatted as FAT32?

Which of these files will not fit in a 32GB flashdrive formatted as FAT32?

• 10 .msi files with 1000MB each
• A .zip file with 1024MB
• 3 .tar.gz files with 5GB each
• All of them would fit just fine 

EXPLANATION

Since your flash drive is formatted with the FAT32 file system, any file that is larger than 4GB will not be placed there. This type of a file system has a built-in limitation on the size of the files that it may contain. Although the total size of the files that you can copy to a FAT32 drive could be as large as 2TB (or the physical capacity of the drive, whichever is smaller), the size of each individual file may not exceed 4GB.

This limitation may sound silly: why would anyone design a system that would not allow for the larger files? The problem is, when the FAT32 file system was designed (that was back in the days of Windows 95), no one anticipated that we would have such large files in use today. Or, maybe the designers hoped that by the time such large files became common, the use of the FAT32 system would be replaced by more modern systems.

Read More