Data | MCQs

Explanation

A Megabyte (MB) consists of 1,048,576 bytes in the binary system.

It is the standard used in computing.

Explanation

WinZip is a widely used software program for data compression.

It allowing users to compress files into smaller sizes for easier storage and transfer.

It is specialized for this task, unlike MS Office, Antivirus, or Operating Systems, which serve different purposes.

Explanation

An array is considered a composite data type because it can hold multiple values of the same type in a single variable.

Each value is accessed by an index, and arrays can be used to store collections of related data

Explanation

USB 3.0 is a high-speed connection standard that can transfer data at speeds of up to 5 Gbps (gigabits per second), making it ideal for high data transfer.

Explanation

The maximum value that can be stored in an "int" data type in C++ is 2147483647.

Explanation

• Communication with MySQL is established through network calls.
• MySQL is a client-server system, where clients communicate with the server over a network connection.
• This communication involves sending queries, commands, and receiving responses over the network.

Explanation

The operator that tests column for the absence of data is an is NULL operator. The NULL operator is used in the database for representing that a particular field is empty.

SELECT ‘column_name’

FROM ‘table_name’

WHERE ‘column_name’ IS NULL

Explanation

A scatter plot is a type of graph used in Exploratory Data Analysis (EDA) to visualize the relationship between two continuous variables. It displays the data points as points on a coordinate grid, with the x-axis representing one variable and the y-axis representing the other.

The primary purpose of a scatter plot is to:

• Show the strength and direction of the relationship between the two variables
• Identify patterns, correlations, or outliers in the data
• Help identify potential relationships that may not be immediately apparent from looking at individual variables

Scatter plots are particularly useful for:

• Identifying linear or non-linear relationships
• Identifying clusters or groups in the data
• Identifying outliers or anomalies

Explanation

MySQL, Microsoft Access, IBM DB2 are database management systems while Google is a search engine.

Explanation

• A data mart is a subset of a data warehouse that is focused on a specific functional area or department, such as marketing, sales, or finance.
• It contains a subset of the data warehouse's data, but is designed to be more accessible and user-friendly for a specific group of users.