| Question | Category |
| You are writing an e-commerce Web-based application with a requirement that multiple browsers, including mobile device browsers, must be supported. Which of the following layout elements is most appropriate for addressing this requirement? | ASP.NET |
| You are designing a Web page that will display a single customer record. The customer record contains multiple addresses. A requirement states that each address must display the city, state, and ZIP code on a single line. Which control will meet this requirement? | ASP.NET |
| You are writing an e-commerce Web-based application that will be used world-wide. A requirement states that the currency of the user must be supported. Which of the following addresses this requirement? | ASP.NET |
| Which of the following statements is NOT true in describing the differences between Web user controls and Web custom controls? | ASP.NET |
| You have been asked to create a control that will display the company stock symbol and opening and closing price of the prior day. This control will be included in every future Web application developed for this company. Which type of control should you choose? | ASP.NET |
| You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do? | SQL Server |
| Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do? | SQL Server |
| Application developers create an assembly that contains a CLR function. This CLR function reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer. You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the least privileged security permission set. Which permission set should you use? | SQL Server |
| A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = 'SQLServer$1' The new employee reports that when he logs in, he receives the following error message: "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1. What should you do? | SQL Server |
| You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v_CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do? | SQL Server |
| You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do? | SQL Server |
| You are responsible for managing a SQL Server 2005 database that stores sales information. Many values in nchar columns in the database tables contain preceding or trailing spaces. You need to implement a mechanism that selects the data from the tables without leading and trailing spaces. Your solution must be available for reuse in Transact-SQL statements and views. What should you do? | SQL Server |
| You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do? | SQL Server |
| You are creating a SQL Server 2005 database for a mortgage company. The database will support a new Web-based application that will handle up to 1,000 simultaneous users. This application must quickly display the results of calculation-intensive operations, such as calculating mortgage payments and amortization schedules. You need to ensure that the database processes calculations as quickly and efficiently as possible. What should you do? | SQL Server |
| You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do? | SQL Server |
| A web development company uses SQL Server 2005.Users report with increasing frequency that they receive deadlock error messages in an order processing application. You need to monitor which objects and SQL Server session IDs are involved when deadlock conditions occur. You want information about each participant in the deadlock. What should you do? | SQL Server |
| You manage a SQL Server 2005 database that contains a table with many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use? | SQL Server |
| A full backup of your database named DB1 is created automatically at midnight every day. Differential backups of DB1 occur twice each day at 10:00 and at 16:00. A database snapshot is created every day at noon. A developer reports that he accidentally dropped the Pricelist table in DB1 at 12:30. The last update to Pricelist occurred one week ago. You need to recover the Pricelist table. You want to achieve this goal by using the minimum amount of administrative effort. You must also minimize the amount of data that is lost. What should you do | SQL Server |
| You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY BEGIN TRANSACTION DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY BEGIN CATCH DECLARE @ErrorMessage nvarchar(2000) DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE() RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState) END CATCH; You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do? | SQL Server |
| You are responsible for importing data into SQL Server 2005 databases. Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons. You need to import the files into the sales database. What should you do? | SQL Server |
| A power failure occurs on the storage area network (SAN) where your SQL Server 2005 database server is located. You need to check the allocation as well as the structural and logical integrity of all databases, including their system catalogs. What should you do? | SQL Server |
| You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first? | SQL Server |
| Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do? | SQL Server |
| You develop Web-based applications for an international audience. You want to ensure that users can input a date into a Web form regardless of their local date format. You create three DropDownList controls for the month, day, and year. You must display the date in the user's local date format on another Web page. You instantiate a DateTime object using the month, day, and year values. What else should you do to accomplish your task? | ASP.NET |
| You develop Web-based client applications for a marketing research firm to enable users to search the details about the target customers in various locations. The users browse through a large amount of data. The application must utilize its resources efficiently and performance should not be negatively affected with large amounts of data. What should you do to optimize the resource utilization? | ASP.NET |
| You need to encrypt the SOAP header. What is the correct method to use? | ASP.NET |
| What namespace must be used in order to use the DOM for XML support? | ASP.NET |
| .NET remote server object must implement? | ASP.NET |
| What must be done before you can consume a web service? | ASP.NET |
| Which object can help you maintain data across users? | ASP.NET |
| What method(s) must be used with the Application object to ensure that only one process accesses a variable at a time? | ASP.NET |
| Garbage collector runs ? | ASP.NET |
| Hiding implementation and exposing the interface in OOP's is called as :- | ASP.NET |
| You want to debug a Web-based ASP.NET application. But for some cause debugging information is not shown. What could be missing? | ASP.NET |
| What property is used on the DataTable to indicate conflicts after update method is called? | ASP.NET |
| What ASP.NET object encapsulates the state of the client and the browser? | ASP.NET |
| Which of the following does the actual .NET code execute ? | ASP.NET |
| What is the fastest way to concat strings in ASP.NET ? | ASP.NET |
| When querying information stored on two different tables by means of a common column, we use: | SQL Server |
| Which of the following is not a type of SQL statement? | SQL Server |
| An attribute or set of attributes that uniquely identify an entity is called? | SQL Server |
| Which two methods can be used to submit data to a web server? | Other |
| Which of the following is not normally used as a server-side scripting language? | Other |
| Which of the following character combinations are used to separate name/value pairs in a HTTP query string? | Other |
| In HTTP communications, what role does the web browser play? | Other |
| Which .net framework does silverlight require? | .NET Framework |
| Whether the follow code will occur deadlock if we call test(30)? | C# |
| .NET Remoting | C# |
| How to make a class be serializable? | C# |
| Which Stream class does not support the Seek method? | C# |
| Question | Category |
| In the implement of Dispose method for a class, usually we use ___________ to request that the system not call the finalizer for the specified object. | C# |
| About struct, what's the output of the following code: | C# |
| Convert a string to DateTime type: | C# |
| How to define a read only property named Count in a class? (C# 3.5) | C# |
| If an assemble's version is 3.1.23.542, what's the minor version? | C# |
| Use which option to cause the C# complier to create an executable (EXE) Windows program? | C# |
| Which is the base class of int in C#? | C# |
| How to copy all the items in an Array data type variable named array to an ArrayList variable named arrayList? | C# |
| The usage of new keyword in C#, which statements are correct? | C# |
| We use try-catch block in C# for catching error of | C# |
| Member Overloading and params keyword. | C# |
| When we define a new class, we want a method of this class can be overridden in a derived class, which keyword should we use? | C# |
| Shadowing | C# |
| Property | C# |
| Access Modifiers: default access modifier for a top-level class. | C# |
| In C#, how to use a variable to save the string: Tom's Living Room | C# |
| If you want to declare a local temporary variable to store a money value in a finance application, which data type will you use? | C# |
| How to declare a string variable in C#? | C# |
| How many Bytes are used to store an int data type variable? | C# |
0 comments:
Post a Comment