| Question | Subject | Category |
| Which of the following are the metrics used to evaluate performance of a query? | Microsoft SQL Server 2008, Database Development | Gathering Performance Information |
| Which of the following are T-SQL ranking functions that can be used for ranking data | Microsoft SQL Server 2008, Database Development | Implementing Tables and Views |
| By default, what type of index is created for a unique constraint? | Microsoft SQL Server 2008, Database Development | Implementing Tables and Views |
| By default, which type of index is created for a primary key? | Microsoft SQL Server 2008, Database Development | Implementing Tables and Views |
| Which of the following is true about the SERIALIZABLE isolation level ? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| Which of the following commands is used to retrieve information about the information contained in the current transaction log ? | Microsoft SQL Server 2008, Database Development | Gathering Performance Information |
| Which of the following options can be used for viewing lock status within your computer running SQL Server? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| Which of the following is a best practice to reduce deadlock situations? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| Shared locks are not compatible with exclusive locks. True/False? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| How many transactions at a time can obtain an update lock on a resource? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| The _____ object is used to retrieve information about all active transactions on an instance. | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| To see the number of open transactions in the current session, ____ global variable is used. | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| To rollback a portion of a transaction, We have to define ___. | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| BEGIN TRANSACTION
INSERT INTO DemoTable
VALUES(5,'XYZ','DEMO');
BEGIN TRANSACTION
UPDATE DemoTable SET Col3 = 'Test'
WHERE TestID = 5;
COMMIT TRANSACTION;
ROLLBACK;
What is the result of the above code execution?
| Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| Assuming Emp,EmpCompress 2 tables with same schema: EmpId(Int), Name(varchar(50)), DeptId(Int). If a company wants to move all rows for Employees working in IT Department, from the Employees table to the EmployeesArchive table. Which of the following queries can be used? | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Assuming Emp table with EmpId(int), Name(varchar(100)),HireDate(DateTime),Designation(varchar(20)) columns and Audit table with currentDate(DateTime), EmpId columns. What is the result of the following query:
INSERT INTO Emp(Name,HireDate,Designation) OUTPUT getdate(), inserted.EmpId INTO Audit VALUES ('Robot','1/1/2011','Executive'); | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Which of the following is correct? | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Which of the following is true about Implicit Transactions? | Microsoft SQL Server 2008, Database Development | Implementing Programming Objects |
| Assuming the following query is executed on 31st Dec 2011. What is the result of the below query.
SELECT CONVERT(varchar(30), GETDATE(), 111) AS Expr1 | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| What is the output of the below query:
SELECT CHARINDEX('DOT%', 'DOTNET') AS 'CharIndex' | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| What is the result of the below query:
SELECT PATINDEX('DOT%', 'DOTNET') AS 'Index' | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| What is the result of the below query:
SELECT SUBSTRING('DOTNET', 1, 3) AS 'Substring' | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| If the following code was run on 31st Dec 2011, What is the result of the below query:
SELECT DATEDIFF(YEAR, GETDATE(), '8/8/2003') AS 'Difference' | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Which of the following are new SQLSERVER 2008 date functions ? | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Which of the following is true? | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Which of the following is true? | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| What is the default join type used when only the keyword JOIN is specified? | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Which of the following queries returns the users whose username starts with any of the character between v to z? | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Assuming UserProfile is a table with PKUserId int, Profession Varchar(50)columns. What is the result of the below query: SELECT PKUserId,Profession
FROM UserProfile
WHERE Profession = 'Engineer' AND (PKUserId > 12 OR
PKUserId = 1)
| Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Assuming UserProfile is a table containing a column Profession which accepts NULL value. What is the result of the below query.
[code]SET ANSI_NULLS ON
SELECT Profession
FROM UserProfile
WHERE (Profession <> NULL)[/code] | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Assuming UserProfile is a table containing a column Proession which accepts NULL value. What is the result of the below query.
SET ANSI_NULLS OFF
SELECT Profession
FROM UserProfile
WHERE (Profession <> NULL) | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| The SELECT statement must include which of the following clause: | Microsoft SQL Server 2008, Database Development | Working with Query Fundamentals |
| Which of the following are the kinds of Bundled resources in silverlight? | Silverlight 4, Development | Enhancing the User Interface |
| Which of the following is correct about Declarative resources? | Silverlight 4, Development | Enhancing the User Interface |
| We can specify that the XAML file has sample data by setting the Build Action to which of the following? | Silverlight 4, Development | Deploying Applications |
| Creating a base style and having other styles inherit from this style. This is achieved using the _ property.
| Silverlight 4, Development | Deploying Applications |
| Is it possible to create a style with the same name on both the page and application level? | Silverlight 4, Development | Deploying Applications |
| Styles declared in the resources section of the App.xaml file can be used in which of the following controls / Pages? | Silverlight 4, Development | Deploying Applications |
| Which of the following is true? | Silverlight 4, Development | Deploying Applications |
| Is it possible to inherit styles in Silverlight? | Silverlight 4, Development | Deploying Applications |
| The process of splitting an assembly into several parts and loading them on-demand is done using _. | Silverlight 4, Development | Deploying Applications |
| When Assembly Caching feature is enabled in the properties of our Silverlight project, all referenced assemblies will be included as a ZIP file in the client bin. | Silverlight 4, Development | Deploying Applications |
| When AssemblyCahcing feature is enabled in a Silverlight Project, all referenced assemblies will be included as _. | Silverlight 4, Development | Deploying Applications |
| Which of the following parameters can be used to enable the plugin to display the current frame rate.
| Silverlight 4, Development | Deploying Applications |
| By default where is the xap file located in Silverlight application?
| Silverlight 4, Development | Deploying Applications |
| Which of the following design-time properties can consume the sample data provided by d:DesignData Markup Extension which assumes the role of a sample data file loader and parser. | Silverlight 4, Development | Structuring Applications |
| If you create a .resx file called MyResource.resx in a Silverlight Project, behind the scenes a class is created called MyResource. Is it true? | Silverlight 4, Development | Structuring Applications |
| How many Resource Dictionaries can be present in a Silverlight Project? | Silverlight 4, Development | Structuring Applications |
| Which of the following is the funtionality of an ItemsPresenter control? | Silverlight 4, Development | Enhancing the User Interface |
| Which of the following is true about the ContentPresenter Control ? | Silverlight 4, Development | Enhancing the User Interface |