Introduction to SQL Which of the following must be enclosed in double quotes? Column Alias All of these Dates Strings Column Alias All of these Dates Strings ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username, Password FROM Users SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' None of these SELECT Username, Password FROM Users SELECT Username AND Password FROM Users ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. True False True False 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 0 10 9 5 0 10 9 5 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS