Introduction to SQL Which SQL statement is used to update data in a database? MODIFY SAVE AS SAVE UPDATE MODIFY SAVE AS SAVE UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? None of these SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Hi TRUE Nothing FLASE Hi TRUE Nothing FLASE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE 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
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . report file table form report file table form ANSWER DOWNLOAD EXAMIANS APP