Introduction to SQL Which of the following command makes the updates performed by the transaction permanent in the database? ROLLBACK TRUNCATE DELETE COMMIT ROLLBACK TRUNCATE DELETE COMMIT 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 In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE CHANGE TABLE All of these ALTER TABLE MODIFY TABLE CHANGE TABLE All of these ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DML XML DDL HTML DML XML DDL HTML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin Equijoin Self-Join None of these Non-Equijoin Equijoin Self-Join None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands is used to retrieve data? DELETE SELECT JOIN INSERT DELETE SELECT JOIN INSERT ANSWER DOWNLOAD EXAMIANS APP