Removing a set of values from a query to show less data than…

Removing a set of values from a query to show less data than in the original query (e.g. after showing amounts spent on purchases of products in various product categories for male and female shoppers, showing amounts spent on purchases of products in various product categories for male shoppers only) is an example of ________________.

HOMETOWN REALESTATEObserve the HOMETOWN REALESTATE database:…

HOMETOWN REALESTATEObserve the HOMETOWN REALESTATE database:SELLERSellerIDSellerNameRealtorIDS111PaulR1S222CarlyR1S333AnaR2S444CharlotteR2S555AidanR3C666EricR1C777ChristinaR1REALTORRealtorIDRealtorNameR1ClaireR2KateR3CliffR4WilliamThis database will be used for the following question citing tables from the HOMETOWN REALESTATE database:If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database, what will be the outcome after a user tries to delete the first record (R1, Claire) from REALTOR?

GENERICDATAObserve the tables GENERICDIMENSION1, GENERICDIME…

GENERICDATAObserve the tables GENERICDIMENSION1, GENERICDIMENSION2, and GENERICFACT:GENERICDIMENSION1AABBCCAA1BB1CC1AA2BB1CC1AA3BB2CC1AA4BB2CC1AA5BB3CC2GENERICDIMENSION2XXYYZZXX1YY1ZZ1XX2YY1ZZ2XX3YY2ZZ1XX4YY2ZZ2GENERICFACTAAXXNumberAA1XX1100AA1XX1100AA1XX3100AA1XX4100AA1XX4200AA1XX4200AA2XX4200AA3XX4200AA4XX1300AA5XX2300AA5XX2300AA5XX2300Assume the following hierarchy exist in the table GENERICDIMENSION1: CC –> BB –> AAAlso assume that there are no hierarchies in the table GENERICDIMENSION2.This scenario will be used for the questions citing GENERIC DATA.In the GENERIC DATA scenario below, ________ action was used to change Query A to Query B.QUERY A CC1CC2YY1500600YY21000300QUERY B BB1BB2BB3YY1200300600YY2800200300