Quiz: SQL Database
Question 1
2 / 2 pts
For the ____ operation, it is required that the the two tables have a
common attribute.
join
Question 2
2 / 2 pts
A collection of fields all related to a single object, activity, or individual
is a(n) _____.
record
Question 3
2 / 2 pts
As this is your first job working with databases, your manager wants you
to familiarize yourself with all of the tables in the database. Therefore,
he asks you to produce a query for each table that displays all of the
columns (fields) and all of the rows (records) using a separate SELECT
query for each table.
Write a SQL query to display all the data in the OrderDetails
table. Run the query and answer the following questions. In
answering these question you must provide the responses exactly as
they appear in the results. These are Case Sensitive. For example, if the
field name is FirstName that is the only correct answer. (First Name,
firstname, Firstname are all incorrect)
1. What is the Number of Records:
2. Reading from left to right--the first field name is:
3. Reading from left to right--the second field name is:
4. Reading from left to right--the last field name is
Answer 1:
518
Answer 2:
OrderDetailID
Answer 3:
OrderID
