SQL Final questions with complete solutions

(T or F) - A relationship is the association between attributes. CORRECT ANSWERS: True (T or F) - Columns are also called records. CORRECT ANSWERS: False (T or F) - Data can be viewed by using the UPDATE command. CORRECT ANSWERS: False (T or F) - The CHARINDEX function finds a position of specified character. CORRECT ANSWERS: True (T or F) - Wildcard character "_" identifies any number of characters. CORRECT ANSWERS: False (T or F) - Primary Key allows NULL value. CORRECT ANSWERS: False (T or F) - A DELETE query may change the number of columns in a table. (Rows only) CORRECT ANSWERS: False (T or F) - An INSERT statement always requires the field names in its syntax. CORRECT ANSWERS: False In the UPDATE command, the ____ clause assigns the value to the field. CORRECT ANSWERS: SET The HAVING clause can be used to ____. CORRECT ANSWERS: restrict conditions on groups Which symbol is used for the "not equal to" operator? CORRECT ANSWERS: <> != If conditions in your query evaluate to the following values: FALSE AND FALSE What will be the result? CORRECT ANSWERS: False How many tables in a database would you need to define referential integrity rules? CORRECT ANSWERS: At least two Consider the following query: SELECT * FROM SOMETABLE WHERE SOMECOLUMN LIKE '%_XXX' OR SOMECOLUMN NOT LIKE '%_XXX'; If SOMECOLUMN contains the TPA_XXX! value, will it retrieve the row with this value? CORRECT ANSWERS: YES (T or F) If conditions in your query evaluate to the following values: CORRECT ANSWERS: False To remove data from a table, you would use the ____ command. CORRECT