The Tables Dept1 and Dept2 Are as Follows -A Relational Algebra Operator Applied to Tables Dept1 and Dept2

question 20

Multiple Choice

The tables Dept1 and Dept2 are as follows
$Table~Dept1\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 100 & \text { Logistics } & \text { Wichita } & 666 \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$

$Table~Dept2\\\begin{array}{|l|l|l|l|}\hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline 400 & \text { Sales } & \text { Reno } & 666 \\\hline\end{array}$
-A relational algebra operator applied to tables Dept1 and Dept2 produces the following result: $$\begin{array} { | l | l | l | l | } \hline \text { Deptno } & \text { Deptname } & \text { Deptcity } & \text { Deptmgr } \\\hline 200 & \text { Finance } & \text { Boise } & 555 \\\hline 300 & \text { Marketing } & \text { Pierre } & 666 \\\hline\end{array}$$ The operation is:

• A) Dept1 UNION Dept2
• B) Dept1 INTERSECT Dept2
• C) Dept1 DIFFERENCE Dept2
• D) Dept2 DIFFERENCE Dept1

---

Definitions:

Nutrition Counselors

Professionals who provide guidance on diet, eating habits, and nutritional practices for health improvement or specific conditions.

Marketing Plan

A comprehensive document outlining a company's strategy and specific actions it will undertake to promote a service or product to potential customers.

Social Media

Digital platforms and technologies that enable users to create, share content, or participate in social networking.

Private Practice

The practice of medicine, law, counseling, or other professional services by individuals or groups who are not employed by an external organization.