Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL How to select all data from student table starting the name from letter 'r'? SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r'; SELECT * FROM student WHERE name LIKE '_r%'; SELECT * FROM student WHERE name LIKE '%r%'; SELECT * FROM student WHERE name LIKE 'r%'; SELECT * FROM student WHERE name LIKE '%r'; SELECT * FROM student WHERE name LIKE '_r%'; SELECT * FROM student WHERE name LIKE '%r%'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('abcdefghij', INSTR('123321234', '2', 3, 2), 2) FROM DUAL;prints bc gh 23 ab bc gh 23 ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT statement SELECT 'Hi' FROM DUAL WHERE NULL = NULL; Outputs Nothing FLASE Hi TRUE Nothing FLASE Hi TRUE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Microsoft Access has become ubiquitous, and being able to program in Access is a critical skill. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username AND Password FROM Users SELECT Username, Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' SELECT Username AND Password FROM Users SELECT Username, Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS