Answer / Ravi Rao Gautam

A clustered index determines the physical ordering of data in a table, while a non-clustered index stores the indexed columns and a reference to the location of the corresponding row in the clustered index or table. Each table can only have one clustered index, but multiple non-clustered indexes.

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

0 Answers   TCS,

---

What are the dmvs? : sql server database administration

1 Answers  

---

When do you think a developer should use sql server-based cursors?

1 Answers  

---

What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

How to use subqueries with the in operators in ms sql server?

1 Answers  

---

List the different types of collation sensitivities in sql server?

1 Answers  

---

What is the use of RDBMS?

1 Answers   Wipro,

---

what is unique and xaml nonclustered index

1 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---

How to get the number of affected rows?

1 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

What is primary key index?

1 Answers  

---