Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / saravanan
four index keys is possible per one table.
read only table u havae create more then index per table
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Can an automatic recovery be initiated by a user?
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?
How to get the definition of a user defined function back?
Will the writetext statement activate a trigger?
What are the approximate numeric data types?
How fixed length strings are truncated and padded?
How except clause is differs from not in clause?
Explain the functionalities that views support?
Which autogrowth database setting is good?
Do you know what guidelines should be followed to help minimize deadlocks?
What is the usage of the sign function?
What is the difference RDBMS and Graph Database?
Difference between uniqe index and uniqe constraint?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
