Introduction to SQL SELECT DISTINCT is used if a user wishes to see duplicate columns in a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Equijoin Non-Equijoin None of these Self-Join Equijoin Non-Equijoin None of these Self-Join ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT SUBSTR('123456789', INSTR('abcabcabc', 'b'), 4) FROM DUAL; 6789 1234 2345 456789 6789 1234 2345 456789 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. LIKE only IN and NOT IN NOT IN only IN only LIKE only IN and NOT IN NOT IN only IN only ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS