Followers

About this blog

who is the founder of reliance group?

Pages

.NET, ASP.NET, C# , VB.NET, .NET Framework, SQL Server and Other Interview Questions-1

Question

Category

What is use of Option Strict On option

ASP.NET

What is the purpose of Reflection?

ASP.NET

when you convert the data. What can you do to populate the table?

SQL Server

How should this entity from the logical model be implemented?

SQL Server

How would you create the database?

SQL Server

Table has a primary key and FULLTEXT search enabled. They give you the names of all the columns but you want to be able to search for a string in all columns.

SQL Server

How can this be done without the use of a trigger?

SQL Server

What should you do?

SQL Server

Which clause will cause the statement to fail?

SQL Server

Select the best option

SQL Server

Which of the following SQL SELECT statements will show which books (titles) have more than one author?

SQL Server

Which of the following SQL SELECT statements could you use?

SQL Server

which of the following SQL batches will drop a stored procedure named sp_myprocedure from the current database?

SQL Server

How should primary and foreign key fields be placed into the design of this database?

SQL Server

How should the tables be implemented?

SQL Server

Which result will this trigger provide?

SQL Server

What should you do to solve the problem?

SQL Server

Which CONTAINS statement should you use?

SQL Server

What should the scheduled job execute?

SQL Server

You are recreating the customers database and you want to create the index, The table has 1,000,000 records and is heavily updated. The table is expected to increase by 20% over two years. Choices given:

SQL Server

What fill factor will you set?

SQL Server

A question asking how to implement cascade deleting?

SQL Server

Which statement can you use to execute the procedure?

SQL Server

What of the following do you use to with the create view?

SQL Server

You have A, B, C columns with 100 %, 50 % and 10 % cardinality

SQL Server

How should you index the table to improve query performance.

SQL Server

Which index enables the fastest query?

SQL Server

Which query should you use to perform this search?

SQL Server

What should you do to implement the application to meet all of the requirements?

SQL Server

What fill factor will you set

SQL Server

How do you add constraint to an existing table?

SQL Server

Bulk Copy

SQL Server

What should you do to eliminate the importation error?

SQL Server

Which query will accomplish the desired result?

SQL Server

Choose the correct SELECT query

SQL Server

How to improve the query performance?

SQL Server

What should you do to improve the response times for queries?

SQL Server

What does this output tell you about how the data is stored?

SQL Server

How should you create the OLTP database?

SQL Server

What should you do?

SQL Server

How to prevent this behaviour?

SQL Server

Which four events should you track?

SQL Server

What is the Maximum Number of REFERENCES allowed per table in SQL Server 2008?

SQL Server

What is the Maximum Number of user connections supported by MS SQL Server 2008?

SQL Server

How do you force post back using JavaScript?

C#

How many Non Clustered indexes you can have it in a table in MS SQL Server 2008?

SQL Server

What should you do to produce this report?

SQL Server

What you should do?

SQL Server

If the inventory table contains 350 unit_price values and there are 125 different manufacturers, how many unit_price values will be displayed?

SQL Server

How can you change a stored procedure without applying all the current permissions on it?

SQL Server



Question

Category

What will this statement delete?

SQL Server

Which query will accurately produce the report?

SQL Server

How can you create the table?

SQL Server

Query Result

SQL Server

CLUSTERED INDEX and NON-CLUSTERED INDEX

SQL Server

Indexes

SQL Server

Entity

SQL Server

Query Result

SQL Server

constraint

SQL Server

Can we declare a class as Protected?

ASP.NET

What kind of documents are supported in WPF?

ASP.NET

In a Row Filter in Sql Server, how many bytes are used for a single column?

SQL Server

How many instances can a SQL Server supports on a failover cluster?

SQL Server

What is basic unit of WF?

ASP.NET

Can we declare private class in a Namespace?

ASP.NET

What Are Attributes in DotNet?

ASP.NET

Can you call SQL Trigger from Stored Procedure explicitly?

SQL Server

Can you call SQL Trigger from ASP.NET application explicitly?

C#

In which event are the controls fully loaded?

ASP.NET

How would one do a deep copy in .NET?

ASP.NET

Can i change private assembly to shared assembly?

ASP.NET

Can you edit data in the Repeater control?

ASP.NET

different type of JIT compiler

ASP.NET

What are the different type of IIS authentication?

ASP.NET

Is string a value type or a reference type?

ASP.NET

NET is Compile Time OR Run Time Environment?

ASP.NET

What does WSDL stand for?

ASP.NET

Which control would you use if you needed to make sure the values in two different controls matched?

ASP.NET

To test a Web service you must create a windows application or Web application to consume this service?

ASP.NET

Which method do you use to redirect the user to another page without performing a round trip to the client?

ASP.NET

Select Name, Place from Person order by table 3

SQL Server

What is the maximum Size SQl Varchar ?

SQL Server

Can we Assign Null value to Unique Key Column ?

SQL Server

Can we assign Null Value to Primary Key ?

SQL Server

It is not posible Create Trigger on View.

SQL Server

How may forienkey can define on one table ?

SQL Server

Can one Table have more then one Cluster index ?

SQL Server

How may Types of Joins are in Sql ?

SQL Server

What is the Maximum and Minimum Size of the Int64

C#

What is Minimum and Maximum Size of Int32 ?

C#

What is minimum and Maximum Size of Int16 ?

C#

What is the use of Partial Class ?

C#

In Crystal Report we bind the follwing File for Design the Report.

ASP.NET

Can We Pass parameter to Crystal Report (.rpt) File ?

ASP.NET

Can we Write Insert/update Statement in Function ?

SQL Server

What operating systems will the .NET Framework 3.0 be available for?

ASP.NET

Is C# used for any core features of Windows Vista?

ASP.NET

Constraint

SQL Server

Is AJAX code cross browser compatible?

ASP.NET

Is the XMLHttpRequest object part of a W3C standard?

ASP.NET



Question

Category

Use of DESC

SQL Server

State true or false

SQL Server

What is the output

SQL Server

Find the largest integer

SQL Server

DROP option in ALTER TABLE

SQL Server

Result of the Given query

SQL Server

Create table Copy Structure of another table

SQL Server

Delete & Truncate

SQL Server

substitution symbol used with INSERT INTO command

SQL Server

manipulate Oracle Database structures

SQL Server

pattern matching

SQL Server

Which control cannot be placed in MDI?

ASP.NET

What is RAID?

SQL Server

Sql Join

SQL Server

Is Ajax a technology platform or is it an architectural style?

Other

Max User Connections ?

SQL Server

Max Identifier length (in characters)?

SQL Server

Maximum Rows per a Table ?

SQL Server

Maximum Columns in a Table?

SQL Server

Max Bytes per row in a table?

SQL Server

What is Max Database Size in terabytes?

SQL Server

Maximum number of foreign key table references per a Column

SQL Server

Maximum number of foreign key table references per table

SQL Server

How Many Groups of Data Types?

SQL Server

Modes of Session

ASP.NET

Can we do database operations without using any of the ADO.net objects?

ASP.NET

Can we configure a .NET Remoting object via XML file?

ASP.NET

Types of Attributes in .NET?

ASP.NET

Are there any security risks associated with session and application variables?

ASP.NET

Is the After report trigger fired if the report execution fails?

SQL Server

How many constructors does a class have?

C#

What are three test cases you should go through in unit testing?

ASP.NET

Can foreign key have null values?

SQL Server

How many XML indexes in sql server?

SQL Server

How many User connections in sql server?

SQL Server

How many Columns per UPDATE statement (Wide Tables)

SQL Server

How many REFERENCES per table?

SQL Server

How many Parameters per user-defined function?

SQL Server

How many Parameters per stored procedure?

SQL Server

How many Number of grouping sets generated by operators in the GROUP BY clause?

SQL Server

Number of distinct expressions in the GROUP BY clause when any of the following are present: CUBE, ROLLUP, GROUPING SETS, WITH CUBE, WITH ROLLUP

SQL Server

How many Nonclustered indexes per table in sql server?

SQL Server

How many Nested trigger levels in Sql Server?

SQL Server

How many Nested subqueries in Sql Server?

SQL Server

How many Nested stored procedure levels in sql server?

SQL Server

sending request to server(AJAX)

Other

How many tables can we add in non clustered index?

SQL Server

Sending request to server

Other

What debugging tools come with the .NET SDK?

C#

Is XML case-sensitive?

C#



Question

Category

Truncate are logged operation?

SQL Server

Can we use session state in a Web farm?

ASP.NET

Can you change the value of a variable while debugging a C# application?

C#

Can multiple catch blocks be executed?

C#

How many types of Isolation Levels in SQL Server 2005?

SQL Server

What types of cookies in asp.net?

ASP.NET

Does Abstract classes have constructor?

C#

What are the different types of replication you can set up in SQL Server?

SQL Server

Can you edit data in the Repeater control?

ASP.NET

What is IL?

.NET Framework

Nested Master Page Support

ASP.NET

What is the base class for the system element hierarchy ?

C#

How can you get table details

C#

How to deploy an assembly?

.NET Framework

Constructor can be make private?

Other

Why use Global temp table instead of permanent table?

SQL Server

Which event is raised by a SqlConnection during a successful connection attempt?

.NET Framework

Can we run application with multiple web.config?

ASP.NET

What is difference between Session.Removeall and Session.Abondon in session?

ASP.NET

What is the default MIME types extensions should available in IIS for Silverlight applications deployment?

Other

What are all the default files needed to deploy the Silverlight application in IIS?

Other

What are the possible Data binding modes in Silverlight while binding data?

Other

Which keyword indicates that a method defines an operation that is a part of a service contract in WCF service?

Other

Which keyword indicates that an interface or a class defines a service contract in WCF service?

Other

WebClient can support which method, GET or POST?

Other

Select the appropriate class that supports communication over the HTTP and HTTPS protocols, and also supports GET or POST method?

Other

Using which property we can assign the data source to ListBox while binding the data?

Other

Which language is used to design the layout in Silverlight?

Other

XAML stands for

Other

How can we store the state on the user in Silverlight?

Other

What is the parent XAML tag of Silverlight page?

Other

When you create a Silverlight project thru Visual Studio, which XAML file contains the Application_Startup and Application_Exit methods?

Other

RIA stands for

Other

Main function

C#

RCW

C#

What is DependencyProperty in WPF?

Other

WHAT IS NOT USED FOR DDL?

SQL Server

What is the full form of DML

SQL Server

What is the output of textBox1.Text = System.DateTime.MinValue.ToString() ; ?

ASP.NET

What is output textBox2.Text = System.DateTime.Today.ToString(); at 1:00 PM and on date 28 may 2010 ?

ASP.NET

To validate textbox for number

C#

Separet time from datetime

C#

How many types of cookies are there?

ASP.NET

Access using a unique key

ASP.NET

The top .NET class

ASP.NET

What is an Object

C#

What is ANSI

.NET Framework

What is an Encapsulation

C#

The subscript number of an array starts from

C#

Which Escape Character is used for New Line in Console

C#



Question

Category

What is CSS

ASP.NET

Which of the following can be a Principal in Sql Server 2008?

SQL Server

Can you please tell us the valid Extended Event targets in SQL Server 2008?

SQL Server

In Sql Server 2008 FULL-TEXT SEARCH, select the following which is Language specific?

SQL Server

Sharepoint - Which of the following crawl you will use for indexing only updated content of shareoint site?

Other

Sharepoint - Publishing feature in sharepoint

Other

Which is true ?

C#

How can we view the IL generated code?

.NET Framework

Client side value from the Server side

ASP.NET

Sort Elements

C#

Execute the SP Dynamically with Character as Parameter

SQL Server

You need to develop a Toolbar control that is used by many applications and can be able to add in Visual Studio.NET toolbox. What will you do?

ASP.NET

What will you do when you want to see the trace output of an application using trace.axd? Select Best way

ASP.NET

Some of the commonly used text strings are stored in your application for use by the page in application.

ASP.NET

What you shoud do to add the web control in your ASP.NET web pages without compiling your control into a .dll file?

ASP.NET

Which tool you should use to restrict customer to update any static pages of the website?

ASP.NET

Which code segment of the Web.config file should you use?

ASP.NET

You have 2 buttons in a web form btnSubmit and btnCancel.

ASP.NET

You created a Web control which consists of labels and associated text boxes.

ASP.NET

What is the event that is fired when an unhandled exception is encountered within the application?

ASP.NET

You are creating an ASP.NET application for a company.

ASP.NET

You are designing a new control for use in ASP.NET applications.

ASP.NET

If cookies are not enabled at browser end does form Authentication work?

ASP.NET

Which of the following denote value that can be taken by Cache-Control of ASP.NET?

ASP.NET

What is the required file extension for an ASP.NET Web Service?

ASP.NET

which one directly contains their data are either allocated on stack or allocated inline in a structure

ASP.NET

Which is the most appropriate place to install a Strong-Named assembly that is intended for use among several web applications?

ASP.NET

Your Asp.net application runs on a restricted user account on local mechine.

ASP.NET

Your ASP.NET application displays sales data on a page. You want to improve performance by holding the page in memory on the server for one hour.

ASP.NET

In my Web Form i.e asp.net form I have a control of DropDownList having 2 values of New York and Los Angeles .

ASP.NET

Which property common in every validation control?

ASP.NET

I have an ASP.NET application. I have a page loaded from server memory. At this instance which of the following methods gets fired

ASP.NET

An organization has developed a web service in which the values of the forms are validated using ASP.NET application.

ASP.NET

Category: 0 comments

0 comments:

Post a Comment

Search This Blog

Blog Archive