Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE ALTER REMOVE COLLAPSE DELETE ALTER REMOVE COLLAPSE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? EXISTS operator None of these BETWEEN operator LIKE operator EXISTS operator None of these BETWEEN operator LIKE operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE AS SAVE MODIFY UPDATE SAVE AS SAVE MODIFY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 456789 6789 1234 2345 456789 6789 1234 2345 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? INSERT CREATE MAKE ADD INSERT CREATE MAKE ADD ANSWER DOWNLOAD EXAMIANS APP