OMIS 452 Quiz 7 (Lynda.com) Questions and Answers

OMIS 452 Quiz 7 (Lynda.com) Questions and Answers

Save
3

Practice questions for this set


Learn 1 /7 Study with Learn




How would you cause a long list of inserts or updates to perform much faster?



Choose an answer



by wrapping them in a START
1 by shortening the list 2
TRANSACTION; UPDATE;



by wrapping them in a START
3 by wrapping them in tin foil 4
TRANSACTION; ROLLBACK;



by wrapping them in a START
5
TRANSACTION; COMMIT;

, Don't know?




Terms in this set (23)


Which SELECT statement c.
correctly returns only 10 rows? SELECT * FROM Country ORDER BY Name Limit 10;


a.
SELECT * FROM Country
ORDER BY Name Show 10;
b.
SELECT * FROM Country
ORDER BY Name List 10;
c.
SELECT * FROM Country
ORDER BY Name Limit 10;
d.
SELECT Top 10 FROM Country
ORDER BY Name;
e.
SELECT * FROM Country
ORDER BY Name OFFSET 10;