Data and Databases: Master Data Management Principles for Computing

Question 1

Which of the following data types is not commonly used in relational database management systems?

Accepted Answer

Blob

Answer

Integer

Answer

String

Answer

Boolean

Question 2

Which of these languages is used to manage data in databases without specifying the exact steps to be taken?

Accepted Answer

SQL

Answer

C#

Answer

Java

Answer

Python

Question 3

In SQL, which data type is specifically designed to store true or false values?

Accepted Answer

Boolean

Answer

String

Answer

Double

Answer

Array

Question 4

Which of the following is NOT an advantage of using a database management system (DBMS)?

Accepted Answer

Allowing direct manipulation of data files

Answer

Ensuring data independence

Answer

Enhancing data security

Answer

Minimizing data redundancy

Question 5

Which data type in SQL is designed to store whole numbers?

Accepted Answer

INTEGER

Answer

VARCHAR

Answer

BOOLEAN

Answer

DOUBLE

Question 6

Which data type is NOT supported in SQL?

Accepted Answer

ARRAY

Answer

INTEGER

Answer

BOOLEAN

Answer

STRING

Question 7

Which of the following is NOT a fundamental data type in SQL?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Boolean

Question 8

Which data type is NOT supported by SQL?

Accepted Answer

Array

Answer

Integer

Answer

Char

Answer

Boolean

Question 9

Which of the following is NOT a common type of data integrity constraint used in database management systems?

Accepted Answer

Stored Procedure

Answer

Primary Key

Answer

Foreign Key

Answer

Unique Constraint

Question 10

Which of the following is not a data structure?

Accepted Answer

Function

Answer

Array

Answer

Linked list

Answer

Queue

Question 11

Which data type is NOT supported by SQL?

Accepted Answer

ARRAY

Answer

INTEGER

Answer

FLOAT

Answer

VARCHAR

Question 12

Which element is NOT a fundamental component of a relational database management system (RDBMS)?

Accepted Answer

Worksheets

Answer

Tables

Answer

Columns

Answer

Rows

Question 13

In a relational database schema, which of the following is a defining feature?

Accepted Answer

Defined relationships between tables

Answer

Hierarchical structure

Answer

Absence of referential integrity support

Answer

Support for handling vast amounts of unstructured data

Question 14

Which of the following is NOT a data type natively supported by SQL?

Accepted Answer

LIST

Answer

INTEGER

Answer

VARCHAR

Answer

BOOLEAN

Question 15

In SQL, which data type is used to store text?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Array

Question 16

Which data type is specifically designed to store dates and times?

Accepted Answer

Date

Answer

Integer

Answer

String

Answer

Boolean

Question 17

What is a potential drawback of using a database management system (DBMS)?

Accepted Answer

Increased data redundancy

Answer

Centralized data storage

Answer

Improved data security

Answer

Enhanced data integrity

Question 18

Which of the following is NOT a data structure, but rather a collection of organized data?

Accepted Answer

Database

Answer

Array

Answer

Linked list

Answer

Tree

Question 19

Which data type is used to store a single letter or symbol?

Accepted Answer

Character

Answer

Integer

Answer

String

Answer

Boolean

Question 20

Which of the following is NOT a fundamental data type supported by a relational database management system (RDBMS)?

Accepted Answer

List

Answer

Integer

Answer

String

Answer

Date

Question 21

In a database management system (DBMS), which of the following is a potential drawback?

Accepted Answer

Can result in increased data redundancy and inconsistency

Answer

Enforces data integrity and consistency

Answer

Provides data security and access control

Question 22

Which of these is not a basic data type in SQL?

Accepted Answer

Object

Answer

Integer

Answer

String

Answer

Boolean

Question 23

In SQL, which of these is NOT a recognized data type?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Boolean

Question 24

A company wants to store customer phone numbers in a database. Which data type is most suitable?

Accepted Answer

String

Answer

Integer

Answer

Boolean

Answer

Date

Question 25

Which of these data types is NOT supported in SQL?

Accepted Answer

Class

Answer

Integer

Answer

String

Answer

Float

Question 26

Which data type is NOT supported in SQL?

Accepted Answer

ARRAY

Answer

INTEGER

Answer

VARCHAR

Answer

BOOLEAN

Question 27

Which of the following data structures can store only a single element?

Accepted Answer

Variable

Answer

Array

Answer

Linked list

Answer

Binary tree

Question 28

Which of the following is a potential drawback of using data analytics in a business context?

Accepted Answer

Wasted resources and increased costs due to ineffective implementation or analysis

Answer

Improved decision-making based on data-driven insights

Answer

Increased efficiency and productivity through automation and optimization

Answer

Enhanced customer satisfaction through personalized experiences and targeted marketing

Question 29

Which data type is not supported by SQL?

Accepted Answer

JSON

Answer

INTEGER

Answer

VARCHAR

Answer

BLOB

Question 30

Which data structure ensures that each element appears only once and stores data in a specific order?

Accepted Answer

Set

Answer

List

Answer

Dictionary

Answer

Queue

Question 31

Which of the following is not a basic data type in SQL?

Accepted Answer

Object

Answer

Integer

Answer

String

Answer

Boolean

Question 32

Which of the following is NOT a measure used to protect data within a database?

Accepted Answer

Unrestricted data sharing

Answer

Encryption

Answer

Authentication

Answer

Data backup and recovery

Question 33

What is a defining feature of Big Data?

Accepted Answer

Volume, variety, velocity, and veracity

Answer

Compact size and low complexity

Answer

Well-structured and organized format

Answer

Simple analysis using traditional methods

Question 34

Which of these is not a data type in SQL?

Accepted Answer

Array

Answer

Integer

Answer

Boolean

Answer

String

Question 35

Which data type is suitable for storing extensive text data, like essays or articles?

Accepted Answer

Varchar

Answer

Integer

Answer

Double

Answer

Boolean

Question 36

What is the primary function of a database management system (DBMS)?

Accepted Answer

Managing and controlling access to data in a database

Answer

Providing a user-friendly interface for data access and manipulation

Answer

Performing complex data analysis and generating reports

Question 37

Which of these is NOT a benefit of using a database management system?

Accepted Answer

Completely removing duplicate data

Answer

Keeping data accurate and consistent

Answer

Managing data from one central location

Answer

Improving how quickly data can be accessed

Question 38

Why are NoSQL databases becoming increasingly popular in modern data management?

Accepted Answer

They can scale horizontally to handle large data volumes.

Answer

They support complex data relationships well.

Answer

They always provide faster query performance than relational databases.

Answer

They offer stronger data security than relational databases.

Question 39

Which SQL command is used to permanently delete a record from a database table?

Accepted Answer

DELETE

Answer

ADD

Answer

REMOVE

Answer

UPDATE

Question 40

Which of the following best describes the strengths and weaknesses of classification and clustering data mining algorithms?

Accepted Answer

Classification algorithms excel at predicting categorical outcomes, while clustering algorithms excel at identifying patterns and grouping data.

Answer

Clustering algorithms are more accurate than classification algorithms, especially for large datasets.

Answer

Classification algorithms can handle both numerical and categorical data, unlike clustering algorithms.

Question 41

What is the main role of data governance in ensuring data quality and compliance?

Accepted Answer

Sets rules and procedures for managing data effectively, ensuring accuracy, consistency, and completeness.

Answer

Controls data access and storage, protecting data from unauthorized access and ensuring availability.

Answer

Analyzes data for patterns and trends, helping organizations make data-driven decisions.

Question 42

What is a key distinction between NoSQL and traditional relational databases?

Accepted Answer

NoSQL databases typically excel in scalability over relational databases.

Answer

NoSQL databases handle complex data relationships better than relational databases.

Answer

Relational databases offer greater flexibility in data structure compared to NoSQL databases.

Answer

Relational databases are more cost-effective than NoSQL databases.

Question 43

What is the primary purpose of a database management system (DBMS)?

Accepted Answer

To create, manage, and interact with databases

Answer

To develop database applications

Answer

To query and update data

Answer

To perform data analysis

Question 44

What is the primary objective of data mining?

Accepted Answer

To extract knowledge and patterns from data

Answer

To clean and prepare data for analysis

Answer

To visualize data for presentation

Answer

To store data securely and efficiently

Question 45

What is a key difference between a structured and an unstructured database?

Accepted Answer

Structured databases have a predefined schema, while unstructured databases do not.

Answer

Structured databases are faster than unstructured databases.

Answer

Structured databases are more secure than unstructured databases.

Answer

Unstructured databases are only suitable for small datasets.

Question 46

Which SQL statement correctly creates a new table called 'sales' with columns 'product_id', 'product_name', and 'quantity_sold'?

Accepted Answer

CREATE TABLE sales (product_id INT, product_name VARCHAR(255), quantity_sold INT)

Answer

INSERT INTO sales (product_id, product_name, quantity_sold) VALUES (1, 'Product A', 10)

Answer

SELECT * FROM sales

Answer

ALTER TABLE sales ADD COLUMN product_price DECIMAL(10,2)

Question 47

Which of the following is NOT a data compression technique?

Accepted Answer

Encryption

Answer

Lossless

Answer

Lossy

Answer

Run-length encoding

Question 48

What uniquely identifies each row in a database table?

Accepted Answer

Primary key

Answer

Foreign key

Answer

Candidate key

Answer

Unique key

Question 49

Which SQL statement retrieves data from a database table?

Accepted Answer

SELECT

Answer

INSERT

Answer

UPDATE

Answer

DELETE

Question 50

How does a logical database model differ from a physical database model?

Accepted Answer

A logical model represents data independently of storage, while a physical model represents how data is physically stored

Answer

A physical model represents data independently of storage, while a logical model represents how data is physically stored

Answer

Both logical and physical models represent data in the same way

Answer

A logical model is more detailed than a physical model

Question 51

Which data mining technique involves identifying groups of similar data points?

Accepted Answer

Clustering

Answer

Classification

Answer

Regression

Answer

Association

Question 52

What is a primary responsibility of a data analyst?

Accepted Answer

Analyzing data to extract meaningful insights

Answer

Designing and implementing databases

Answer

Ensuring data security

Answer

Managing data storage systems

Question 53

What is the primary purpose of a database schema?

Accepted Answer

To define the structure of a database

Answer

To store data in a database

Answer

To provide a user interface for accessing data

Answer

To ensure data security

Question 54

What is a key difference between NoSQL and relational databases?

Accepted Answer

NoSQL databases offer greater flexibility in data modeling.

Answer

NoSQL databases guarantee stronger data consistency.

Answer

NoSQL databases always require a predefined schema.

Question 55

In data mining, association rule mining primarily aims to identify:

Accepted Answer

Relationships between data items

Answer

Future predictions based on past data

Answer

Distinct categories within the data

Question 56

Which ethical consideration is crucial when handling big data?

Accepted Answer

Anonymizing data

Answer

Encrypting data

Answer

Aggregating data

Question 57

Which of the following is NOT a built-in data type in SQL?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Date

Question 58

What is the primary purpose of a primary key in a database table?

Accepted Answer

To uniquely identify each record

Answer

To store the most important data

Answer

To connect to other tables

Answer

To improve data security

Question 59

What is the main goal of data mining?

Accepted Answer

To extract valuable insights from large datasets

Answer

To create new databases

Answer

To improve data protection

Answer

To visualize data

Question 60

What is the distinction between a field and a record in a database?

Accepted Answer

A field is a column, while a record is a row

Answer

A field is a row, while a record is a column

Answer

Fields and records represent the same concept

Answer

Records are stored within fields

Question 61

Which of the following SQL commands is used to create a new database?

Accepted Answer

CREATE DATABASE

Answer

CREATE TABLE

Answer

INSERT INTO

Answer

SELECT *

Question 62

What is the fundamental difference between a structured and an unstructured database?

Accepted Answer

Structured data is organized and conforms to a schema, while unstructured data does not

Answer

Unstructured data is organized and conforms to a schema, while structured data does not

Answer

Structured and unstructured databases are essentially the same

Answer

Structured databases only store text data, while unstructured databases can store any data type

Question 63

Which of the following is **not** a primitive data type in most programming languages?

Accepted Answer

Array

Answer

Integer

Answer

String

Answer

Boolean

Question 64

A database is:

Accepted Answer

A collection of organized and related data

Answer

A software application used to manage data

Answer

A network of computers connected to share data

Answer

A programming language specifically designed for data management