Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. False True False True 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 Which of the following do you need to consider when you make a table in SQL? Primary keys Data types Default values All of these Primary keys Data types Default values All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? JOIN LEN LEFT AVG JOIN LEN LEFT AVG ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DISTINCTIVE UNIQUE DIFFERENT DISTINCT DISTINCTIVE UNIQUE DIFFERENT DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS