your understanding is correct. for test coverage you'd better check with
course syllubus or test guidelines. for example and for your reference, you
can take a look at this site (although this site's tests and certifications
have little authority). http://brainbench.com/xml/bb/common/testcenter/taketest.xml?testId=38
also there are a variety of SQL. however fundementals are same.