INDIA
Home	Books	Videos	Test Skills	Buy Now	Company	Other Links	Contact Us

Featured Video

Featured Book

Test Module :

To know about what level you should start from, here’s an online test that lets you determine your current SQL awareness levels. After we receive the Test answers from you, we will recommend you suitable books and videos to prime up your knowledge.
Question : 1	Datatypes help to enforce what type of Data Integrity?
Answer :	Entity Integrity
	Domain Integrity
	Referential Integrity

Question : 2	You have a table named Feedback that contains every record of how a customer felt about their purchase. One field is called Complaint where 0 is no complaint and 1 is a complaint. You also have a field called Rating that ranges from 0 to 100. If a customer complains they should not be giving a perfect rating of 100. If they complain they can enter a score between 0 and 90. If they don’t then it can be between 1 and 100. Which Check constraint would you use?
Answer :	CHECK (Rating BETWEEN 1 and 100).
	CHECK (Rating <=90 AND Complaint = 1)
	CHECK ( (Rating <=90 AND Complaint = 1) OR ( Rating BETWEEN 1 and 100 AND Complaint = 0) )
	CHECK ( (Rating <=90 AND Complaint = 1) AND ( Rating BETWEEN 1 and 100 AND Complaint = 0) )

Question : 3	You have a trigger on the dbo.Action table that inserts records into the dbo.ActivityHistory table. The trigger in the dbo.ActivityHistory table does a check for the @@NestLevel. What is the value of the @@NestLevel when the inserted records come from the trigger of the dbo.Action table?
Answer :	0
	1
	2
	3

Question : 4	What happens to SQL Server error actions for errors with a severity of 11-16 when you set the XACT_ABORT setting to ON?
Answer :	You will get Statement Termination
	You will get Scope Abortion
	You will get Batch termination
	You will get Connection Termination
	SQL Server will pick the error action

Question : 5	What is a requirement that must be in place in order for you to use the WITH SCHEMABINDING?
Answer :	All Base tables must be tables and can’t be views.
	All base tables must be referenced by the schema name.
	It prevents the deletion of base tables being used by the view
	It hides the information in the Sys.SQL_Dependencies.
	It prevents the View from ever being altered again.

Question : 6	Which is the only true statement about updating data through a view?
Answer :	You can make updates to one base table while predicating on another.
	You can make updates to two based tables if you only predicate on one.
	You can make updates to two based tables if you don’t use a predicate.

Question : 7	Which one of the following is not a way to evoke the default parameter value?
Answer :	EXEC @Count = CountEmployeesByLocation null.
	EXEC @Count = CountEmployeesByLocation.
	EXEC @Count = CountEmployeesByLocation default.

Question : 8	What is a difference between SCOPE_IDENTITY() and @@IDENTITY?
Answer :	SCOPE_IDENTITY() only works inside the stored procedure.
	SCOPE_IDENTITY() only works with code which calls on the stored procedure.
	SCOPE_IDENTITY() shows the most recent number, whereas @@Identity shows the next number.

Question : 9	SQL server has many error levels severity ratings. You notice a severity of 9 ran inside your TRY block and did not pass control to the CATCH block. What level of severity is the minimum that will cause the TRY block to pass control to the CATCH block?
Answer :	11
	12
	16
	17
	25

Question : 10	You have a table named dbo.SalesInvoiceDetail. You want to track all data changes made to values in this table. You also want to include the type of DML modification that was made. Which new feature of SQL 2008 should you use?
Answer :	Change Tracking
	Geometry data type
	Geography data type
	Change Data Capture
	DML after Triggers

Enter Your Email:
Which city are you from ?
Any remarks ?