Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 50 prints garbage is illegal prints 045.926 prints 50 prints garbage is illegal prints 045.926 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To define the data structures To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language All of these To define the data structures To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False 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
Introduction to SQL The SQL WHERE clause: Both A and B are correct. limits the row data are returned. Neither A nor B are correct. limits the column data that are returned. Both A and B are correct. limits the row data are returned. Neither A nor B are correct. limits the column data that are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS