patternsqlMinor
What do these statements mean in the MS β exam 70-461 "skills measured" list?
Viewed 0 times
skillsthesethewhatstatementsmeanexam461measuredlist
Problem
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:
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?
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?
Solution
- DML - refers to data manipulation (update, insert, delete). A DML trigger is a trigger created to happen on update, insert or delete of table data.
The update function is the part of a DML trigger where you test if a required update has occured.
For Example:
CREATE TRIGGER myupdate_trigger
ON mytable
FOR UPDATE AS
if UPDATE(column_1)
BEGIN
-- Do something
ENDThis will trigger a further action every time column column_1 is updated in table mytable. The update function is UPDATE(column_1).
Code Snippets
CREATE TRIGGER myupdate_trigger
ON mytable
FOR UPDATE AS
if UPDATE(column_1)
BEGIN
-- Do something
ENDContext
StackExchange Database Administrators Q#15887, answer score: 4
Revisions (0)
No revisions yet.