C-Sharper

SQL-Join

100

Assume we have two tables, TableA and TableB - This returns all rows from TableA and TableB. [SYNTAX: Select * from TableA ______ JOIN TableB on TableA.name = TableB.name].

What is a full join

200

Assume we have two tables, TableA and TableB - This type of join produces only the set of records that match in both Table A and Table B. [SYNTAX: Select * from TableA ____ JOIN TableB on TableA.ColumnName = TableB.ColumnName]

What is an inner join

300

Assume we have two tables, TableA and TableB - this type of join produces a complete set of records from Table A, with the matching records (where available) in Table B. If there is no match, the right side will contain null. [SYNTAX: Select * from TableA ____ JOIN TableB on TableA.ColumnName = TableB.ColumnName]

What is a left join

400

Assume we have two tables, TableA and TableB - This type of join produces a complete set of records from Table B, with the matching records (where available) in Table A. If there is no match, the left side will contain null. [SYNTAX: Select * from TableA ____ JOIN TableB on TableA.ColumnName = TableB.ColumnName]

What is a right join (aka Right Outer Join)

500

Assume we have two tables, TableA and TableB - This type of join returns ALLrows from TableA AND TableB. [SYNTAX: Select * from TableA ____JOIN TableB on TableA.name = TableB.name].

What is a full join (aka Full outer join)

SQL

100

A unique reference number (128-bit integer) used as an identifier through ALL systems. In theory, the number should be unique across ALL databases and all systems of record because it is derived from a very precise timestamp.

What is GUID (Global Unique Identifier)

200

A relational table which uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number) or generated by the database. Primary keys may consist of a single attribute or multiple attributes in combination.

What is Primary Key

300

When one table references another the _____ in the referencing table is the primary key in the source table. In other words, it is a field (or collection of fields) in one table that uniquely identifies a row of another table.

What is a Foreign Key

400

A set of precompiled SQL statementsused to perform a task. Consist of a name, parameters and a body [Sample: CREATE PROCEDURE spGetSomething (@Id int) AS SELECT columnName, ColumnName FROM ColumnName]

What is a stored procedure

500

All applications that communicate with an instance of SQL Server do so by sending these kinds of statements to the server. This then expands on the SQL standard to include procedural programming, local variables, various support functions for string processing, date processing, mathematics, etc. All applications that communicate with an instance of SQL Server do so by sending ___ statements to the server, regardless of the user interface of the application.

What is T-SQL

Access Modifiers

100

These types of members are accessible ANYWHERE in program or application, there are NO restrictions to access this type of access modifiers. They can be applied to classes, methods, properties, structures and interfaces.

What is Public Access Modifier

200

This type of member isaccessible only within the body or scope of the class or the struct in which they are declared. We can declare them to a class, method, property, structure or interface. If no modifier is declared it will be assumed to be this. Can declare this access modifier to a class, method, property, structure or interface.

What is a private access modifier

300

These members are accessible within the body or scope of the class or the struct in which they are declared and if declared in base class (Parent class) then it is also accessible in derived class (child class) only if access takes place through derived class type. Can declare these access modifiers to a class, method, property, structure or interface.

What is a Protected Access Modifier

400

These members are accessible within the same namespace scope in which it is declared or it is accessible in same assembly or same project. Can declare these access modifiers to a class, method, property, structure or interface.

What is an Internal Access Modifier

500

These members are accessible within the same namespace scope in which it is declared or it is accessible in same assembly or same project and it is also accessible in another assembly or project. If declared in base class (Parent class) of first assembly then it is also accessible in derived class (child class) of other assembly if access takes place through derived class type. Can declare these access modifiers to a class, method, property, structure or interface.

What is Protected Internal Access Modifier

General C#

100

A 'template' for an object, a reference type. A blueprint that defines the data and behavior of a type. A data structure that encapsulates a set of data and behaviors that belong together as a logical unit. The data and behaviors are the members of the this and include its methods, properties and events.

What is a class

200

The object that is created and held in a 'variable' from a class. Any time you use a constructor to create an object you create this. For example: DoSomething() abc = new DoSomething();

What is an instance

300

The set of objects used to communicate between a data source and a dataset. They are components that simplify the process of moving data between your application and a database. They are configurable to allow you to specify what data to move into and out of the dataset. Often this takes the form of references to SQL statements or stored procedures that are invoked to read or write to a database.

What is an Adapter

400

The Asp.Net MVC framework maps URLs to classes that are referred to as ___. The ___ process incoming requests, handle user input and interactions, and execute appropriate application logic.

What is a controller

500

This enables a group of properties, methods and other members to be considered a single unit or object. In other words: the process of enclosing one or more items within a physical or logical package.

What is Encapsulation

Definitions

100

The abbreviation used for Create, Read, Update and Delete in SQL

What is CRUD

200

This type of statement allows us to execute a statement or group of statements (a block of code) several number of times. Types include: While, for and do/while.

What is a loop

300

This represents a contract. A set of public methods any implementing class has to have. It contains definitions for a group of related functionalities that a class or a struct can use. Technically, it only governs syntax, i.e. what methods are there, what arguments they get and what they return. The ____ defines the 'what' part of the syntactical contract and the deriving classes define the 'how' part of the syntactical contract.

What is an Interface

400

This enables the user to create new classes that reuse, extend and modify the behavior that is defined in other classes. The original is called the base (parent) class and the class that usesthose members is called the derived (child) class. A derived class can have only one direct base class. If ClassC is derived from ClassB, and ClassB is derived from ClassA, ClassC uses the members declared in ClassB and ClassA.

What is Inheritance

500

This enables you to 'add' methods to existing types without creating a new derived type, recompiling, or otherwise modifying the original type. These methods are a special kind of static method, but they are called as if they were instance methods on the extended type. The most common ones are the LINQ standard query operators that add query functionality to the existing System.Collections.IEnumerable and System.Collections.Generic.IEnumerable types. Thesemethods use the 'this' word in their signature [public static int WordCount(this string str){ }].

What is Extension Methods