Joining Statement

Question 1

PURPOSE & FUNCTIONS OF JOIN
OPERATIONS(7)

Answer 1

1. Combine Data from Multiple Tables
2. Establish Relationships Between Tables
3. Optimize Query Efficiency
4. Support Advanced Data Analysis
5. Allow Versatile Data Retrieval
6. Enhance Data
   Integrity
7. Facilitate Real-World
   Scenarios

Question 2

Joins allow the
retrieval of related
data spread across
multiple tables in a
relational database.

Answer 2

Combine Data
from Multiple
Tables

Question 3

Joins leverage primary
and foreign key
relationships to link
rows in one table to
corresponding rows in
another.

Answer 3

Establish
Relationships Between
Tables

Question 4

By retrieving only the
required data from
multiple tables, JOIN
operations reduce
redundancy and improve
query performance.

Answer 4

Optimize Query
Efficiency

Question 5

Joins enable complex
queries that
consolidate
information for
reporting and analytics

Answer 5

Support Advanced
Data Analysis

Question 6

Different types of JOINs
(INNER, LEFT, RIGHT,
FULL OUTER, CROSS)
provide flexibility in
fetching data depending
on the analysis needs.

Answer 6

Allow Versatile Data
Retrieval

Question 7

By linking related
tables, JOINs help
maintain normalized
database structures
without duplicating
data.By linking related
tables, JOINs help
maintain normalized
database structures
without duplicating
data.

Answer 7

Enhance Data
Integrity

Question 8

JOINs mimic real-world
connections between
entities, making it
easier to model and
query practical
relationships.

Answer 8

Facilitate Real-World
Scenarios

Question 9

A _____clause is used to
combine rows from two or
more tables, based on a
related column between
them.

Answer 9

JOIN

Question 10

Syntax of JOIN

Answer 10

SELECT Orders.OrderID,
Customers.CustomerName, Orders.OrderDate
FROM Orders
INNER JOIN Customers ON Orders.CustomerID=Cus
tomers.CustomerID;

Question 11

SUPPORTED
TYPES OF
JOINS IN
MYSQL(4)

Answer 11

Inner Join
Left Join
Right Join
Cross Join

Question 12

Returns records that
have matching values in both tables

Answer 12

Inner Join

Question 13

Returns all records from
the left table, and the matched
records from the right table

Answer 13

Left Join

Question 14

Returns all records from
the right table, and the matched
records from the left table

Answer 14

Right Join

Question 15

Returns all records
from both tables

Answer 15

Cross Join

Question 16

return rows when there is at least one match in both tables

Answer 16

Inner Join

Question 17

Inner Join Syntax

Answer 17

SELECT * FROM table1
INNER JOIN table2
ON table1.Pkey = table 2.Fkey

Question 18

does not require each record in the two joined tables to have a
matching record

Answer 18

Outer Join

Question 19

Outer Join is subdivided into 3, namely:(?)

Answer 19

Left Join
Right Join
Full Join

Question 20

returns all rows from the left table (or the first table), even if there are no
matches in the right table

Answer 20

Left Join

Question 21

returns all the rows from the right table (or the second table), even if there are
no matches in the left table

Answer 21

Right Join

Question 22

both tables are secondary (or optional), such that if rows are being matched in
table A and table B, then all rows from table A are displayed even if there is no matching
row in table B, and vice versa

Answer 22

Full Join

Question 23

are SELECT statements that
have been saved in the
database

Answer 23

VIEWS

Question 24

Some Keywords Related to VIEWS

Answer 24

CREATE VIEW
ALTER VIEW
DROP VIEW

Question 25

is a keyword that enables users to create new views

Answer 25

CREATE VIEW

Question 26

SYNTAX for CREATE VIEW

Answer 26

CREATE VIEW ViewName AS SELECT statement

Question 27

is the keyword used to
modify a created view

Answer 27

ALTER VIEW

Question 28

SYNTAX for ALTER VIEW

Answer 28

ALTER VIEW ViewName AS
SELECT statement

Question 29

is used to delete a view that was previously created

Answer 29

DROP VIEW

Question 30

SYNTAX of DROP VIEW

Answer 30

DROP VIEW ViewName