Database Concepts Test - 2

In the old operating systems, the file structure used to store and manage files is called the FAT 32 ( or File Allocation Table). Later, when the technology evolves with time, a new type of file system is introduced, known as the New Technology File System. It overcomes all the drawbacks, issues that exist in FAT file architecture and has many other new features such as it is fast, it can handle files whose size is even greater than 4 GB.

The files with a size of less than 4 GB or equal to 4GB are easily supported by the FAT. All files with a size greater than the maximum size (or is 4Gb) are not supported by the FAT.

A huge collection of different types of data/information which collected from many different sources stored in one place is called a data warehouse. It works just like the standard warehouse, which is generally a type of holding area/building to store the different types of different goods in huge quantities until they are further distributed. Therefore the correct answer is Data Warehouse.

The New Technology File System was introduced in 1993 for the very first time as a part of new Windows operating systems (Windows NT 3.1).
You may be surprised to know that windows are still using it because of its fast speed and can support files whose size is up to 16TB (16 terabytes), which is much more than that file size supported by the old system.

The data redundancy generally occurs whenever more than one copy of the exact same data exists in several different places. Sometimes it may cause data inconsistency, which can result in an unreliable source of data or information that is not good for anyone.

The tools used to obtain meaningful information or Data from the large collection of data (or from the Data Warehouses) are known as the Data mining tools. Through data mining, one can easily filter the useful information or data from the massive collection of the data. Therefore the correct answer is Data Mining.

Data abstraction means displaying or sharing only the data that is needed and hiding from all other data until it is necessary to share it. However, the data abstraction level that describes how the data was actually stored in the user 's machine (or system) is known as the Physical level. Therefore the correct answer is B.

The Mata Data refers to the type of data that describes the other data or information.
A general file or document is nothing more than a sequence of bytes that contains information like file name, file size, and date &time when the document was created or modified.
To understand it in more details, consider the following example:
For a common music file, the metadata may include the singer 's name, the year it was released, and the lyrics, etc.

Whenever we have some related data, information or records, we collect all those related data (or records), put them together, store them in one place, and give that collection a name that is known as a file.

The term "DBA "refers to the Database Administrator that manages the whole database and updates the database on a regular basis. In short, the database administrator has the responsibility of the whole database and to maintain it in an optimal &stable state.