Introduction to SQL In SQL, which of the following is not a data definition language commands? GRANT REVOKE RENAME UPDATE GRANT REVOKE RENAME UPDATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ________ was adopted as a national standard by ANSI in 1992. DBase SQL Microsoft Access Oracle DBase SQL Microsoft Access Oracle ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve only unique values? DIFFERENT DISTINCT UNIQUE DISTINCTIVE DIFFERENT DISTINCT UNIQUE DISTINCTIVE 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 9 10 5 0 9 10 5 0 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users None of these SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users None of these ANSWER DOWNLOAD EXAMIANS APP