Database Section 1
Properties of DELET and TRUNCATE commands indicate that |
||||||||
Answer: D Details: After the execution of DELETE operation, COMMIT and ROLLBACK statements can be performed to retrieve the lost data., while TRUNCATE do not allow it |
Which of the following statements are TRUE about an SQL query? I: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause II: An SQL query can contain a HAVING clause only if it has a GROUP BY clause III: All attributes used in the GROUP BY clause must appear in the SELECT clause IV: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause |
||||||||
Answer: C Details: II and III |