1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

2215

---

New concepts of sql server 2005 use in your project.

2359

---

query processing

2163

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2059

---

SQL Server Architecture ?

2453

---

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?

2489

---

what are basic modules required to implement oracle application in any oraganisation?

2207

---

what is dynamic SGA and static SGA

4413

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2143

---

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2506

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2496

---

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2546

---

I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?

1906

---

wat wil hapn if we give the both read and deny read permission to user?

2103

---

How do use Having,Group by,Group function in SQL?

1737

---