Introduction to SQL 'AS' clause is used in SQL for Rename operation. Projection operation. Join operation. Selection operation. Rename operation. Projection operation. Join operation. Selection operation. 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. OUTER JOIN EQUIJOIN NON-EQUIJOIN NATURAL JOIN OUTER JOIN EQUIJOIN NON-EQUIJOIN NATURAL JOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? UPDATE SAVE SAVE AS MODIFY UPDATE SAVE SAVE AS MODIFY ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? COMMIT TRUNCATE DELETE ROLLBACK COMMIT TRUNCATE DELETE ROLLBACK ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is illegal? None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; None of these SELECT SYSDATE - (SYSDATE - 2) FROM DUAL; SELECT SYSDATE - (SYSDATE + 2) FROM DUAL; SELECT SYSDATE - SYSDATE FROM DUAL; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return exactly 10 rows None of these less than 10 rows more than 10 rows exactly 10 rows None of these less than 10 rows more than 10 rows ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS