WGU C170 Data Management – Applications Exam Questions with Correct Answers

Create Database Syntax Correct Answer CREATE DATABASE db_name; Simple SFW query syntax Correct Answer SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? Correct Answer Outside Modality: Inside or outside? Correct Answer Inside What commands are used w...

Add New Row Correct Answer INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row Correct Answer UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row Correct Answer DELETE FROM table_name WHERE condition; Inn...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary Correct Answer Many-to-many Which two examples are attributes? Ch...

Access plan Correct Answer A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias Correct Answer An alternative name for a column or table in a SQL...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? Correct Answer Many-to-many Which two examples are attributes? Correct Answer An employee number; A meeting code Which delete rul...