17:08
Unknown
1. Which of the following statements is/are false for Extended events in sql server 2008?
2. Permanent setting of specific server characteristics is done by trace tags
3. Which of the following rules below are true to use the ROWGUIDCOL property to define a globally unique identifier column?
4. The identifers in SQL can have a character range from?
5. Embedded spaces or special characters are not allowed in SQL server identifiers
6. _______helps to restore the database to the point where it failed.
7. Which of the following statements is/are false for Declarative Management Framework (DMF) in sql server 2008?
8. Dynamic Page Repair is a type of database mirroring.
9. CPUs can dynamically be added to a running system, by using ________ feature
10. Remote BLOB storageis a _______ API which reduces the application building complexity
11. A column with an optimized storage for null values is known as __________ column
12. ________is a feature that is used for tracking the changes on a table
13. What is the purpose of MERGE in sql server 2008?
14. Which of the following statements is/are true for SQL server?
15. SQL Server 2000 always returns the result of a FOR XML query directly to the client in XML form
16. Which of the following is/are false for RAW mode of FOR XML?
17. Which of the following statement is used to make sql server resize the database file to its smallest possible size?
18. Difference between UNION and UNION ALL.
19. Which statement is correct from partitioned view?
20. Which utilities can we used to export data from sql server to a text file?
21. How inserting data through stored procedure do reduces network traffic and increase database performance?
22. Which statement is used to define a cursor?
23. Cursor that reflects the changes made to the database table even after the result set is returned
24. Capabilities of RAISERROR
25. Which global variables can be used to determine if a transaction is still open?
26. Which of the following connection type supports application role permissions and password encryption?
27. By default sql server has ___________ isolation level
28. Problems occurs if we don’t implement proper locking strategy
29. What is the default "SORT" order for a SQL?
30. Which of the following is not correct for DELETE and TRUNCATE?
31. Choose the incorrect option about the sql server index
32. By default "FILLFACTOR" value is
33. Which of the following DBCC command is used to see when was the last time the index rebuild?
34. Can a clustered index also be a unique index?
35. Is a composite index key always part of a covering index?
36. Which type of integrity preserves the defined relationship between tables when records are entered or deleted?
37. How many Primary key constraints can be included in a table definition?
38. Which statement is used to delete all rows in a table without having the action logged?
39. Tools for importing and exporting data in sql server
40. Default is a type of constraint although it does not really enforce anything
2. Permanent setting of specific server characteristics is done by trace tags
3. Which of the following rules below are true to use the ROWGUIDCOL property to define a globally unique identifier column?
4. The identifers in SQL can have a character range from?
5. Embedded spaces or special characters are not allowed in SQL server identifiers
6. _______helps to restore the database to the point where it failed.
7. Which of the following statements is/are false for Declarative Management Framework (DMF) in sql server 2008?
8. Dynamic Page Repair is a type of database mirroring.
9. CPUs can dynamically be added to a running system, by using ________ feature
10. Remote BLOB storageis a _______ API which reduces the application building complexity
11. A column with an optimized storage for null values is known as __________ column
12. ________is a feature that is used for tracking the changes on a table
13. What is the purpose of MERGE in sql server 2008?
14. Which of the following statements is/are true for SQL server?
15. SQL Server 2000 always returns the result of a FOR XML query directly to the client in XML form
16. Which of the following is/are false for RAW mode of FOR XML?
17. Which of the following statement is used to make sql server resize the database file to its smallest possible size?
18. Difference between UNION and UNION ALL.
19. Which statement is correct from partitioned view?
20. Which utilities can we used to export data from sql server to a text file?
21. How inserting data through stored procedure do reduces network traffic and increase database performance?
22. Which statement is used to define a cursor?
23. Cursor that reflects the changes made to the database table even after the result set is returned
24. Capabilities of RAISERROR
25. Which global variables can be used to determine if a transaction is still open?
26. Which of the following connection type supports application role permissions and password encryption?
27. By default sql server has ___________ isolation level
28. Problems occurs if we don’t implement proper locking strategy
29. What is the default "SORT" order for a SQL?
30. Which of the following is not correct for DELETE and TRUNCATE?
31. Choose the incorrect option about the sql server index
32. By default "FILLFACTOR" value is
33. Which of the following DBCC command is used to see when was the last time the index rebuild?
34. Can a clustered index also be a unique index?
35. Is a composite index key always part of a covering index?
36. Which type of integrity preserves the defined relationship between tables when records are entered or deleted?
37. How many Primary key constraints can be included in a table definition?
38. Which statement is used to delete all rows in a table without having the action logged?
39. Tools for importing and exporting data in sql server
40. Default is a type of constraint although it does not really enforce anything
Posted in:
SQL Server 2008 Objective type Questions
0 comments:
Post a Comment