Introduction to SQL ON UPDATE CASCADE ensures which of the following? Normalization Data Integrity Materialized Views All of these Normalization Data Integrity Materialized Views All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT APPEND ADD UPDATE INSERT APPEND ADD UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 045.926 prints 50 is illegal prints garbage prints 045.926 prints 50 is illegal prints garbage ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NON-EQUIJOIN EQUIJOIN OUTER JOIN NATURAL JOIN NON-EQUIJOIN EQUIJOIN OUTER JOIN NATURAL JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 5 10 9 0 5 10 9 0 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS