WGU C170 Basic SQL, Top Exam Questions and answers, 100% Accurate.

Document Content and Description Below

WGU C170 Basic SQL, Top Exam Questions and answers, 100% Accurate. 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 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 The SQL command that allows a user to list the contents of a table is _____________. - ✔✔-SELECT The SQL aggregate function that gives the number of rows containing non-null values for a given column is ______________. - ✔✔-COUNT You cannot insert a row containing a null attribute value using SQL. - ✔✔-FALSE All changes in a table structure are made using the ____________________ command, followed by a keyword that produces the specific changes a user wants to make. - ✔✔-ALTER TABLE SQL is considered difficult to learn; its command set has a vocabulary of more than 300 words. - ✔✔- FALSE Some RDBMSs, such as Oracle, automatically _______________ data changes when issuing data definition commands. - ✔✔-COMMIT The special operator used to check whether an attribute value matches a given string pattern is _________ - ✔✔-LIK [Show More]

Last updated: 2 years ago

Preview 1 out of 10 pages