Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 2345 456789 1234 6789 2345 456789 1234 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which operator performs pattern matching? BETWEEN operator None of these EXISTS operator LIKE operator BETWEEN operator None of these EXISTS operator LIKE operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL COUNT(field_name) tallies only those rows that contain a value; it ignores all null values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? DELETE ALTER COLLAPSE REMOVE DELETE ALTER COLLAPSE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that: all columns of the table are to be returned. None of these all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. all columns of the table are to be returned. None of these all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS