Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: limits the row data are returned. Neither A nor B are correct. Both A and B are correct. limits the column data that are returned. limits the row data are returned. Neither A nor B are correct. Both A and B are correct. limits the column data that are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To sort the results of a query use: SORT BY. ORDER BY. GROUP BY. None of these SORT BY. ORDER BY. GROUP BY. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? AVG JOIN LEN LEFT AVG JOIN LEN LEFT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? MODIFY UPDATE SAVE SAVE AS MODIFY UPDATE SAVE SAVE AS ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. False True False True ANSWER DOWNLOAD EXAMIANS APP