What is temporary table in sql server? Why we use temp table?

1006

Have you used lexical parameters in reports?

30

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1060

How to use values from other tables in update statements using oracle?

1145

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1895

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?

2553

How to convert numeric expression data types using the cast() function?

1142

what is sql server agent? : Sql dba

1172

How to write a left outer join with the where clause in oracle?

1144

How to convert character strings into numeric values?

1184

what is schema? : Sql dba

1127

List out the different types of locks available in sql server?

1041

Why we use the openxml clause?

1064

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

Which statement is used in a select query for partial matching?

1237