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	You have one row in a table called dbo.Bonus, which has two fields. The first field is called BonusID and is a NOT NULL int. The second field is called BonusAmount set to Money and is nullable. Ints are 4 bytes and Money is 8 bytes. The first record has a BonusID of 1 and a BonusAmount of Null. What is the fixed length data payload?
Answer :	4 bytes
	8 bytes
	12 bytes

Question : 2	You work for an online ordering company that processes web purchases from all over the world. You work at the Headquarters in Vancouver BC. At the exact moment an order is accepted, it is entered as a value into an OrderDate field which uses the DateTimeOffset data type. A user in Hawaii wants to know the exact time of their last order. You recorded the transaction in Vancouver BC time and want to show the results in Hawaii time. Which Function will change the time zone while preserving the UTC stored time?
Answer :	DATEADD
	DATEDIFF
	TODATETIMEOFFSET
	SWITCHOFFSET

Question : 3	The STDistance function of the Geography Data type calculates the distance between two points in …
Answer :	Feet
	Meters
	Kilometers
	Miles
	Units

Question : 4	Your company is going to deploy a new database. Your table will only hold the last two weeks’ worth of data at any given time. You have set up two filegroups named fgInvoicePastWeek and fgInvoiceCurrentWeek and the datafiles they use are up and running. You will be implementing a partitioned table for your SalesInvoice table. What task do you implement to complete creating the partition table?
Answer :	Create the partition function Create the partition scheme Create the table Populate the table
	Create the table Create the partition scheme Create the partition function Populate the table
	Create the partition function Create the table Create the partition scheme Populate the table

Question : 5	You have three partitions in a partition table named Orders. Partitions 1 and 2 contain historical data. Partition 3 contains current data. You want to have four partitions by adding a new partition to handle next year’s order data. What method would you use?
Answer :	Switch
	Merge
	Split

Question : 6	Your SQL Server 2008 database stores all employees in a table. New employees are added every day. The table has a clustered index based on the EmployeeID column. You often query by SSN but the query is too slow. How can you support an efficient reporting solution by SSN?
Answer :	Create another clustered index
	Create another nonclustered index
	none

Question : 7	You work with a database named JPRO1, which is located on a computer running SQL Server 2008. You discover that a table scan on CustPurchase in JPRO1 causes a slow query. CustPurchase is a very large table that is used frequently. The query contains the following statement: SELECT RepID, CouponCode FROM CustPurchase WHERE ShoppingCartID = . You need to provide maximum query performance. CustPurchase must remain available to users at all times. What should you do?
Answer :	Update all statistics on CustPurchase in JPRO1
	Use the CREATE statistics statement in JPRO1 to create missing statistics on ShoppingCartID of CustPurchase
	Set the priority boost server option to 1
	Execute the following statement. CREATE INDEX Index1 ON CustPurchase(ShoppingCartID) INCLUDE (RepID, CouponCode) WITH (ONLINE=ON) GO
	Execute the following statement. CREATE INDEX Index1 ON CustPurchase(ShoppingCartID ,CouponCode, RepID)

Question : 8	You have 15 million rows returned in one query of your SalesInvoiceDetail table and wish to run the entire query. It takes awhile to run. You want to return the first 40 records right away. What code will achieve this result?
Answer :	SELECT * FROM SalesInvoiceDetail OPTION (FAST 40)
	SELECT TOP 40 * FROM SalesInvoiceDetail
	SELECT * FROM SalesInvoiceDetail OPTION (OPTIMIZE TOP = 40)
	SELECT * FROM SalesInvoiceDetail OPTION (FIRST 40 ONLY)

Question : 9	You are told to find all the tables in the JProCo database that are heaps. Which T-SQL statement should you run?
Answer :	SELECT * FROM Sys.tables WHERE OBJECTPROPERTY(object_id,'TableHasIndex') = 0
	SELECT * FROM Sys.tables WHERE OBJECTPROPERTY(object_id, 'TableHasClustIndex') = 0
	SELECT * FROM Sys.tables WHERE OBJECTPROPERTY(object_id, 'TableHasNonClustIndex') = 0
	SELECT * FROM Sys.tables WHERE OBJECTPROPERTY(object_id, 'TableHasIdentity') = 0

Question : 10	What are SQL Server Statistics?
Answer :	Information collected about data in columns and indexes
	The numbers about the upper limits of how many rows each table can hold
	The information about all transactions contained in the log file

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