Introduction to SQL In SQL, which command is used to change a table's storage characteristics? ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ALTER TABLE None of these CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. 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 prints garbage is illegal prints 045.926 prints 50 prints garbage is illegal ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has more than two 0's Feature ends with two 0's Feature begins with two 0's Feature has two 0's in it, at any position Feature has more than two 0's Feature ends with two 0's Feature begins with two 0's Feature has two 0's in it, at any position 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
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS