Geeks With Blogs


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done Interview Questions
SQL Server
Normalization 1. A table should have an identifier. A table should store only data for a single type of entity. A table should not have repeating values or columns 4. A table should avoid nullable columns Choosing a SQL Server Monitoring Tool SQL Profiler Enables you to monitor server and database activity (for example, number of deadlocks, fatal errors, tracing stored procedures and Transact-SQL statements, or login activity). You can capture SQL Profiler data to a SQL Server table or a file for ......

Posted On Tuesday, July 31, 2007 3:18 AM

Reference and value types Structs are value types, while classes are reference types Stack What is executing Heap Heap -> pointers to ref types Value Types – · if a field, -> stack, else (part of an object), -> heap: · box value type to reference type In C#, all the "things" declared with the following list of type declarations are Value types (because they are from System.ValueType): bool , byte , char , decimal , double , enum , float , int , etc Reference Types · Heap · Unbox box reference ......

Posted On Tuesday, July 31, 2007 2:00 AM

Object Oriented
Encapsulation – Only nececesary portions of class fields and methods should be publicly accessible. Hide inner workings of an object. Inheritance – ability of derived class to inherit the properties & methods from base class. The derived class can add to and override base class behavior. Polymorphism – the ability for related classes to have the methods or functions with the same name and signatures but different implementations. Aggregation/Composition - groups of objects being used to make ......

Posted On Friday, July 20, 2007 3:14 AM

Copyright © Rodney Vinyard | Powered by: