Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? All of these Data types Default values Primary keys All of these Data types Default values Primary keys ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE REMOVE COLLAPSE ALTER DELETE REMOVE COLLAPSE ALTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is a programming language. True False True False ANSWER DOWNLOAD EXAMIANS APP