Introduction to SQL The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 The command to eliminate a table from a database is: UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; DROP TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which one of the following sorts rows in SQL? SORT BY ALIGN BY GROUP BY ORDER BY SORT BY ALIGN BY GROUP BY ORDER BY 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 > ANY (SELECT SALARY FROM EMPLOYEE);prints 10 0 5 9 10 0 5 9 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS