WGU C170 Basic SQL questions and answers 2022

WGU C170 Basic SQL questions and answers 2022An 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 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';" The ____________________ command is used to restore the database to its previous condition. ROLLBACK; According to the rules of precedence, which of the following computations should be completed first? Performing operations within parentheses Which of the following queries will output the table contents when the value of V_CODE is equal to 21344? "SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;" Using the _____________________________ command, SQL indexes can be created on the basis of any selected attribute. CREATE INDEX A specialty field in mathematics, known as ________________ algebra, is dedicated to the use of logical operators. Boolean "The query used to list the P_CODE, P_DESCRIPT, P_INDATE, and P_PRICE fields from the PRODUCT table in ascending order by P_PRICE is ___________________________________________________" "SELECT P_CODE, P_DESCRIPT, P_INDATE, P_PRICE FROM PRODUCT ORDER BY P_PRICE;" Most SQL implementations yield case-insensitive searches. FALSE The _____________ constraint assigns a value to an attribute when a new row is added to a table. DEFAULT The SQL data manipulation command HAVING: ______________________________________________________. restricts the selection of grouped rows based on a condition. ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. TRUE The basic SQL vocabulary has fewer than ______ words. 100 The special operator used to check whether an attribute value is within a range of values is ____________ BETWEEN "The SQL query to output the contents of the EMPLOYEE table sorted by last name, first name, and initial is __________________________________________________ "SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE, EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME, EMP_INITIAL;" In a 1:M relationship, a user must always create the table for the ___ side first. 1 A table can be deleted from the database by using the ___________________________ command. DROP TABLE Which of the following queries will list all the rows in which the inventory stock dates occur on or after January 20, 2010? "SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDATE >= '20-JAN-2010';" To remove a row from the PRODUCT table, one must use the ___________________ command. DELETE When a user issues the DELETE FROM tablename command without specifying a WHERE condition, __________________________. all rows will be deleted Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components. TRUE When joining three or more tables, you need to specify a join condition for one pair of tables. FALSE An alias cannot be used when a table is required to be joined to itself in a recursive query. FALSE