Hi friends,
I m 2012 pass out in CSE discipline. And recently joined Cybage Software as Production Support Engineer. But my ultimate goal lies in Database System. So joining Cybage was merely to keep relatives shut up and parents happy as well as prepare for my goal. But right now I have gone through various sites stating that jobs in DBA is tough to get, for freshers. And also...

DBA

• Feb 15th, 2013

Hope you are aware that being a DBA means working odd hours , indiscriminate routines , erratic week-offs ,etc (occupational hazards ! ) Even then if you wish to take this career option ,here is the w...

Answer Question  Select Best Answer

I have two Table A and B.With table A I fired a query to get a count, and a query with table B to get a count.now I want total of both count.But I want to this all in one query.Example:- I fired tqo queries as-1- select DATE(Today_DATE), count(1) from table DAY1 group by DATE(Today_DATE);2- Select DATE(Yesturday_DATE), count(1) from table DAY2 group by DATE(Yesturday_DATE);Here both table give separate...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Jan 3rd, 2013

You can do it like this

SELECT (SELECT COUNT(1) FROM table DAY1 GROUP BY DATE(Today_DATE)) + (SELECT COUNT(1) FROM table DAY2 GROUP BY DATE(Yesterday_DATE)) AS TotalCount FROM day1 LIMIT 1

Answer Question  Select Best Answer

I am using Teradata SQL Assistant.I have a table in SQL server whose table structure I wanna see through SQL assistant.....So please help me out...

Priya Aggarwal

• Nov 27th, 2012

I think sphelp stored procedure provided by sql server should of your help here. try sp_help

Answer Question  Select Best Answer

jazz

• Sep 10th, 2012

There are max 8 control files that we can create, however normally there are 3 control files that are created.

Answer Question  Select Best Answer

What exactly is encoding?

Sameer Zaidi

• Sep 3rd, 2012

The Decode stage is a processing stage. It decodes a data set using a UNIX decoding command, such as
gzip, that you supply. It converts a data stream of raw binary data into a data set. Its companion stage,
Encode, converts a data set from a sequence of records to a stream of raw binary data.

Answer Question  Select Best Answer

farhad alam

• May 22nd, 2012

Global Index : A single index covering all partitions. Local Index : Separate indexes for each partition. A local index can be unique. However, in order for a local index to be unique, the par...

Answer Question  Select Best Answer

How are candidate key that are not primary key indicated in the create table statement?

ravinder

• May 4th, 2012

Create table table_name
(ename varchar(9),
eno number(9),
edob date,
egrade varchar(9),
primary key(ename,eno);

Answer Question  Select Best Answer

Explain the steps involved in creating JDBC connection?

mfsi_chinmayb

 Profile Answers by mfsi_chinmayb Questions by mfsi_chinmayb

• Apr 6th, 2012

For more details go through this site URL : http://scornik.blogspot.in/2011/05/sql-query-performance-test-with-jmeter.html

Shravan Mahendra

 Profile Answers by Shravan Mahendra Questions by Shravan Mahendra

• Mar 31st, 2010

Here I'm Using Type-4 Driver to connect to Oracle 10g application and there it goesStep-1: JDBC Driver loading which will be as follows         Class.forName("o...

Answer Question  Select Best Answer

suji

 Profile Answers by suji Questions by suji

• Feb 18th, 2012

During report execution the designer can fill in any part of the report definition such as filter or template. The designer will determine which part of the report to be prompted at the time of report...

Answer Question  Select Best Answer

No.

geekano

 Profile Answers by geekano Questions by geekano

• Feb 3rd, 2012

I think you can pass parameters to a form

Answer Question  Select Best Answer

Azam

• Oct 24th, 2011

10 G supports grid computing, ASM (Automatic storage management) and Memory management. Oralce 10g is higher version of 9i , Oracle 10g has added a follwoing features Transparent Data Encryption A...

Ashwin Hegde

• Aug 20th, 2011

I is for Internet
g is for Grid Computing

Answer Question  Select Best Answer

How to monitor the database ?Why shmmax and semaphore parameters are used whenever we are installing database on linux?

subrahmanyam pattapu

• Jul 20th, 2011

while installing oracle software this parameters we need to set kernel parameters of shmax, semosphere its is compatible with memory of o/s and oracle database memory. while installing oracle softwar...

ramanjidba

 Profile Answers by ramanjidba Questions by ramanjidba

• Feb 27th, 2011

Using the third party tool OEM we can monitor the database.

Answer Question  Select Best Answer

Julius Cooper

 Profile Answers by Julius Cooper Questions by Julius Cooper

• May 30th, 2011

In an Oracle database, you use the BLOB (Binary Large Object) to perform an inline storage of a video or picture file.? Alternatively, you can use an externally-stored object in conjunction with the Oracle datatype "BFILE."

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

msvkrishna  

 Profile Answers by msvkrishna Questions by msvkrishna

• Member Since Feb-2009 | Feb 11th, 2009

---

Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.

msvkrishna

 Profile Answers by msvkrishna Questions by msvkrishna

• Feb 11th, 2009

Why do you have to refresh a production database and with what will you refresh? You can refresh a Dev or Test Db. For production db you need to have a hot backup.

Chiranjeevi Manne

• Mar 30th, 2007

Go for Replication using either Oracle Streams or Quest Shareplex

Improve Answer

SELECT * FROM V$VERSION

Read Best Answer

Editorial / Best Answer

Answered by: Mohammed Abdul Afroze

• Sep 27th, 2007

---

To find the Oracle Version:

Sql>Select * from v$version;

Mohammed Abdul Afroze

• Sep 27th, 2007

To find the Oracle Version:Sql>Select * from v$version;

Improve Answer

kollati

 Profile Answers by kollati Questions by kollati

• Apr 21st, 2011

Balaji,If you are Good at Command line use SQL loaded to convert the data.IF you are GUI specialist use Toad..it's very easy.ThanksVenkat

nidhi sharma

• Aug 9th, 2007

Excel -> CSV -> OracleSave the Excel spreadsheet as file type 'CSV' (Comma-Separated Values). Transfer the .csv file to the Oracle server (usually HP Unix). Create the Oracle table, using the SQL CREA...

Answer Question  Select Best Answer

kollati

 Profile Answers by kollati Questions by kollati

• Apr 21st, 2011

What exactly you are looking for....you can delete?complete row in a table by using delete statement using where clause.you can make it null value in the attribute in a row.

Answer Question  Select Best Answer

Which functionality of a database creates alert log?

ianilreddy

 Profile Answers by ianilreddy Questions by ianilreddy

• Aug 7th, 2010

Server processes will create the alert logfile.

Answer Question  Select Best Answer

Among the many databases available in the market which database is providing more user friendly behaviour and why?

maha_g3

 Profile Answers by maha_g3 Questions by maha_g3

• Jun 17th, 2010

MySql Database

Answer Question  Select Best Answer

What is included in the schema of a relational model?

Deepaklathwal

 Profile Answers by Deepaklathwal Questions by Deepaklathwal

• Apr 20th, 2010

The overall design of a relational database model is called Relational schema.

Answer Question  Select Best Answer