Introduction to SQL The FROM SQL clause is used to... None of these specify what table we are selecting or deleting data FROM specify search condition specify range for search condition None of these specify what table we are selecting or deleting data FROM specify search condition specify range for search condition ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return exactly 10 rows less than 10 rows None of these more than 10 rows exactly 10 rows less than 10 rows None of these more than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? All of these To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language All of these To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language 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 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; Both A and B ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DIFFERENT UNIQUE DISTINCT DISTINCTIVE DIFFERENT UNIQUE DISTINCT DISTINCTIVE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS