WGU C170 Data Management

WGU C170 questions with verified answers.

WGU C170 questions with verified answer1

_____ functions extract a value of a given data type and convert it to the equivalent value in another data type. Ans-Conversion _____ is a relational set operator. Ans-MINUS _____ is a string function that returns the number of characters in a string value. Ans-LENGTH "Union compatible" means that the _____. Ans-names of the relation attributes can be different, but the data types must be alike A _____ is a query inside a query. Ans-subquery A _____ join returns rows with m...

Data Management Applications questions with verified answers.

ABS Ans-Returns the absolute value of a number Access plan Ans-A set of instructions generated at application compilation time that is created and managed by a DBMS. It predetermines how an application's query will access the database at run time. Also called an execution plan. ADD_MONTHS Ans-Oracle function that adds a number of months or years to a date ADDDATE Ans-MYSQL function that adds a number of days to a date ALL operator Ans-Allows comparison of a single value with a lis...

WGU C170 Chp 1 questions with verified answers.

WGU C170 Basic SQL Questions with verified answers.

Sales order 1NF WGU C170 Data Management - Applications Performance Assessment. EXPLANATION: I am going to call this table the "Order Table" I also need to make sure that this table contains a primary Key, in this particular table I am going to make the “OrderID” and “DonutID” the Primary Key (composite key), the reason I chose to use OrderID and DonutID as the primary key is because Order ID or DonutID by themselves do not guarantee Uniqueness but when combined uniqueness is...

WGU C170 - Data Management – Applications, 100% Accurate. VERIFIED. Access plan - -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 - -An alternative name for a column or table in a SQL statement. ALTER TABLE - -The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it a...