Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... UPDATE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The result of a SQL SELECT statement is a ________ . report table file form report table file form ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL If a query involves NOT, AND, OR with no parenthesis AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. AND will be evaluated first; OR will be evaluated second; NOT will be evaluated last. The order of occurrence determines the order of evaluation. NOT will be evaluated first; OR will be evaluated second; AND will be evaluated last. NOT will be evaluated first; AND will be evaluated second; OR will be evaluated last. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to sort the result-set? ORDER ORDER BY SORT SORT BY ORDER ORDER BY SORT SORT BY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? 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 To define the data structures To specify the syntax and semantics of SQL data definition language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Materialized Views Data Integrity Normalization All of these Materialized Views Data Integrity Normalization All of these ANSWER DOWNLOAD EXAMIANS APP