I have registered for the upcoming beta exam 70-461 entitled Querying Microsoft SQL Server 2012.
I've been reading through the exam overview and found a bunch of descriptions I'm not exactly sure what some of the items mean:
- Create and alter DML triggers.
- This objective may include but is not limited to: inserted and deleted tables; nested triggers; types of triggers; update functions; handle multiple rows in a session; performance implications of triggers
- Query data by using SELECT statements.
- This objective may include but is not limited to: use the ranking function to select top(X) rows for multiple categories in a single query; write and perform queries efficiently using the new code items such as synonyms and joins (except, intersect); implement logic which uses dynamic SQL and system metadata; write efficient, technically complex SQL queries, including all types of joins versus the use of derived tables; determine what code may or may not execute based on the tables provided; given a table with constraints, determine which statement set would load a table; use and understand different data access technologies; CASE versus ISNULL versus COALESCE
The problem here I think is with the wording, which I think I'm not able to fully understand.
If someone could clarify these I'd be most grateful.
To put it as an actual question:
What is Microsoft talking about on the above highlighted statements?