Relational Databases PRL Quiz 2.

Read the paper following paper to answer the quiz below.

Teng, Y. (2021) A Critical Review of SQL-Based Mining Relational Database.International Journal of Computer and Communication Engineering.

doi: 10.17706/ijcce.2021.10.3.68-74

Question 1: What is the significance of relational databases in Management Information Systems (MIS)?

A

They are mainly used for aesthetic data representation.

B

They have a minor role in data processing.

C

They are used exclusively for data encryption.

D

They play a critical role in storing and managing data in systems like Health Information Systems.

Question 2: What does mining relational database involve?

A

Solely focuses on data encryption techniques.

B

Is limited to data input and retrieval.

C

Focuses only on the physical aspect of databases.

D

Involves automated or manual extraction of patterns representing knowledge in large databases.

Question 3: What characterizes SQL-based mining in relational databases?

A

It uses SQL only for data deletion purposes.

B

It uses Structured Query Language to interact with and mine relational databases.

C

It is primarily used for database design only.

D

It involves only the physical tuning of databases.

Question 4: What is a notable research gap identified in the paper regarding SQL-based mining relational database?

A

The field is deemed irrelevant in current times.

B

Excessive research already exists in this field.

C

It is well-researched and requires no further investigation.

D

There is a lack of investigation-oriented research efforts in this area.

Question 5: How have data mining techniques been reviewed in past research according to the paper?

A

They have been reviewed in a very generalized manner, without focus on specific areas.

B

Only banking and healthcare sectors have been focused on.

C

Reviews have been specialized and problem-focused in development.

D

Only technical aspects without application contexts have been reviewed.

Question 6: What was the focus of academic publications on data mining techniques over a decade, as reviewed by Hussain Ahmad Madni, Zahid Anwar, and Munam Ali Shah?

A

Concentrated on the application of data mining in banking sector only.

B

Focused exclusively on data mining in cloud computing.

C

Only reviewed data mining techniques without applications.

D

Aimed to review and categorize data mining techniques and their applications.

Question 7. According to R. Agrawal M. Carey et al., what does database mining refer to? (refer section 3 of the paper).

A

The development of new database languages

B

The efficient construction and verification of models of patterns in large databases.

C

The task of physically organizing database servers.

D

The process of structuring new databases.

Question 8. What role do databases play in modern information management according to the paper?

A

An indispensable role in various sectors like online shopping and airline reservations.

B

A secondary role with limited application.

C

A purely technical role in data storage.

D

Only a theoretical role without practical applications.

Question 9. Which of the following is true about commercial or open-source database products mentioned in the paper?

A

Only a few of them can be mined for research.

B

They are not suitable for research purposes.

C

All of them, such as IBM DB2 and MySQL, could be mined for research purposes.

D

They are primarily used for data storage, not mining.

Question 10. What is the mining database process generally about?

A

It is solely about improving database security.

B

It is primarily about database creation and maintenance.

C

It involves discovering knowledge in databases.

D

It focuses on the hardware aspects of databases.

Question 11. What characterizes SQL-based mining relational database research work since 1990?

A

Concentrated solely on theoretical aspects without empirical studies.

B

Focused only on database security.

C

Focused on non-relational databases.

D

Summarized critically, highlighting strong and weak points of each research paper.

Question 12. What is a common theme in the advancements of SQL-based mining relational database research since 1990?

A

Prioritizing non-SQL based techniques.

B

Focusing on distributed or parallel environments.

C

Mainly empirical research, with some extending standard SQL for data mining techniques.

D

Moving away from empirical research.