DBMS Quiz 1

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 is 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;

In a relational database, a one-to-many relationship exists when one row in table A may be linked with many rows in table B, but one row in table B is linked to only one row in table A. It is important to note that a one-to-many relationship is not a property of the data, but rather of the relationship itself.
We can understand the "one to many" relationship as a teacher who may have more than one class to attend.

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.

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.

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 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.

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.

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 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.

In SQL, the relation is represented by a table, and a table is a collection of rows and columns. Therefore the collection of rows & columns is called the table, whereas a table is known as the relation in the SQL. So in a relation (or we can say table), rows are called the tuples. So, the correct answer will be tuples.