Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False 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? Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: has a distinct form that cannot be duplicated by a join. can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. has a distinct form that cannot be duplicated by a join. can only be used with two tables. can always be duplicated by a join. cannot have its results sorted using ORDER BY. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? DELETE TRUNCATE COMMIT ROLLBACK DELETE TRUNCATE COMMIT ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? SUM MAX All of these COUNT SUM MAX All of these COUNT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes may be created or dropped at any time. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS