Show:
Query Me This
C# Keywords
OOPs
Data, Data Everywhere
Potpourri
100
The keyword in a query that filters a result set.
What is where?
100
The keyword that defines a loop which iterates over all items in a collection.
What is foreach?
100
This keyword creates an instance of an object.
What is new?
100
The missing keyword in this query: select * ______ Orders.
What is from?
100
Reference types are created when using delegates or this.
What is a class?
200
A parameterized object that encapsulates a query, which may be called with the exec keyword.
What is a stored procedure?
200
The keyword that allows us to escape either loops or switch cases.
What is break?
200
The concept of keeping a method name and signature the same, but changing its behavior from one class to another.
What is polymorphism?
200
The keyword that declares a variable to hold the results of a LINQ query.
What is var?
200
A mixture of dried petals and spices placed in a bowl or small sack, used to perfume a room.
What is potpourri?
300
The type of join that would return all rows that match between two given tables.
What is an inner join?
300
The optional part of a try...catch block which always runs, error or otherwise.
What is finally?
300
The keyword used in a derived class to replace a virtual method in a base class.
What is override?
300
The class in System.Data that contains one or more tables.
What is a DataSet?
300
Together, the get and set for a private field are referred to as what?
What is a property accessor?
400
The function that could return the largest value from a given column, such as the most expensive product.
What is max?
400
The keyword that specifies a method as accessible from code that is part of a base class or a derived class, but private everywhere else.
What is protected?
400
A keyword that says a method must be overridden by a derived class.
What is abstract?
400
The specification on a column which creates an auto-incrementing value managed by SQL Server.
What is identity?
400
A query that is saved as an object in a SQL database, which can also be queried against like a table.
What is a view?
500
The keyword that is required when referring to an aggregate function and at least one other column in a select statement.
What is group by?
500
The keyword that represents a type that enables you to store a reference to a function (used when defining events).
What is delegate?
500
A special method that is called when garbage collection runs to collect a class instance, marked by a ~.
What is a destructor?
500
The Entity Framework class that manages create, update and delete operations through the SaveChanges method.
What is DbContext?
500
The minimum number of tables required to reflect a many to many relationship in SQL Server.
What is three?