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 Which of the following do you need to consider when you make a table in SQL? Data types All of these Default values Primary keys Data types All of these Default values Primary keys ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 1234 2345 6789 456789 1234 2345 6789 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT APPEND UPDATE ADD INSERT APPEND UPDATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP