Introduction to SQL Which of the SQL statements is correct? 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' SELECT Username, Password FROM Users None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a(n) ________ . file report form table file report form table ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? UNIQUE DISTINCT DIFFERENT DISTINCTIVE UNIQUE DISTINCT DIFFERENT DISTINCTIVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints 23 bc ab gh 23 bc ab gh ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL manipulation language To define the data structures To specify the syntax and semantics of SQL data definition language All of these To specify the syntax and semantics of SQL manipulation language To define the data structures To specify the syntax and semantics of SQL data definition language All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS