Test: Database Concepts- 1 - Humanities/Arts MCQ

The term "DML" stands for the Data Manipulation Language used to perform the required changes in the relation's values.

The term "DDL" stands for Data Definition Language, used to perform all other essential tasks such as deleting relation and related schemas in defining the structure relation.

The Query given in option D does not contain the "from" clause, which specifies the relation from which the values have to be selected or fetched. Therefore the correct answer is D.

Join clause joins two tables by matching the common column

We can understand the "one to many" relationship as a teacher who may have more than one class to attend.

In the above-given Query, the "%" (like) operator will be used, which is generally used while searching for a certain pattern in the strings. It represents the single and multiple characters. In this case, it used with "Where "louse to select the "dept_name" that contains the Computer Since as its ending string. To understand it more clearly, consider the following syntax:
 

Syntax

SELECT column1, column2, ...
FROM table_name
WHERE columnN LIKE pattern;

The "SQL" contains a comparison known as the "BETWEEN," which is also used in one of the given queries, as you can see. The "BETWEEN" operator is generally used to simplify the "WHERE" clause that is used to specify that the value is greater than one value or greater than some values, less than one or more values.

To sort the salary from highest to lowest amount and display the employee's name alphabetically, one can use the "Desc and Asc" in the above-given Query.

The term "FAT" can be described as a file structure (or file architecture). In which all the information about the files where they are stored and where all these files need to be stored or in which directory, all that information generally stored in the file structure. Therefore the Operating system creates a table in which all the files and clusters are stored, known as the file allocation table.

The DBMS (or Database Management System) is a kind of system software used for several operations such as creating tables/databases, storing data, managing databases. It also allows modifying the data stored in the database as well.

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.