Introduction to SQL Which of the following is a SQL aggregate function? AVG JOIN LEFT LEN AVG JOIN LEFT LEN 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
Introduction to SQL What is the full form of SQL? None of these Structured Query Language Structured Query List Simple Query Language None of these Structured Query Language Structured Query List Simple Query Language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? CHARACTER NUMERIC All of these FLOAT CHARACTER NUMERIC All of these FLOAT 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 IN (10000, 25000); None of these Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these Both A and B SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS