WGU D427 Practice Test with Answer Key 2024.

WGU D427 Practice Test with Answer Key 2024. 1. Seattle, WA 98111 USA How many attributes are present in the address fragment? a. 1 b. 2 c. 3 d. 4 2. The Book table has the following columns: genre – varchar(20) pages – integer author_id – char(3) isbn_number – varchar(20) Which column should be designated at the primary key for the Book table? a. genre b. pages c. author_id d. isbn_number 3. The Book table has the following columns: genre – varchar(20) pages – integer author_id – char(3) isbn_number – varchar(20) Which column should be designated at the foreign key for the Book table? a. genre b. pages c. author_id d. isbn_number 4. Which data type represents numbers with fractional values: a. Integer b. Decimal c. Character d. Binary 5. Which of the following are DDL commands? a. INSERT b. SELECT c. CREATE INDEX d. UPDATE 6. Which of the following is a DML command? a. CREATE VIEW b. CREATE TABLE c. INSERT d. ALTER INDEX 7. CREATE TABLE Invoice ( invoice_id INT NOT NULL AUTO_INCREMENT, date DATE NOT NULL, customer_id INT NOT NULL, PRIMARY KEY (invoice_id), FOREIGN KEY (customer_id) REFERENCES Customer (customer_id) ON DELETE CASCADE ); Looking at the Customer and Invoice tables and the CREATE TABLE for the Invoice table with foreign key reference statement above, what would happen to invoices in the Invoice table that are linked to a customer if that customer is deleted. a. Those invoices would remain in the database. b. Those invoices would be deleted also. c. The Customer ID for those invoices would be changed to NULL. d. Nothing would happen. Invoice ID (PK) Date Customer ID (FK) Customer ID (PK) Customer Last Name Customer First Name Street Address City State Zip 8. CREATE TABLE Invoice ( invoice_id INT NOT NULL AUTO_INCREMENT, date DATE NOT NULL, customer_id INT NOT NULL, PRIMARY KEY (invoice_id), FOREIGN KEY (customer_id) REFERENCES Customer (customer_id) ON DELETE RESTRICT ); Looking at the Customer and Invoice tables and the CREATE TABLE for the Invoice table with foreign key reference statement above, what would happen to invoices in the Invoice table that are linked to a customer if that customer is deleted. a. Those invoices would remain in the database. b. Those invoices would be deleted also. c. The Customer ID for those invoices would be changed to NULL. d. The delete of the Customer would not be allowed. 9. CREATE TABLE Invoice ( invoice_id INT NOT NULL AUTO_INCREMENT, date DATE NOT NULL, customer_id INT NOT NULL, Invoice ID (PK) Date Customer ID (FK) Customer ID (PK) Customer Last Name Customer First Name Street Address City State Zip PRIMARY KEY (invoice_id), FOREIGN KEY (customer_id) REFERENCES Customer (customer_id) ON DELETE SET TO NULL ); Looking at the Customer and Invoice tables and the CREATE TABLE for the Invoice table with foreign key reference statement above, what would happen to invoices in the Invoice table that are linked to a customer if that customer is deleted. e. Those invoices would remain in the database. f. Those invoices would be deleted also. g. The Customer ID for those invoices would be changed to NULL. h. The delete of the Customer would not be allowed. 10. Which of the following are true about materialized view (Choose 2)? a. It is a base table. b. It is stored. c. It must be refreshed whenever the base table changes. d. The results are stored as a temporary table. 11. The Customer table will have the following columns: CustomerID—positive integer Invoice ID (PK) Date Customer ID (FK) Customer ID (PK) Customer Last Name Customer First Name Street Address City State Zip .