Introduction to SQL Which operator performs pattern matching? None of these EXISTS operator BETWEEN operator LIKE operator None of these EXISTS operator BETWEEN operator LIKE operator ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK DELETE COMMIT TRUNCATE ROLLBACK DELETE COMMIT TRUNCATE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; CREATE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; REMOVE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin Self-Join None of these Equijoin Non-Equijoin Self-Join None of these Equijoin ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? INSERT APPEND ADD UPDATE INSERT APPEND ADD UPDATE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS