Access

posted by .

A database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a query named uery1, which combines the data from the tables. If the Products table is deleted, what will happen when users run Query1?

A. Only the data of the Products table will be retrieved.
B. Only the data of the Orders table will be retrieved.
C. An error will be generated
D. The data will be successfully retrieved

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Probability

    A store sells two types of tables: plain and deluxe. When a customer buys a table, there is an 80% chance that it will be a plain table. Assume that whether or not the type of table that one customer buys is independent of the types …
  2. computer science

    I need a realational database containing information about music performers, their recordings, and the composers of the music they recorded (no redundancies). Elements should include: database file contains at least 3 tables relationships …
  3. Math

    The library at Miller Elementary School has an odd number of tables. Some tables will seat 4 students and some tables that will seat 6 students. A total of 32 students can sit at the tables with no empty seats. What is the number of …
  4. SQL Server

    I have created a Database called Business with the 2 tables as follows: dbo.Orders ID OrderID ItemName Quantity Price SalesID dbo.Sales SalesID FIrstName LastName OrderID I need to create a stored procedure to show all the data from …
  5. Math

    2)Banquet Seating A banquet hall offers two types of tables for rent: 6-person rectangular tables at a cost of $26 each and 10-person round tables at a cost of $51 each. Kathleen would like to rent the hall for a wedding banquet and …
  6. Math Grade 5

    The Eatery Restaurant has 200 tables. On a recent evening, there were reservations for 1/10 of the tables. How many tables were reserved?
  7. Math

    The Eatery Restaurant has 200 tables. On a recent evening, there were reservations for fraction 1/10 of the tables. How many tables were reserved?
  8. Math 1350

    One rectangular table seats three people along each side and two people are seated at each end. The tables are place end-to-end in one long line. Draw a series of pictures that will help you find a pattern to predict how many tables …
  9. Math

    The school is having a big event in the gym and wants to use their rectangular tables. 6 people can sit together at one rectangular table. If 2 tables are placed together, 10 people can sit together. So the pattern I noticed is 4 people …
  10. Math

    A certain restaurant has exactly 19 tables. Some of these tables are larger tables that can seat 6 people and the others are smaller tables that can seat just 4 people. If a total of 90 people can be seated at this restaurant, how …

More Similar Questions