You have the following table:
Instructions: Use the drop-down menus to select the answer choice that completes each statement. Each correct selection is worth one point.
Hot Area:
Hot Area:
You have two database tables as defined below. The first table contains information about students. The second table contains information about courses. The two tables are related by CourseID.
Match the CourseName to the StudentName.
Instructions: To answer, drag the appropriate CourseName from the column on the left to its StudentName on the right. Each CourseName may be used once, more than once, or not at all. Each correct match is worth one point.
Select and Place:
You are structuring a table in a relational database.
Instructions: For each of the following statement, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Hot Area:
You have the following table definition:
CREATE TABLE Road (RoadID INTEGER NOT NULL, Distance INTEGER NOT NULL)
The Road table contains the following data: You execute the following statement: INSERT INTO Road VALUES (1234, 36)
What is the result?
A. an error stating that NULL values are not allowed
B. a new row in the table
C. an error stating that duplicate IDs are not allowed
D. a syntax error
You have a table named Product. You create a view that includes all the products from the Product table that are in the Furniture category.
You execute a statement on the Product table that deletes all the products in the Furniture category.
After you execute the statement, the result set of the view is:
A. Empty
B. Deleted
C. Unchanged
D. Archived
In SQL, an insert statement is used to add a:
A. User to a database.
B. Row of data to a table.
C. Table to a database.
D. Column to a table definition.
The component that holds information for a single entry in a table is called a:
A. Data type
B. Row
C. Column D. View
You need to disable User1's access to view the data in the Customer table.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
This question requires that you evaluate the underlined text to determine if it is correct.
In a database table, each column represents a unique record.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
A. No change is needed
B. Table
C. Index
D. Row
This question requires that you evaluate the underlined text to determine if it is correct.
A row holds information for a single record in a table.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
A. No change is needed
B. Column
C. Data type
D. View
