Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Default values Primary keys Data types All of these Default values Primary keys Data types All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? SAVE AS SAVE UPDATE MODIFY SAVE AS SAVE UPDATE MODIFY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? JOIN LEFT LEN AVG JOIN LEFT LEN AVG ANSWER DOWNLOAD EXAMIANS APP
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 There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP