Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only NOT IN only IN only IN and NOT IN LIKE only NOT IN only IN only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password FROM Users None of these SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users None of these SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? GROUP BY ALIGN BY ORDER BY SORT BY GROUP BY ALIGN BY ORDER BY SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 456789 6789 2345 1234 456789 6789 2345 1234 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? None of these Non-Equijoin Self-Join Equijoin None of these Non-Equijoin Self-Join Equijoin ANSWER DOWNLOAD EXAMIANS APP