Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as 0 for integer not a value the same as 0 for integer and blank for character the same as blank for character the same as 0 for integer not a value the same as 0 for integer and blank for character the same as blank for character ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Both A and B are correct. limits the row data are returned. limits the column data that are returned. Neither A nor B are correct. Both A and B are correct. limits the row data are returned. limits the column data that are returned. Neither A nor B are correct. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS