Questionable Queries (SQL)
Soluble Solutions
Extensible Applications (XAML)
C Sharper
Programming Paradigms
100
These types of indexes control how the data for a table or view is physically stored.
What are clustered indexes?
100
This section in the client Custom.config file controls cloud mode.
What is the applicationServerClient section?
100
These resources may be used to transform one binding value into another.
What are converters?
100
This keyword allows for implicit variable typing.
What is var?
100
This design pattern describes only having one instance of a type.
What is Singleton?
200
Respectively, these are two types of concatenating data in SQL - one removes duplicates and the other doesn't.
What is UNION and UNION ALL, respectively.
200
These three locations are where the software searches for System and Custom config files.
What are the current directory (and one level up), LocalAppData, and ProgramData?
200
These types of properties are the kind that support Bindings.
What are DependencyProperties.
200
This term describes how an IEnumerable's contents is not evaluated until it is enumerated.
What is deferred execution?
200
This design pattern is used to create an object using a Func<>.
What is the factory pattern?
300
These are three different types of JOINs SQL may perform when deciding on an execution plan (not INNER/LEFT/RIGHT).
What are HASH, MERGE, and LOOP joins?
300
This class controls loading, editing and saving of the Custom and System config files.
What is the ConfigurationManager?
300
These types of objects are the only kind that allow declaring DependencyProperties.
What are DependencyObjects?
300
This type of construct is used for IDisposables and guarantees that Dispose will always be called.
What is are using block?
300
This design pattern is used when a constructor of a ViewService requests an instance of another type.
What is dependency injection?
400
This is the difference between varchar and nvarchar.
What is Unicode encoding?
400
These two classes initialize the IO application and presentation resources, respectively.
What are the Bootstrapper and PresentationBootstrapper?
400
These types of templates can be used within ItemsControls to control how each item is displayed.
What are DataTemplates?
400
These types can be used like function pointers and can be used to pass functions as variables.
What are delegates?
400
This design pattern is used to trick VB6 into thinking it's talking to ADODB when it's actually talking to our .NET code
What is a facade?
500
These two method types make up a SQL CLR table valued function.
What is a "get" method and a "fill" method, respectively.
500
These files control the versioning of the IO projects.
What is CommonAssemblyInfo?
500
These types of bindings allow composing several other bindings in a chain.
What are MultiBindings?
500
Lambda expressions are the same as this type of delegate.
What are anonymous delegates?
500
This type of pattern is used to automatically implement INotifyPropertyChanged on our ViewModels.
What is a proxy?
M
e
n
u