Introduction to SQL Which SQL statement is used to delete data FROM a database? ALTER DELETE COLLAPSE REMOVE ALTER DELETE COLLAPSE REMOVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL is: an operating system. a programming language. a data sublanguage. a DBMS. an operating system. a programming language. a data sublanguage. a DBMS. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN EQUIJOIN NON-EQUIJOIN OUTER JOIN NATURAL JOIN EQUIJOIN NON-EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? UPPER MOST MAX TOP UPPER MOST MAX TOP 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 The SQL keyword(s) ________ is used with wildcards. LIKE only NOT IN only IN and NOT IN IN only LIKE only NOT IN only IN and NOT IN IN only ANSWER DOWNLOAD EXAMIANS APP