Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE DELETE COMMIT ROLLBACK TRUNCATE DELETE COMMIT ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER COLLAPSE DELETE REMOVE ALTER COLLAPSE DELETE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Selection operation. Join operation. Rename operation. Projection operation. Selection operation. Join operation. Rename operation. Projection operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the temperature in increasing order of all cities SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; SELECT city FROM weather ORDER BY temperature; SELECT city, temperature FROM weather ORDER BY temperature; SELECT city, temperature FROM weather; SELECT city, temperature FROM weather ORDER BY city; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: All of these query database data only. modify database data only. create database structures only. All of these query database data only. modify database data only. create database structures only. ANSWER DOWNLOAD EXAMIANS APP