Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return None of these more than 10 rows exactly 10 rows less than 10 rows None of these more than 10 rows exactly 10 rows less than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? Applications are not needed Reduced training costs Increased dependence on a single vendor All of these Applications are not needed Reduced training costs Increased dependence on a single vendor All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS