Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? COMMIT ROLLBACK TRUNCATE DELETE COMMIT ROLLBACK TRUNCATE DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin None of these Self-Join Equijoin Non-Equijoin None of these Self-Join Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What operator tests column for the absence of data? EXISTS operator None of these NOT operator IS NULL operator EXISTS operator None of these NOT operator IS NULL operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL data definition commands make up a(n) ________ . DML DDL XML HTML DML DDL XML HTML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. False True False True ANSWER DOWNLOAD EXAMIANS APP