SQL Server Online Test

1. Which of the following is a way to build dynamic sql statements?

2. Which is the minimal permission that a user must have to drop the database?

3. Which of the following is a list type in RDL with base 64 encoded value?

4. Triggers created with FOR or AFTER keywords is _____________

5. Point out the correct statement.

6. __________ locks allow processes to bulk copy data concurrently into the same table.

7. Which of the following network protocol should be selected to enable IP address?

8. Which of the following tool is used for purpose of data auditing for SQL Server only?

9. __________object is used to fill a DataSet/DataTable with query results in ADO.net.

10. A UNION query is which of the following?

11. _________ represents to total memory pressure on the system in SSIS.

12. Point out the wrong statement.

13. Which of the following stored procedure is used to add a primary database on primary server?

14. Point out the wrong statement.

15. Which of the reasons will force you to use XML data model in SQL Server?

16. Point out the correct statement.

17. Which of the following wait type is for internal use only?

18. __________ is the set of hierarchies from which data is retrieved for a single member.

19. Point out the wrong statement.

20. What does the ALTER TABLE clause do?

21. Which of the following determines type or resource to which the lock applies?

22. Which of the following query returns object names from partition IDs?

23. Following content of XML elements are indexed in full text?

24. Which of the following sample code is used to retrieve single row at a time?

25. Point out the correct statement.

26. __________ are portable, multipurpose items that contain ready-to-use schedule information.

27. Which of the following event has event number 15 in the trace?

28. Point out the correct statement.

29. Point out the correct statement.

30. Which of the following will increase the Rows/sec calculation in SSIS?

31. Point out the correct statement.

32. Different xml modes available for xml clauses are __________

33. The following query can be replaced by which one of the following?

Select name, course_id
from instructor, teaches
where instructor_ID= teaches_ID; 

34. Which of the following function mainly used for bulk load data is referenced in the following code?

SELECT
RemoteOrders.*
FROM
OpenRowset("Microsoft.Jet.OLEDB.3.51",
"c:\brian\writing\sqlservermag\nov98\nwind.mdb"; "admin"; ,
"select * from orders") RemoteOrders
left join MasterOrders on
RemoteOrders.OrderId = MasterOrders.OrderId
WHERE
MasterOrders.OrderID = null 

35. Which of the following query returns the average latency for the most recent sessions?

36. Which of the following tool analyzes and highlights data rows that do not appear to match the general patterns found in the rest of the table?

37. Which of the following statement is used to enable auditing from SQL Server?

38. What does collector_type_id stands for in the following code snippet?
core.sp_remove_collector_type [ @collector_type_uid = ] 'collector_type_uid'

39. Constraints can be applied on ___________

40. Which of the function provides consecutive numbering except in the case of a tie?

41. __________ provides details on any database object.

42. Database mirroring operates in how many modes?

43. Which of the following is a large object data type?

44. Which is a new DDL statement?

45. Point out the correct statement related to database maintenance.

46. Which of the following data type is not present in SQL Server?

47. Select * from student join takes using (ID);
The above query is equivalent to ____________

48. What are Catalog Views for XML?

49. Which of the SQL Server RTM included native support for managing XML data?

50. Which of the following returns a list of the database and log files?