Quiz: Lab — SQL Database
Due Aug 17 at 11:59pm
Points 50
Questions 23
Time Limit None
Instructions
The quiz:
Covers the Read: SQL Database Mini Tutorial and Interact: SQL Tutorial.
Contains 23 multiple-choice and short-answer questions.
No time limit.
Allows 1 attempt.
|s worth 50 points.
Quiz: SQL Database Resources
e SQL Database Mini Tutorial |
e SQL Tutorial 5
Attempt History
Attempt Time Score
LATEST Attempt 1 75 minutes 38 out of 50
Correct answers are hidden.
Score for this quiz: 38 out of 50
Submitted Aug 15 at 4:17pm
This attempt took 75 minutes.
Question 1
2/ 2pts
A database 1s a collection of integrated and related
fields
attributes
records
files
Question 2
2/2pts
A(n) 1sa field or set of fields in a record that uniquely identifies the record.
attribute
entity
primary key
data item
Question 3
2/2pts
For the operation, it is required that the the two tables have a common attribute.
, delete
select
project
join
Question 4
2/2pts
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 Suppliers table. Run the query and answer the following
guestions. 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, Firsthname are all incorrect)
1. What is the Number of Records:[ 29 ]
2. Reading from left to right--the first field name is: | SupplieriD ]
3. Reading from left to right--the third field name is:|_ContactName |
4. Reading from left to right--the last field name is|_Phone |
Answer 1:
29
Answer 2:
SupplierlD
Answer 3:
ContactName
Answer 4:
Phone
Question 5
2/ 2pts
Copy of
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 Shippers table. Run the query and answer the following
guestions. 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:[ 3 ]
2. Reading from left to right--the first field name is: | ShipperiD |
3. Reading from left to right--the second field name is:|_ShipperName |
Due Aug 17 at 11:59pm
Points 50
Questions 23
Time Limit None
Instructions
The quiz:
Covers the Read: SQL Database Mini Tutorial and Interact: SQL Tutorial.
Contains 23 multiple-choice and short-answer questions.
No time limit.
Allows 1 attempt.
|s worth 50 points.
Quiz: SQL Database Resources
e SQL Database Mini Tutorial |
e SQL Tutorial 5
Attempt History
Attempt Time Score
LATEST Attempt 1 75 minutes 38 out of 50
Correct answers are hidden.
Score for this quiz: 38 out of 50
Submitted Aug 15 at 4:17pm
This attempt took 75 minutes.
Question 1
2/ 2pts
A database 1s a collection of integrated and related
fields
attributes
records
files
Question 2
2/2pts
A(n) 1sa field or set of fields in a record that uniquely identifies the record.
attribute
entity
primary key
data item
Question 3
2/2pts
For the operation, it is required that the the two tables have a common attribute.
, delete
select
project
join
Question 4
2/2pts
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 Suppliers table. Run the query and answer the following
guestions. 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, Firsthname are all incorrect)
1. What is the Number of Records:[ 29 ]
2. Reading from left to right--the first field name is: | SupplieriD ]
3. Reading from left to right--the third field name is:|_ContactName |
4. Reading from left to right--the last field name is|_Phone |
Answer 1:
29
Answer 2:
SupplierlD
Answer 3:
ContactName
Answer 4:
Phone
Question 5
2/ 2pts
Copy of
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 Shippers table. Run the query and answer the following
guestions. 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:[ 3 ]
2. Reading from left to right--the first field name is: | ShipperiD |
3. Reading from left to right--the second field name is:|_ShipperName |
