Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin Equijoin None of these Self-Join Non-Equijoin Equijoin None of these Self-Join ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? All of these NUMERIC FLOAT CHARACTER All of these NUMERIC FLOAT CHARACTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The Microsoft Access wildcards are ____ and ____ . asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) asterisk (*); percent sign (%) underscore(_); question mark (?) percent sign (%); underscore (_) question mark (?); asterisk (*) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP