Introduction to SQL In SQL, which of the following is not a data definition language commands? GRANT REVOKE RENAME UPDATE GRANT REVOKE RENAME UPDATE 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); None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; Both A and B SELECT name FROM staffinfo WHERE salary IN (10000, 25000); None of these SELECT name FROM staffinfo WHERE salary BETWEEN 10000 AND 25000; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following must be enclosed in double quotes? Column Alias All of these Dates Strings Column Alias All of these Dates Strings ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? MAX COUNT SUM All of these MAX COUNT SUM All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS