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. all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. None of these all columns of the table are to be returned. all records with even partial criteria met are to be returned. all records meeting the full criteria are to be returned. None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL query is correct for selecting the name of staffs from 'staffinfo' table where salary is 10,000 or 25,000? SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; Both A and B None of these SELECT name FROM staffinfo WHERE salary IN (10000, 25000); SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; Both A and B None of these SELECT name FROM staffinfo WHERE salary IN (10000, 25000); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the correct order of keywords for SQL SELECT statements? SELECT,WHERE,FROM WHERE, FROM,SELECT SELECT, FROM, WHERE FROM, WHERE, SELECT SELECT,WHERE,FROM WHERE, FROM,SELECT SELECT, FROM, WHERE FROM, WHERE, SELECT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The keyword LIKE can be used in a WHERE clause to refer to a range of values. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 9 5 0 10 9 5 0 10 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement. True False True False ANSWER DOWNLOAD EXAMIANS APP