Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND ADD INSERT UPDATE APPEND ADD INSERT UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? EXISTS operator IS NULL operator NOT operator None of these EXISTS operator IS NULL operator NOT operator None of these 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 23 gh bc ab 23 gh bc ab ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement that queries or reads data from a table is ________ . READ None of these SELECT QUERY READ None of these SELECT QUERY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. False True False True ANSWER DOWNLOAD EXAMIANS APP