Introduction to SQL The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a 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? None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; SELECT name FROM staffinfo WHERE salary IN (10000, 25000); Both A and B ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? FLOAT All of these CHARACTER NUMERIC FLOAT All of these CHARACTER NUMERIC ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? CREATE INSERT ADD MAKE CREATE INSERT ADD MAKE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The condition in a WHERE clause can refer to only one value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following query is correct for using comparison operators in SQL? SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and <80; None of these SELECT name, course_name FROM student WHERE age>50 and WHERE age<80; SELECT name, course_name FROM student WHERE age>50 and age <80; SELECT name, course_name FROM student WHERE age>50 and <80; None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS