| Question | Category |
| Which is one of the SQL Server System database is know as template database | SQL Server |
| SQL is a language for | SQL Server |
| What type of backup job copies only data that has changed since the last full backup? | SQL Server |
| How do I change this query to ensure that it returns the top 25 salespersons based on total sales dollars? | SQL Server |
| You have designed the database for a web site that is used to purchase concert tickets. | SQL Server |
| What does the following SQL query return? Alter table emp add ( Ename varchar (10) NOT NULL, Sal number (3) ); | SQL Server |
| Which command is used to set a set of privileges that can be granted to users or to other roles? | SQL Server |
| You are a database developer for an insurance company. | SQL Server |
| You are the DB Designer for ABC International Airport's Airport Management Center. | SQL Server |
| SQL is a procedural language | SQL Server |
| Between Windows Authentication and SQL Server Authentication, which one is trusted? | SQL Server |
| What will the last two lines print? | SQL Server |
| Which script should you use? | SQL Server |
| What is the default value of PAD INDEX option in creation of indexes? | SQL Server |
| You manage a SQL Server installation which uses Secure Sockets Layer to provide encryption between clients and the server. | SQL Server |
| You are a database developer. | SQL Server |
| What value will select count(managerid) from employees return? | SQL Server |
| What is true about a view | SQL Server |
| What type of lock will deny users any access to a table? | SQL Server |
| which command is used to transfer data to a flat file | SQL Server |
| Which is the best way to delete all rows in a table with no foreign key references? | SQL Server |
| Assuem the department table has 10 rows. What would be the result of the following query | SQL Server |
| Which DML Statement can be used to fire a Trigger? | SQL Server |
| What is a Trigger? | SQL Server |
| Which of the joins are used for retrieving specific records from both, left as well as right side table? | SQL Server |
| What should you recommend? | SQL Server |
| What should you do? | SQL Server |
| How can I associate the serial no in the result set (which is generated by select query) to display it as serial no.? | SQL Server |
| You are a database developer for a large travel company. | SQL Server |
| Sum, Average, Count etc... are | SQL Server |
| If we delete the base table of existing view, What happens? | SQL Server |
| Which are the two properties of a Datagrid that has to be specified to turn on sorting and paging respectively? | ASP.NET |
| Which Object can be used for debugging purpose | ASP.NET |
| How do you explicitly kill a user session? | ASP.NET |
| How do you secure your connection string information? | ASP.NET |
| Both the Page_Load and Page_PreRender events happen with each page Request? What is the difference between these two events? | ASP.NET |
| What method must be overridden in a custom control? | ASP.NET |
| which class will be used to retrieve the key value of web.config file? | ASP.NET |
| What base class do all Web Forms inherit from? | ASP.NET |
| Which of these string definitions will prevent escaping on backslashes in C#? | C# |
| Unboxing of a null reference type will return a null. | C# |
| The default type of enum is integer and has a default value 1 | C# |
| If a method is marked as protected internal who can access it? | C# |
| What is the difference between interface and abstract class? | C# |
| what is the default access specifier for a Top-level Class, which are not nested into other Classes | C# |
| What is the output? of following Code | C# |
| The following code will generate a compiler error. | C# |
| The statement that is used to replace multiple if statements is called | C# |
| Which of the following is not a C# keyword? | C# |
| Which tool would you use, if you want to see all the methods of a particular class in your application | .NET Framework |
| Question | Category |
| When will the garbage collector run? | .NET Framework |
| Which command would you use to list the existing files in the native image cache? | .NET Framework |
| Which command will cause an XML file to be generated from documentation comments? | .NET Framework |
| When do you absolutely have to declare a class as abstract? | .NET Framework |
| What statement is true about an abstract class | .NET Framework |
| Can you override private virtual methods? | .NET Framework |
| Can you declare the override method static while the original method is non-static? | .NET Framework |
| What namespace does the Web page belong in the .NET Framework class hierarchy? | ASP.NET |
| What the 1st method that is fired during the page load? | ASP.NET |
| ______ is the Microsoft IIS server running, handling ASP.NET requests among other things | ASP.NET |
| Do I need IIS to develop a Web application in ASP.NET 2.0? | ASP.NET |
| You need to obtain performance information about your Web Application. You should use which of the following? | ASP.NET |
| Security is very important on any web site. By default, a .Net web site is configured with which of the following authentication types? | ASP.NET |
| What is the name given to the type of assembly that contains localized resources? | ASP.NET |
| How does ASP.NET store SessionIDs by default? | ASP.NET |
| Which Compiler is used for C# | C# |
| The ++ belongs to which operator | C# |
| Which is the readonly database(system) in sql server 2008? | SQL Server |
| what are sparse columns in sql server 2008? | SQL Server |
| What do you mean by a Service Broker in Sql Server 2008? | SQL Server |
| Console is a ______ | C# |
| What is the Full form of IBM | Other |
| What is the Full form of VIRUS | Other |
| What are Arrays | C# |
| How to compare case-insensitive string comparison? | C# |
| Can multiple catch blocks be executed? | C# |
| Main function signatures ? | C# |
| Constructor | C# |
| interview question | C# |
| interview question | C# |
| REMOTING | ASP.NET |
| Which of the following are required to associate and enable a context menu strip named ContextMenu1 with a button named Button1? | ASP.NET |
| Which of the following are required to create an access key for a menu item? | ASP.NET |
| Which of the following is NOT a valid setting for the View property of the ListView control? | ASP.NET |
| Which of the following methods cannot be used to add an item to the Items collection of a ComboBox, ListBox, or CheckedListBox control? | ASP.NET |
| Which of the following Mask property settings will confi gure a MaskedTextBox for the entry of a social security number, which is displayed as three digits, followed by a hyphen, then two digits, followed by another hyphen, and then finally four digits? | ASP.NET |
| Which of the following properties of the TextBox control should be set to the value indicated to ensure that the TextBox can accommodate a string 10,000 characters long? | ASP.NET |
| Which property does not control how a Button looks or behaves when the FlatStyle property is set to Flat? | ASP.NET |
| Which setting of the Dock property causes the control to fi ll its form or container control? | ASP.NET |
| Which setting of the Anchor property allows controls to fl oat freely when the form is resized? | ASP.NET |
| You are designing an application that includes a property page that enables the user to set properties of the application. These properties are divided into three categories: Appearance, Execution, and Memory Management. Which container control represents the best starting point for the user interface? | ASP.NET |
| Which property of datatable get status when conflict after update a row in Datatable | C# |
| How many Usercontrols can be added to an asp.net web page ? | ASP.NET |
| Find Next Number in this Series | Other |
| N-tier Architecture | ASP.NET |
| Which database setting is valid for database mirroring? | ASP.NET |
| Which role is valid for database mirroring? | ASP.NET |
| Which operations can be performed against a Database Snapshot? | ASP.NET |
| Which of the following are valid connection options for the DAC? | ASP.NET |
| Which data column is required to correlate a System Monitor counter log to a trace in SQL Server Profiler? | ASP.NET |
| Question | Category |
| Which DBCC CHECKDB option is recommended for frequent checks against large databases? | ASP.NET |
| Which Transact-SQL statement allows SQL Server to automatically update statistics? | ASP.NET |
| Which Transact-SQL function shows the last time statistics were updated for a specified index? | ASP.NET |
| Which of the following operators is allowed in a trigger? | ASP.NET |
| Which stored procedure option regenerates the query plan every time a procedure is executed? | ASP.NET |
| Which of the following are valid commands to use within a function? | ASP.NET |
| Which of the following technologies would you use to update the XML values as well as the XML structure of an XML document? | ASP.NET |
| Which of the following options restricts changes to data to conform to the select criteria of a view? | ASP.NET |
| Which of the following options can prevent a table from being dropped? | ASP.NET |
| Which operator do you use to move partitions between tables? | ASP.NET |
| What does the $PARTITION function define? | ASP.NET |
| What does a partition scheme define? | ASP.NET |
| What does a partition function define? | ASP.NET |
| Which function can be used inside the CATCH block to find out the number for the error that occurred? | ASP.NET |
| Which command is used to save the data modified in a transaction so that other connections can see it? | ASP.NET |
| Which of the following syntaxes will create a global temporary table? | ASP.NET |
| Which keyword is used to create a column alias? | ASP.NET |
| Which of the following methods is exposed by all CLR UDTs for returning the UDT data as a string? | ASP.NET |
| You need to find all matches from your Product table in which the Description column includes either the words “book” or “booklet”. Which of the following FTS syntaxes should you use? | ASP.NET |
| Which of the following aggregate functions returns a row count as an integer? | ASP.NET |
| Which index option causes an index to be created with empty space on the intermediate levels of the index? | ASP.NET |
| Which index option causes SQL Server to create an index with empty space on the leaf level of the index? | ASP.NET |
| Which type of index physically orders the rows in a table? | ASP.NET |
| Which data type would you use to store up to 2 GB of text data and still be able to query and manipulate it by using standard functions and operators? | ASP.NET |
| When do you need to specify an external data source by using a linked server? | ASP.NET |
| Which of the following statements enables you to create a database certificate? | ASP.NET |
| Which of the following sentences is true for database schemas? | ASP.NET |
| Which of the following is a prerequisite for Database Mail? | ASP.NET |
| Which of the following statements can you use to create a filegroup? | ASP.NET |
| Which upgrade data-movement method requires that users not be accessing the database you want to upgrade? | ASP.NET |
| Exception Handling | VB.NET |
| Which authentication mode lets you use both SQL Server logins and Windows logins? | ASP.NET |
| How many default instances can you install on a single SQL Server server? | ASP.NET |
| Which SQL Server 2005 edition does NOT require at least 512 MB of memory? | ASP.NET |
| Which service pack level is required if you are using Windows 2000 Server for your SQL Server 2005 installation? | ASP.NET |
| During the design process for a new production installation of SQL Server 2005, you determine that you need to partition the database. Which edition supports data partitioning? | ASP.NET |
| You need to install a new production installation of SQL Server 2005. The server purchased for your installation has four CPUs. Which edition of SQL Server 2005 should you choose to make use of all the CPUs? | ASP.NET |
| You develop Web-based applications for a mid-sized direct marketing organization. You want to be able to quickly find bugs in existing Web applications deployed across the organization. You must ensure that all errors and warnings are traced. You do not want to track any unnecessary information. You decide to configure a TraceSwitch object used in many Web applications. Which configuration should you set for the TraceSwitch object? | ASP.NET |
| You develop Web-based applications. You are required to develop a component that will log the raw HTTP request and response for a Web application. You must ensure the component will be modular and provide extensibility to log other information in the future. Which design pattern should you consider for the component? | ASP.NET |
| You develop Web-based client applications. You were recently hired by a gaming software company, 4Soft, to upgrade their existing Web application to ASP.NET 2.0. Customers use the Web application to purchase and download software games, learn about new releases, and read gamer reviews. Each customer must be able to customize the information and the layout of that information once they log on to the Web application. Once the customer logs off, their customization settings should be stored for future visits. The current Web application was developed using ASP.NET 1.1 with many custom controls to facilitate the user functionality. You want to replace their existing controls with ASP.NET 2.0 technology for easier development and maintenance. What user interface features in ASP.NET 2.0 will provide the required user functionality? | ASP.NET |
| You develop Web-based applications for the intranet of a large company. All computers have the .NET 2.0 Framework loaded. Your company acquires another company. Some computers at the acquired company have both the .NET 1.1 and 2.0 Framework loaded on them. The acquired company has an intranet Web application that uses a client add-on to Internet Explorer written specifically for the .NET 1.1 Framework. How will the Internet Explorer add-on run on the company's computers? | ASP.NET |
| You develop Web-based applications. You create an application for Sales department employees to log daily transactions. The transactions are stored in a SQL Server 2005 database named SalesLog. Your Web interface provides features to manage data and generate reports using T-SQL queries. Employees complain that reporting feature of your application takes more than required time to display reports. You are required to diagnose performance issues of the reporting feature. What should you do? | ASP.NET |
| You develop Web-based applications. You create and host a Web application for existing retail customers to order sold-out products online. All customers must be registered in the Web application to place product orders. Each customer's details are stored in a SQL Server 2005 database named Customers. The Web application uses a component named CustomerSecurity to validate customers when they place an order. You want to expand the order process to allow new customers to place orders for any products available in the warehouse. You create a user account mechanism for new customers and greatly expand the product options. You decide to add new methods to the CustomerSecurity component to accommodate the additional functionality. Which test should you perform before deploying the CustomerSecurity component to the production environment? | ASP.NET |
0 comments:
Post a Comment