WGU C170 Basic SQL Questions and Correct Answers/ Latest Update / Already Graded

An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. Ans: recursive The ___________ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables. Ans: join A database language enables the user to create database and table structures to perform basic data management chores. Ans: TRUE ______________________ is the process the DBMS uses to verify that only registered users access the database. Ans: Authentication Only numeric data types can be added and subtracted in SQL. Ans: FALSE A table can be deleted from the database by using the _______________________ command. Ans: DROP TABLE To list all the contents of the PRODUCT table, a user would use ________________________________ Ans: SELECT * FROM PRODUCT 2 | Page All SQL commands must be issued on a single line. Ans: FALSE Mathematical operators cannot be used to place restrictions on character-based attributes. Ans: FALSE A(n) _____________________ is a query that is embedded (or nested) inside another query. Ans: 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 ________________________________________________ Ans: "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. Ans: query The SQL aggregate function that gives the total of all values for a selected attribute in a given column is _______ Ans: SUM String comparisons are made from left to right. Ans: TRUE 3 | Page Date procedures are often more software-specific than other SQL procedures. Ans: TRUE To make the output more readable, the SQL standard permits the use of aliases for any column in a _____________ statement. Ans: 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. Ans: cascading Data type selection is usually dictated by the nature of the data and by the intended use. Ans: TRUE The ANSI prescribes a standard SQL-the current fully approved version is known as SQL 07. Ans: FALSE The COUNT function is designed to