An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. Correct Answer: recursive
The ___________ condition is generally composed of an equality comparison between the f
...
An alias is especially useful when a table must be joined to itself in a(n) ___________________ query. Correct Answer: recursive
The ___________ condition is generally composed of an equality comparison between the foreign key and the primary key of related tables. Correct Answer: join
A database language enables the user to create database and table structures to perform basic data management chores. Correct Answer: TRUE
______________________ is the process the DBMS uses to verify that only registered users access the database. Correct Answer: Authentication
Only numeric data types can be added and subtracted in SQL. Correct Answer: FALSE
A table can be deleted from the database by using the _______________________ command. Correct Answer: DROP TABLE
To list all the contents of the PRODUCT table, a user would use ________________________________ Correct Answer: SELECT * FROM PRODUCT
All SQL commands must be issued on a single line. Correct Answer: FALSE
Mathematical operators cannot be used to place restrictions on character-based attributes. Correct Answer: FALSE
A(n) _____________________ is a query that is embedded (or nested) inside another query. Correct Answer: 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 ________________________________________________ Correct Answer: "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. Correct Answer: query
The SQL aggregate function that gives the total of all values for a selected attribute in a given column is _______ Correct Answer: SUM
String comparisons
[Show More]