PDA

View Full Version : SQL


  1. What is web server
  2. What are functions
  3. What is a NOLOCK
  4. What command do we use to rename a database
  5. What are tasks
  6. What are the four main query statements
  7. How to get the automatic backup of the database in the SQL server
  8. What is SQL server agent
  9. What is the purpose of UPDATE STATISTICS
  10. Explain some DBCC commands
  11. What is the purpose of using COLLATE in a query
  12. What is data integrity? Explain constraints
  13. What is the STUFF function and how does it differ from the REPLACE function
  14. Explain what are db_options used for
  15. How to know description of a table in SQL server 2000
  16. How to Execute an Operating System Command From Within SQL Server
  17. How can I create a plain-text flat file from SQL Server input to another application
  18. What is the Difference between 'Count' and 'Count(*)'
  19. How to count the number of duplicate items in a table
  20. What are cursors
  21. What are the types of indexes available with SQL Server
  22. When do we use the UPDATE_STATISTICS command
  23. Which TCP/IP port does SQL Server run on
  24. Can you tell me the difference between DELETE & TRUNCATE commands
  25. Can we use Truncate command on a table which is referenced by FOREIGN KEY
  26. What is the use of DBCC commands
  27. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
  28. What do you mean by COLLATION
  29. What is a Join in SQL Server
  30. When do you use SQL Profiler
  31. What is a Linked Server
  32. Can you explain the role of each service
  33. Where do you think the user?s names and passwords will be stored in SQL server
  34. What are the OS services that the SQL Server installation adds
  35. Which stored procedure will you be running to add a linked server
  36. How do you troubleshoot SQL Server if its running very slow
  37. What are the authentication modes in SQL Server
  38. What are three SQL keywords used to change or set some ones permissions
  39. What is BCP? When do we use it
  40. Can you explain the types of Joins that we can have with SQL Server
  41. How to Run a Query on a Remote SQL Server
  42. How to Generate a Series of Random Integers with T-SQL
  43. How to know Who Is Blocking Your SQL Server
  44. How to Display, Amount of Disk Activity Generated by Transact-SQL Statements
  45. How to get the last identity value used
  46. How to Check Whether a Global Temporary Exists in a SQL Database or not
  47. What are the pros and cons of creating extended stored procedures
  48. What should we do to copy the tables, schema and views from one SQL Server to another
  49. How do we compare two values when one value is char and the other is an integer
  50. Which command using Query Analyzer will give you the version of SQL server
  51. What is database normalization
  52. Explain DBMS, RDBMS
  53. What are primary keys and foreign keys
  54. Explain sp_configure commands, set commands
  55. How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000
  56. Explain the new features of SQL server 2000
  57. Explain fundamentals of Data ware housing & OLAP
  58. How do you find the number of rows in a table
  59. Explain couple of features of SQL server
  60. Explain the basic concepts of SQL server architecture
  61. Explain basic SQL queries with SELECT from where Order By, Group By-Having
  62. How do you check the performance of a query and how do you optimize it
  63. How do you load large data to the SQL server database
  64. What is the difference between a local and a global variable
  65. Name four types of cursors and when each one would be applied
  66. What is the difference between a Local temporary table and a Global temporary table
  67. How do you use DBCC statements to monitor various aspects of SQL server installation
  68. What is referential integrity and how is it achieved
  69. What is indexing
  70. What is referential integrity? What are the advantages of it
  71. What is one of the first things you would do to increase performance of a query
  72. What are the basic functions for master, msdb, tempdb databases
  73. What are the difference between writing SQL query and stored procedure
  74. Explain about types of indexes in SQL server
  75. How to find nth highest salary
  76. What is the use of CASCADE CONSTRAINTS
  77. Which command executes the contents of a specified file
  78. Which command displays the SQL command in the SQL buffer, and then executes it
  79. Which system tables contain information on privileges granted and privileges obtained
  80. Which system table contains information on constraints on all the tables created
  81. What command is used to create a table by copying the structure of another table
  82. What operator performs pattern matching
  83. What is the advantage of specifying with GRANT OPTION in the GRANT command
  84. What are the types of Indexes? which one is best one and why
  85. How to work on DTS? what is the main requirement
  86. Which is the subset of SQL commands used to manipulate Oracle Database structures
  87. What are constraints? Explain different types of constraints
  88. What are the new features introduced in SQL Server 2000
  89. What changed between the previous version of SQL Server and the current version
  90. Explain the storage models of OLAP
  91. Explain the architecture of SQL Server
  92. What is lock escalation
  93. What's the difference between DELETE TABLE and TRUNCATE TABLE commands
  94. What's the maximum size of a row
  95. Explain different isolation levels
  96. How to display a particular row details from a given table
  97. How do you measure the performance of a stored procedure
  98. Which virtual table does a trigger use
  99. How do you know which index a table is using
  100. How m-m relationships are implemented
  101. What is a transaction and what are ACID properties
  102. How do you optimize SQL queries
  103. Define candidate key, alternate key and composite key
  104. What is blocking and how would you troubleshoot it
  105. What are the steps you will take, if you are tasked with securing an SQL Server
  106. What are the steps you will take to improve performance of a poor performing query
  107. What's the difference between a primary key and a unique key
  108. What is Trigger
  109. What is an extended Stored Procedure
  110. Can we remove the default constraint columns in SQL SERVER
  111. What is the difference between distinct clause and group by clause
  112. Can we call stored Procedure in Function in SQL Server 2000 and vice versa
  113. What is the datatype returned by count(*)
  114. Can you have a nested transaction
  115. What is the system function to get the current user's user id
  116. How to determine the service pack currently installed on SQL Server
  117. What is database replication
  118. What are the different types of replication you can set up in SQL Server
  119. Explain different types of Backups available in SQL Server
  120. What are the different ways of moving data/databases between servers and databases
  121. How to restart SQL Server in single user mode
  122. How to start SQL Server in minimal configuration mode
  123. Explain Active/Active and Active/Passive cluster configurations
  124. What is RAID and what are different types of RAID configurations
  125. What is the difference between having and where clause
  126. Why we need a group by clause
  127. What is a join and their types
  128. What is an index
  129. What is ACID Property of Transaction
  130. What is the difference between referencing and joining
  131. What is the difference between constraints and triggers
  132. What is normalization and its forms
  133. What is a view? Is View updatable
  134. What is a cursor in SQL Server 2000 and their types
  135. How do we get month name in SQL Server 2000, Oracle, MS Access
  136. What are the magic tables in SQL Server 2000
  137. How do we get current date in SQL Server 2000, Oracle, MS Access
  138. What are the differences between stored procedure and functions in SQL Server 2000
  139. What are the advantages of SQL server 2000
  140. Can anybody explain me cold backup and hot backup
  141. What is the purpose of creating view in SQL server 2000
  142. How to connect Sybase to SQL server 2005
  143. How to write stored procedure to update the data in 10 tables
  144. How to select a field with first letter as capital and remaining are small letters
  145. What is Data Transformation Services (DTS)
  146. What is difference between view and Dip
  147. What are the new features of SQL server 2005
  148. How to write query to delete the records in child table and corresponding records
  149. What is Magic Table
  150. What are file groups
  151. What is the cursor life span
  152. What is the difference between NOROW and LOCKROW
  153. How to delete an attribute from the emp table
  154. How many index keys possible for a table
  155. How to retrieve only second row from table in SQL server 2000
  156. Write the query for taking database backup in SQL
  157. What are SQL Reporting Services and analysis services
  158. Can we create clustered index on non primary key column
  159. How to find out the repeated value from table using groupby function
  160. How to find the employee details who are getting same salary in emp table
  161. Which data type can be used only on OUTPUT parameters of the stored procedure
  162. How we create SQL Server 2005 Reporting Services
  163. How to find the second largest salary in the emp database
  164. What is meant by SQL injection with example and one more question
  165. What are the all different types of Joins in SQL Server 2000
  166. Why cluster and non cluster index are used in SQLserver 2000
  167. What will be the SQL query to extract only last 3 records from table
  168. Which is best Subquery (or) joins in SQL server
  169. IN Vs OR operator which is best to use SQL server
  170. How to write test cases for testing databases, especially for testing and writing
  171. What is an extended stored procedure? Can you instantiate a COM object by using T-SQL
  172. What are user defined datatypes and when you should go for them
  173. What is bit datatype and what's the information that can be stored inside bit column
  174. What is the difference between Users defined function and stored procedure
  175. What is a table called if it does not have neither Cluster nor Non-cluster Index
  176. Can a stored procedure call another stored procedure
  177. How will you test the stored procedure taking two parameters namely first name
  178. What are the differences between server transfer and server execute method
  179. What is better - 2nd Normal form or 3rd normal form
  180. What are the difference between Function and Procedure-in general
  181. What does it mean to have quoted_identifier on
  182. What are the implications of having it off
  183. Can we rewrite sub queries into simple select statements or with joins
  184. Can you link only other SQL Servers or any database servers such as Oracle
  185. How do I list the available tables in a database I'm querying
  186. Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL 2000
  187. What is a deadlock and what is a live lock
  188. How will you go about resolving deadlocks
  189. How can you get @@error and @@row count at the same time
  190. Create Index myIndex On myTable What type of Index will get created after executing
  191. What is log shipping
  192. What are statistics, under what circumstances they go out of date
  193. What are defaults? Is there a column to which a default can't be bound
  194. How do you find the error, how can you know the number of rows effected by last SQL
  195. How would you Update the rows which are divisible by 10, given a set of numbers
  196. What is an execution plan? When would you use it? How would you view the execution
  197. Let us say the SQL Server crashed and you are rebuilding the databases
  198. Let us say master db itself has no backup. Now you have to rebuild the db
  199. What are sub-queries? In which case sub-queries are not feasible
  200. If a stored procedure is taking a table data type, how it looks