Q1. Which statement is true? Select * from dbo.menu where ItemType = Hamburger order
Q1. Which statement is true?
Select * from dbo.menu where ItemType = 'Hamburger' order by ItemType descen
Select * from dbo.menu where ItemType = 'Hamburger' order by ItemType desc
Select * from dbo.menu order by ItemType desc where ItemType = 'Hamburger'
Select * from dbo.menu order by ItemType descending where ItemType = 'Hamburger'
order by ItemType desc Select * from dbo.menu where ItemType = 'Hamburger'
Q2. Which statement is correct?
DELETE * FROM dbo.Menu WHERE WeelySales < 5000
DELETE * FROM dbo.Menu SET WeelySales < 5000
DELETE FROM dbo.Menu WHERE WeelySales < 5000
DELETE * FROM dbo.Menu HAVING WeelySales < 5000
DELETE WeeklySales FROM dbo.Menu WHERE WeelySales < 5000
Q3. Which statement is correct?
SELECT ItemType,ItemType FROM dbo.Menu HAVING ItemType > 1 WHERE ItemType IS NOT NULL GROUP BY ItemType ORDER BY ItemType
SELECT ItemType,ItemType FROM dbo.Menu WHERE ItemType IS NOT NULL HAVING ItemType > 1 GROUP BY ItemType ORDER BY ItemType
SELECT ItemType,ItemType FROM dbo.Menu WHERE ItemType IS NOT NULL GROUP BY ItemType HAVING ItemType > 1 ORDER BY ItemType
SELECT ItemType,ItemType FROM dbo.Menu WHERE ItemType IS NOT NULL GROUP BY ItemType ORDER BY ItemType HAVING ItemType > 1
SELECT ItemType,ItemType HAVING ItemType > 1 FROM dbo.Menu WHERE ItemType IS NOT NULL GROUP BY ItemType HAVING ItemType > 1 ORDER BY ItemType
Q4. Which one of the following is true?
TRUNCATE is a logged operation on a per-row basis
You can TRUNCATE a table that has foreign key constraints
DELETE will reset any identity columns to the default seed value
DELETE is a faster operation to perform over TRUNCATE
TRUNCATE logs the deallocation of the data pages in which the data exists
Q5. Which statement is correct?
UPDATE dbo.menu SET ItemName = '8 layer Burrito' WHERE ItemName = '7 layer Burrito'
UPDATE dbo.menu SELECT ItemName = '8 layer Burrito' WHERE ItemName = '7 layer Burrito'
UPDATE dbo.menu SET '8 layer Burrito' = ItemName WHERE '7 layer Burrito' = ItemName
UPDATE dbo.menu SELECT '8 layer Burrito' = ItemName WHERE '7 layer Burrito' = ItemName
Q6. Which Statement is usually only used in conjunction with the GROUP BY Clause?
WHERE
SELECT
ORDER BY
HAVING
DELETE
Q7. Which Statement can NOT be used with the WHERE Clause?
SELECT
TRUNCATE
DELETE
UPDATE
HAVING
Q8. Which Clause is executed before the others?