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-3



Question

Category

What does the following do?

SQL Server

You Want to inform users of the correct syntax if they don't enter all the necessary parameters. How?

SQL Server

Which of the following is found in the row locator of a non clustered index if the table has a clustered index?

SQL Server

Which of the following allows the administrator to export and import data

SQL Server

What was added to SQL server in version 7

SQL Server

What is a PRIMARY CONSTRAINT used for?

SQL Server

How much space will the following table take up for 100,000 rows?

SQL Server

What Normal form is the following table in?

SQL Server

Which of these statements will be used for the backup?

SQL Server

Which of these statements is true about clustered indexes?

SQL Server

You have two tables, Author and Publisher. Each has PublisherId as a column. In Publisher PublisherId is defined as char(6) and in Author it is defined as char(4). What should you do?

SQL Server

A table Employee has a EmCode column as a not null constraint . How would you convert it to a primary key constraint ?

SQL Server

How do you enforce domain integrity?

SQL Server

An index idxstudent is created on Student table on SCode column. How will you check whether index was created or not?

SQL Server

what is the diff between user control and Customcontrol in WPF?

ASP.NET

What are templates

ASP.NET

What are the panels in WPF

ASP.NET

What are the types for data binding modes in WPF

ASP.NET

what is the soap latest version

ASP.NET

How can we Host WCF Services

ASP.NET

Which of these objectives is fulfilled ?

SQL Server

Which of the following statements will work?

SQL Server

What permissions are required to execute a T_SQL?

SQL Server

How do you distinguish a table in a self join

SQL Server

Which clause can be used to limit the number of rows being returned in a results set

SQL Server

What system procedure do you use to get a list of the objects that the stored procedure depends on?

SQL Server

How many rows can be returned by a sub query without generating an error

SQL Server

What recompile option will compile the stored procedure the first time it is run and will save the optimal path in the procedure cache for subsequent executions

SQL Server

What are extended stored procedures stored as?

SQL Server

How many parameters can you pass into a stored procedure

SQL Server

What statement do you use to inform users of non-SQL Server errors

SQL Server

what would happen?

SQL Server

What will ensure a fast BCP?

SQL Server

The permissions to run CREATE PROCEDURE defaults to which user

SQL Server

What will you get when you run a query using CONTAINS?

SQL Server

Update the performance when accessing the information in the demographic table?

SQL Server

How can you accomplish this and minimize performance hit on the database?

SQL Server

What is the most likely problem?

SQL Server

How do you minimize deadlocking?

SQL Server

What can you do to prevent the problem?

SQL Server

What should you use the Create Trace Wizard to do? (Choose two.)

SQL Server

What can you do to solve the problem?

SQL Server

Remote stored procedure

SQL Server

Performance of the OLTP database?

SQL Server

how to improve performance?

SQL Server

Which statement will produce the report?

SQL Server

How can you create the inventory table?

SQL Server

You are creating a table named Recruit to track the status of potential new employees. The SocialSecurityNo column must not allow null values. However, a value for a potential employee's Social Security Number is not always known at the time of initial entry. You want the database to populate the SocialSecurityNo column with a value of "UNKNOWN" when a recruiter enters the name of a new potential employee without a Social Security Number. How can you accomplish this task?

SQL Server

You have existing data that must be moved into a new database. The table is stored in two tables names TableA and TableB. Each table contains more than 100 million rows. You know that applications are joining TableA and TableB by using a clustered index. Fast response time is critical, in the past separating the tables from the rest of the database and placing them on different disks has improved response time. In the new database, how should you save the data in TableA and TableB in order to reduce response time when joining the two tables?

SQL Server

What can you do to make the query more efficient?

SQL Serv



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

Which of the following is TRUE about Windows Authentication in ASP.NET?

ASP.NET

What are the main components of WCF?

.NET Framework

What are trees in WPF

.NET Framework

What are the panels in WPF?

.NET Framework

what are the Activation modes for .NET Remoting

C#

What are WebMethod attribute properties

ASP.NET

How do you achieve a goal of creating a function that returns scalar information about the activity time for a particular user?

SQL Server

How do you provide maximum query performance in below scenario:

SQL Server

How can you ensure that an User,Adam can write queries that join information from two servers Server1 and Server2?

SQL Server

How do you implement a mechanism that selects the data from the tables without leading and trailing spaces?

SQL Server

What should you do to ensure that the View, created to join two tables, cannot be affected by modifications to underlying table schemas?

SQL Server

Which Transact-SQL statement you should use to configure the Trigger to prevent it from firing during the data import process?

SQL Server

Which dynamic management view should be used to identify the indexes which were not used by any queries since the last time SQL Server 2005 started?

SQL Server

How do you restore a table in a SQL Server 2005 database, which has been accidentally altered, without affecting the availability of other data in the database?

SQL Server

You must restore the MASTER database from a backup on a SQL 7 computer.

SQL Server

What is the best method you should use to copy a one-table Access database to another table that exists in a SQL Server 7 database?

SQL Server

Which of the following are step object precedence constraints?

SQL Server

Question

Category

Exchange and SQL 7.0 are running on the same server.

SQL Server

Which of the following SQL Server services are installed during the Typical installation option on a NT Server?

SQL Server

Which upgrade path would you use to upgrade SQL Server 4.2 to SQL Server7?

SQL Server

What functions are performed by the SQL Server Agents?

SQL Server

Which place would you check, if you find out that SQL Server7 installed on a NT Server is giving an error and will not start?

SQL Server

How many default instances can you install on a single SQL Server server?

SQL Server

Which upgrade data-movement method requires that users not be accessing the database you want to upgrade?

SQL Server

Which of the following statements can you use to create a filegroup?

SQL Server

Which of the following are valid filegroup types?

SQL Server

Which of the following methods let you change the database recovery model?

SQL Server

Which of the following are valid SQL Server principals?

SQL Server

Which is not a Query Representation plan in SQL Server 2005?

SQL Server

The maximum number of column per SELECT Statement?

SQL Server

What is an Alias for a base table called?

SQL Server

Which of the following database design features is most important to SQL performance?

SQL Server

Which SQL command is used to create a set of privileges that can be granted to users or to other roles?

SQL Server

What is the maximum number of instances supported by SQL Server 2008 Enterprise edition and Standard edition respectively?

SQL Server

Code Access Security does which one of the following?

C#

Which of the following tools manages certificates, certificate trust lists (CTLs), and certificate revocation lists (CRLs)?

C#

Which one of the following .NET Framework tools displays details for failed assembly binds?

C#

Which one of the following statement is true for Assembly's Manifest?

C#

What is the term for assemblies that are marked for a specific culture via their AssemblyCultureAttribute?

C#

Whats the difference between a Thread and a Process?

C#

Which of the following is Reference Type?

C#

If you are using transactions, what is a great technique that can help you roll back to certain points within a transaction?

C#

A User wants to deploy a zero impact .NET application

C#

A User wants to use reflection to discover the assembly that contains a specific module.

C#

Which Namespace helps to find informations of an assembly?

C#

Which of the given method does not belong to System.Object?

C#

Which code snippet should you use to make the runtime assign an unauthenticated principal object to each running thread?

C#

Which code snippet should be used to serialize an object by name 'Data' of type List(Of Integer) in a binary format?

C#

Which property of the Exception class should you use to find a line of code that caused an exception to be thrown?

C#

Which code snippet should you use to gather regional information about customers in NewZealand?

C#

Category: 0 comments

0 comments:

Post a Comment

Search This Blog

Blog Archive