WGU C170 Basic SQL Questions and Answers 100% correct 2023

WGU C170 Basic SQL Questions and Answers 100% correct 2023 An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. recursive The ___________ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables. join Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:12 / 0:15 Full screen A database language enables the user to create database and table structures to perform basic data management chores. TRUE ______________________ is the process the DBMS uses to verify that only registered users access the database. Authentication Only numeric data types can be added and subtracted in SQL. FALSE A table can be deleted from the database by using the _______________________ command. DROP TABLE To list all the contents of the PRODUCT table, a user would use ________________________________ SELECT * FROM PRODUCT All SQL commands must be issued on a single line. FALSE Mathematical operators cannot be used to place restrictions on character-based attributes. FALSE A(n) _____________________ is a query that is embedded (or nested) inside another query. subquery "The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ________________________________________________ "SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;" In the SQL environment, the word ___________ covers both questions and actions. query The SQL aggregate function that gives the total of all values for a selected attribute in a given column is _______ SUM String comparisons are made from left to right. TRUE Date procedures are often more software-specific than other SQL procedures. TRUE To make the output more readable, the SQL standard permits the use of aliases for any column in a _____________ statement. SELECT A(n) _________________ order sequence is a multilevel ordered sequence that can be created easily by listing several attributes, separated by commas, after the ORDER BY clause. cascading Data type selection is usually dictated by the nature of the data and by the intended use. TRUE The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07. FALSE The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause. TRUE Which of the following queries will use the given columns and column aliases from the PRODUCT table to determine the total value of inventory held on hand? "SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT;" A database language enables the user to perform complex queries designed to transform the raw data into useful information. TRUE DATE() and SYSDATE are special functions that return today's date in MS Access and __________________, respectively. Oracle Which of the following queries will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1? "SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE FROM PRODUCT WHERE P_CODE '1558-QW1';"