TechKeys is Back

TechKeys is Back — .NET Tutorials, GRC SaaS & Career Guides for Developers in 2026

Getting Started with Azure DevOps for .NET Developers — Pipelines, Repos & CI/CD

Getting Started with Azure DevOps for .NET Developers — Pipelines, Repos & CI/CD

Top .NET Interview Questions Asked in 2026 — Freshers & Experienced Developers

Hello to every one who are fallowing my blog,

today i attend one call from one Technical Recruiter (name is not required i think )

he asked some couple of question...ok i answered ....mean while 

he asked one question (in my life never i feel it is relevant  for developer)

who will use oops development environment?
ha.. ha..
expect answer and update  to me

 So far we received many request for FAQs on CSHARP, ASP.NET AND SQLSERVER for fresher who are in finishing schools. We are actively working with these Technologies  to bring  KEY  Resources for  TECHIES.

                                  you are interested in helping others  bring TECHKEYS  to your Friends through Social Media, please Leave the Comment to us to improve our work and subscribe  for more information.

 

Q 1) levels of nesting in a subquery?
     a)2        b)6         c)32        d)64

Q 2) static method correct syntax:
     a.private static main()                            b.public static main()
     c.public static int main()                          d.public static void main()

Q 3) AJAX full form?

answer: asynchronous javascript and xml.

Q 4) public static void Main()

      {
         int x=1;
       for(int i=0;i<5 ;i++) 
        {           int y=x + ++x;
                      console.write("value of y is:"y.ToString())
             }
           console.writeline("new value of x is:"+x);
          }

tell the output?

Q 5)   class table{    }
public static void Main()  { table  tobj;    }
a) tobj will store in heap         b) tobj will store in stack
c) tobj will store in stack and point to heap      d)none


Q 6)  which is not a collection type?
  a.list         b.arraylist      c.array    d.heaplist


Q7) what is  base class for serialization?

  a.System.serialization                 b.Sytem.formatters.serialization
  c.system.runtime.serialization


Q 8) which authentication is done by developers and professional?
a.windows authentication                               b.server authentication
c.both a and b                                                  d.none of these


Q 9)which is a light weight protocol?
A.SOAP              B.XML                  C.HTTP                                  D.HTML


Q 10) which model is better for enterprise work?
a.relational                                    b.hierarchical                                  c.network


Q 11) operator used for conversion of data type?A.is     B.as       C.typeof


Q 12) which access specifier has less scope than internal?
a.private                             b.public               c.protected


Q 13) which of them are executed first in a program?
a.namespace                    b.directives             c.main()                                      


Q 14) goes to operator is used in which?
a.lambda expression         b.delegates             c.events


Q 15) SGAM full form?

ans. secondary global allocation map

Q 16) size of Extent?

answer:64 KB

Q 17) how data will store in sqlserver

in sql server everything is stored on 8K data pages (8060 bytes are technically available).

Q 18) how many data pages is equal to one data extent?                       8 data pages (each size is 8K and total 64K) .


Q 19) how many types of extents in sql server

 All space allocation  is done based on extents – 64K There are 2 types of extents – 

1. mixed extent which stores data pages belong to the different objects 
1.  First 8 pages for the objects are stored in the mixed extents
2.  uniform extent which stores data pages belong to the one object.

after that only uniform extents are used. blocks regardless of the type (mixed or uniform).


Q 20) what do you know about ALLOCATION MAPs

• ALLOCATION MAPs are a few special data pages types in  SQLServer which  is used to track extents allocation. Those pages are basically bitmaps  and each bit handles one extent.(each page handles 64,000 extents or almost 4Gb of data).

Q 21) WHAT IS  GAM

 GAM – Global Allocation Map – tracks if extent are available for allocation or already in use.

Q 22) SGAM –
 Shared Global Allocation Map – tracks if extents are mixed extent and have at least one data page available for use.



Q 23) IAM
 Index Allocation Map – tracks if extents are used by specific table/index.



Q 24) what is PFS
 Page Free Space – it will check and track free space available on a page approximately. One PFS page covers 8,088 pages or about 64Mb of data.

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

• data integrity depends on

1. data sharing
2. accuracy
3.  redundency
4. 2&4                             ANS: accuracy

• which is lightweight protocal?        ANS:soap

1. class is which based memory     ANS: Heap
2.  csharp code is                         ANS: managed
3. sn.exe generates what?            ANS: Strong Name
4. file and fileinfo classes doesn't offer the set of functionality
1. moving
2. creating
3. copying 
4. deleting                                  ANS:none of the options
5. datareader field count return type        ANS:integer
6. type dataset and untype dataset difference?
1. type dataset have schema information of database(primary key and FK info)
2. untype does not have schema information
7. GOALS OF INTEROPERABILITY
1. ANSWER
2. net does not affect existing COM objects
3. .Net and COM components interoperate with each other
4. COM components can be upgraded into .NET components
8. if u build the application what file with extension generated                  ANS: .exe
9. null is a string ?                                   ANS: NO
10. which access specifiers not hide the variables in namespace
1. internal 
2. protected 
3. internal protected
4. public                                                                              ANS:public
11. which access modifier is specify for incomplete class  
1. abstract
2. virtual
3. override
4. sealed                                                               ANS: abstract
12. which keyword permits to overload abstract methods? ANS: Abstract override
13. which is not feature of c sharp                   ANS: c sharp is not a case sensitive
14. .The class which offers storage capability    Ans:ICollection 
15. sealed class                             ANS: We can’t further inherit the sealed class
16. how date types are available?   ANS:   1.Value  types  2. Reference  types   3. Pointer  types
17. which is responsible for loading data into dataset?                ANS: DataAdapter
18. .what is cLI?   ANS:  Common Language Infrastructure
19.  : Language Integrated Query
20. OLEDB full form?          ANS  Object Linking and Embedding, Database,
21. what is the backbone of disconnected model?  
22. .AJAX full form?   ANS : Asynchronous JavaScript and XML
23. .Full form of ccw? ANS :  COM Callable Wrapper
24.  net doesn’t not support which web standards?    Ans: other than this  HTTP,XML,SOAP,WSDL,UDDI. 
25. What will ICollection have?   Ans:IList and Idictionary
26. 
    
27. SQL SERVER
28. .we can minimize the selection process by using which clause?ANS: : where
29. ANS: : System catalog or System Table
30. EXTENT LENGTH  ANS: : 8 Contiguous pages(64KB)
31. which stores the pre defined query?  ANS: : System Stored Procedure  
32. sql server doesn't run which os? 
1. xp 
2. 98 
3. 95 
4. millineum                                    ANS: : 95
33. we can perform insert delete update operation on?
1. table
2. view 
3. trigger 
4. index                                 ANS:  table
34. which produces result and also non relational result
1. compute
2. cube
3. rollup
4. none                          ANS: : Compute
35.  a query which relay on output of inner query
1. correrelate subquery
2. nested subquery
3. inner querey 
4. none                       ANS:  Corelated subquery

SQL Server & C# Interview Questions — Part 3: Triggers, Indexes, DataSets Explained

1. data integrity depends on
1. data sharing
2. accuracy
3.  redundency
4. 2&4                             ANS: accuracy
2. which is lightweight protocal?        ANS:soap
3. class is which based memory     ANS: Heap
4.  csharp code is                         ANS: managed
5. sn.exe generates what?            ANS: Strong Name
6. file and fileinfo classes doesn't offer the set of functionality
1. moving
2. creating
3. copying 
4. deleting                                  ANS: Creating
7. datareader field count return type        ANS:integer
8. type dataset and untype dataset difference?
• type dataset have schema information of database(primary key and FK info)
• untype does not have schema information
9. GOALS OF INTEROPERABILITY
• ANSWER
• net does not affect existing COM objects
• .Net and COM components interoperate with each other
• COM components can be upgraded into .NET components
10. if u build the application what file with extension generated                  ANS: .exe
11. null is a string ?                                   ANS: NO
12. which access specifiers not hide the variables in namespace
1. internal 
2. protected 
3. internal protected
4. public                                                                              ANS:public
13. which access modifier is specify for incomplete class  
1. abstract
2. virtual
3. override
4. sealed                                                               ANS: abstract
14. which keyword permits to overload abstract methods? ANS: Abstract override
15. which is not feature of c sharp                   ANS: c sharp is not a case sensitive
16. .The class which offers storage capability    Ans:ICollection 
17. sealed class                             ANS: We can’t further inherit the sealed class
18. how date types are available?   ANS:   1.Value  types  2. Reference  types   3. Pointer  types
19. which is responsible for loading data into dataset?                ANS: DataAdapter
20. .what is cLI?   ANS:  Common Language Infrastructure
21. .LINQ full form?    Ans : Language Integrated Query
22. OLEDB full form?          ANS  Object Linking and Embedding, Database,
23. what is the backbone of disconnected model?  ANS:Data adapter
24. .AJAX full form?   ANS : Asynchronous JavaScript and XML
25. .Full form of ccw? ANS :  COM Callable Wrapper
26.  net doesn’t not support which web standards?    Ans: other than this  HTTP,XML,SOAP,WSDL,UDDI. 
27. What will ICollection have?   Ans:IList and Idictionary

SQL SERVER

1. .we can minimize the selection process by using which clause?ANS: : where
2. DATABASE METADATA STORE IN WHICH PLACE ANS: : System catalog or System Table
3. EXTENT LENGTH  ANS: : 8 Contiguous pages(64KB)
4. which stores the pre defined query?  ANS: : System Stored Procedure  
5. sql server doesn't run which os? 
1. xp 
2. 98 
3. 95 
4. millineum                                    ANS: : 95
6. we can perform insert delete update operation on?
1. table
2. view 
3. trigger 
4. index                                 ANS:  table
7. which produces result and also non relational result
1. compute
2. cube
3. rollup
4. none                          ANS: : Compute
8.  a query which relay on output of inner query
1. correrelate subquery
2. nested subquery
3. inner querey 
4. none                       ANS:  Corelated subquery

How to Use MessageBox in C# Windows Forms — DialogResult with Code Example

This BLOG POST demonstrate how to use the MessageBox result in window form programming. to full fill this task we will depend on DialogResult  property in Windows Forms.. 

               when we are doing windows programming using Csharp ,to show the intermediate result  we will display by messageBox
MessgeBox is having one main  function show .it returns DialogResult Value.when user used MessgeBox to display the data,user has to click default buttons OK,cancel,Abort,Ignore etc to close MessgeBox.

this we can get from MessgeBox and it will be saved in DialogResult variable .

DialogResult is consist different button values using ENUM data types .

Requirements

The following list outlines the recommended hardware, software, network infrastructure, and service packs that you need:

·         Microsoft Visual Studio .NET or Microsoft Visual Studio 2005 or above

This article assumes that you are familiar with the following topics:

·         Windows application programming

·          Visual C#.net

Creating Window Form and showing Conformation Result

This sample uses the MessgeBox to determine the button that you should click to give the conformation.

1.     Create a new Windows Application project in Visual C# .NET. By default, Form1 is added to the project.

2.     In the Design window of Form1, add a Button control. change the Text property to ARE U READY TO LEARN..

3.     Add the following code to the button1_Click event procedure:

           

private void button1_Click(object sender, EventArgs e)

        {

           DialogResult result=

MessageBox.Show("press  ok or cancel", "conformation",

                                                 MessageBoxButtons. OKCancel  );

           if (result == DialogResult.OK)    { MessageBox.Show("u selected OK"); }

              else                                      { MessageBox.Show("u selected Cancel"); }

       }

This displays user Conformation in another MessageBox, based on Yesno Options, and message box is displayed with the details of the button that the user clicked.

Complete Code Listing

Form1.cs

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

namespace WindowsFormsApplication6

{

    partial class Form1

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            this.button1 = new System.Windows.Forms.Button();

            this.SuspendLayout();

            //

            // button1

            //

            this.button1.Location = new System.Drawing.Point(47, 34);

            this.button1.Name = "button1";

            this.button1.Size = new System.Drawing.Size(187, 55);

            this.button1.TabIndex = 0;

            this.button1.Text = "ARE U READY TO LEARN..";

            this.button1.UseVisualStyleBackColor = true;

            this.button1.Click += new                                                      System.EventHandler(this.button1_Click);

            //

            // Form1

            //

            this.AutoScaleDimensions = new

                     System.Drawing.SizeF(6F, 13F);

            this.AutoScaleMode =                                                                                     System.Windows.Forms.AutoScaleMode.Font;

            this.ClientSize = new System.Drawing.Size(284, 133);

            this.Controls.Add(this.button1);

            this.Name = "Form1";

            this.Text = "TECHKEYS";

            this.Load += new System.EventHandler(this.Form1_Load);

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.Button button1;

    }

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

           DialogResult result= MessageBox.Show

                           ("Think and select ...","conformation",

                                MessageBoxButtons.YesNo);

           if (result == DialogResult.Yes )

           { MessageBox.Show("FALLOW TECHKEYS blog....."); }

           else

           { MessageBox.Show("LEARNING IS EARNING...."); }

          

        }

        private void Form1_Load(object sender, EventArgs e)

        {

          

        }

    }

}

Verify That It Works

1.     Press CTRL+F5 to run the project. Form1 is displayed.

2.     Click on ARE U READY TO LEARN..button.

3.     To Conform, click either Yes or NO. A message appears with the details of the button that you clicked.

·         If you clicked Yes, the following caption appears:

FALLOW TECHKEYS blog.....

·         If you clicked NO, the following caption appears:

LEARNING IS EARNING...

output will be 

CodeProject

http://www.codeproject.com/script/Articles/BlogFeedList.aspx?amid=