A constraint that uniquely identifies each row in a table
What is a PRIMARY KEY
100
The type of constraint that provides a value if none is given when a row is inserted.
What is DEFAULT
100
This is required if you need the rows in your select to be returned in sequence.
What is ORDER BY
100
The tool capable of watching SQL Server and returning the text of each query run against it.
What is SQL Profiler or Extended Events
200
The most efficient datatype to hold positive whole number values ranging from 1,000 to 1,000,000,000
What is int
200
The number of primary key constraints that a table may have.
What is 1
200
The type of constraint that limits the domain of a column beyond that provided by the datatype.
What is CHECK
200
If selects against your view are performing poorly, consider converting it to this, assuming changes to the data underneath the view are infrequent.
What is an INDEXED VIEW
200
The statement that allows rows from a table to be either inserted, updated or deleted based on the results of a separate query.
What is MERGE
300
The deprecated datatype replaced by varchar(max)
What is text
300
The keyword used when creating a foreign key that indicates that an action taken on the primary key should also be taken on any foreign key references.
What is CASCADE
300
The type of constraint you would use if you wanted to ensure that no two patients had the same patient number.
What is UNIQUE
300
The statement that removes all the rows from a table, ignoring any triggers that might exist.
What is TRUNCATE TABLE
300
Examine this to determine if an index was used during the execution of your query
What is a Query Plan
400
The best datatype to hold lattitude and longitude data
What is spatial or geography
400
The constraint property that must be set on every column that is part of a primary key
What is NOT NULL
400
This type of object can restrict DML based on the prior (old) values for the row(s) being changed.
What is a Trigger
400
Daily Double
The type of join needed if you want all of the patient information and the address for each patient (if they have an address, they might not!).
400
The number of the Microsoft Exam titled "Querying Microsoft SQL Server 2012"
What is 70-461
500
The best datatype to hold a GUID
What is uniqueidentifier
500
The four responses that can automatically be taken on a foreign key row when it's associated primary key row is deleted.
What is CASCADE, SET NULL, SET DEFAULT, NO ACTION
500
Daily Double
The keyword used when creating a view to ensure that changes to the table are not allowed if it would invalidate the view.
500
The operand used between two complete and independent select queries to return only the rows that exist in both.
(Also the name of the special computer in Chuck Bartowski's head)
What is INTERSECT
500
One of the two characters in addition to percent (%) and open/close brackets ([]) that have special meaning in a LIKE statement