Introduction to SQL Which of the following SQL commands is used to retrieve data? JOIN SELECT INSERT DELETE JOIN SELECT INSERT DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys Default values All of these Data types Primary keys Default values All of these Data types 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. EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN EQUIJOIN NATURAL JOIN NON-EQUIJOIN OUTER JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? UNIQUE DISTINCT DISTINCTIVE DIFFERENT UNIQUE DISTINCT DISTINCTIVE DIFFERENT 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 wildcard in a WHERE clause is useful when? An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement. An exact match is necessary in a SELECT statement. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS