You have a table of products with fields for ProductID, Name, and Price.
You need to write an UPDATE statement that sets the value in the InStock field to Yes for a specific ProductID.
Which clause should you use in your update statement?
Correct Answer:
B
What defines the amount of storage space that is allocated to a value in a column?
Correct Answer:
C
You accept an IT internship at a local charity. The charity has two tables in their data model named Chapter and Language, as defined below:
You create a third table named ChapterLanguage to relate the Chapter table and the Language table.
You need to select columns from the Chapter and Language tables to create a composite primary key for the ChapterLanguage table.
Which two columns should you select? (Choose two.)
Correct Answer:
AE
DRAG DROP
Your class project requires that you help a charity set up a website.
The website collects information about volunteers. Each volunteer record must be uniquely identified.
The following information is stored for each volunteer:
✑ Given name
✑ Surname
✑ Date of birth
✑ Phone number
✑ Photo
You need to create a table to meet the requirements.
Match the Structured Query Language SQL statements to the SQL query.
Instructions: To answer, drag the appropriate SQL statement from the column on the left to its place in the SQL query on the right. Each SQL statement may be used once, more than once, or not at all. Each correct match is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A
You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department. What should you apply to the Employee table?
Correct Answer:
C
