If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem?

ramavenky

 Profile Answers by ramavenky Questions by ramavenky

• Feb 19th, 2010

Check for Buffer Cache SizeCheck For Poor SQL Query

kven_sat

 Profile Answers by kven_sat Questions by kven_sat

• Aug 8th, 2008

Remove unnecessary joins,? too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me

Answer Question  Select Best Answer

If 1000 users are connected to the db, and Listener is up and running suddenly system is hanging what will do ?

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 15th, 2009

In real time environment if a DB goes hang or degrades automatically the DB is allocated to next available instance. This is known as RAC i.e Real Application Cluster.

Answer Question  Select Best Answer

Where are the Background processes logging information written to?

tykarthick

 Profile Answers by tykarthick Questions by tykarthick

• Oct 12th, 2009

The information about the background process are stored in alertlog file.

Answer Question  Select Best Answer

When users are not able to log onto database, What are all the probable reasons?

Arpit Narula

 Profile Answers by Arpit Narula Questions by Arpit Narula

• Sep 14th, 2009

1. Database server is not up.2. User not aware of the correct credentials.3. TNS entry is not proper.4. Some network problem.

Answer Question  Select Best Answer

Query Record Groups NonQuery Record Groups State Record Groups

Push_22

 Profile Answers by Push_22 Questions by Push_22

• Sep 7th, 2009

Static Record groupsQuery Based Record GroupsNon-Query Based Record Groups

Answer Question  Select Best Answer

Ravi Kanojiya

 Profile Answers by Ravi Kanojiya Questions by Ravi Kanojiya

• Aug 17th, 2009

If you are usin php myadmin, click Import->CSV using LOAD DATA->Fields terminated by-> here use "," at the place of ";"?

gtomar

 Profile Answers by gtomar Questions by gtomar

• Jul 28th, 2008

Hi,If you are using toad then you need to follow steps given below :-1. login to toad .2.Go to DBA < Data import/export < Sql data wizzard <Choose .csv file  (Browse from the saved location)< Finish3. upload data into desired table .Thanks,Gunjan

Answer Question  Select Best Answer

What is Inversion Key Entry?

skachalia

 Profile Answers by skachalia Questions by skachalia

• Aug 6th, 2009

A column or group of columns used to access data from the table very frequently and may not be unique but?are potential candidate for creating non-unique indexes on them are known as Inversion Entry key.Inversion Entry key is represented by IE notation.

Answer Question  Select Best Answer

How to copy database from one machine to another machine in MYSQL? Explain with an example?

bagya

 Profile Answers by bagya Questions by bagya

• Jul 31st, 2009

Select * from information_schema.tables where TABLE_SCHEMA='test 'into outfile'D:backuptest_backup.sql';

soorajVs

 Profile Answers by soorajVs Questions by soorajVs

• Mar 6th, 2008

Make a dump of the database to be copied : mysqldump -u root -p --databases --opt MyDatabase > MyDatabase.sql
Copy MyDatabase.sql to the second machineImport the database to MysSQL server : mysql -u root -p < MyDatabase.sql

Answer Question  Select Best Answer

A library is a collection of subprograms including user named procedures, functions and packages.

orazeb

 Profile Answers by orazeb Questions by orazeb

• Jul 11th, 2009

When some procedures, function are frequently used in your applications, you can create a library containing these functions or procedures, and call them from anyform, to avoid redundancy or writing t...

Answer Question  Select Best Answer

nareshgoradara

 Profile Answers by nareshgoradara Questions by nareshgoradara

• May 25th, 2009

Just write N' before value, eg.insert into YourtableName values ( N' हिंदी अनुवाद')

Answer Question  Select Best Answer

How to perform 1st and 2nd normalization? Explain with example.

anushandilya123

 Profile Answers by anushandilya123 Questions by anushandilya123

• May 8th, 2009

For a relation to be in 1st NF the relation should contain atomic attributes only that is they must be single-valued. If its not so break the composite attribute into its parts and for multivalued...

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Feb 16th, 2009

1st Normalization specifies  if and only if all the attributes of the relation R are atomic in nature.Ex: First (Empno, Prjno, Prjname, Noof Hours, Empname)Empno: Employee numberPrjno: Project nu...

Answer Question  Select Best Answer

Three types,they are object-based logic models,record-based logic models,and physical models.

anushandilya123

 Profile Answers by anushandilya123 Questions by anushandilya123

• May 8th, 2009

Data Models:
Object based
Record based

Object Based:
Object Oriented
Entity Relationship Model

Record Based:
Relational
Network
Hierarchical

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of ...

Answer Question  Select Best Answer

satyender

 Profile Answers by satyender Questions by satyender

• May 7th, 2009

If you have Pervasive Data Integrator tool you can accomplish the task.

Answer Question  Select Best Answer

How can we perform block level recovery in database files?

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Apr 16th, 2009

In Oracle this is how you do:-Syntax:-SQL>block recover datafile datafilenumber block blocknumber;Ex:-SQL>block recover datafile 2 block 1234;

Answer Question  Select Best Answer

How to Connect MySQL with XML?

hanumanbaba

 Profile Answers by hanumanbaba Questions by hanumanbaba

• Mar 21st, 2009

use strict; use DBI; my $dbh = DBI->connect ("DBI:mysql:test", "testuser", "testpass", { RaiseError => 1,...

hanumanbaba

 Profile Answers by hanumanbaba Questions by hanumanbaba

• Mar 20th, 2009

adoConn.Open("Driver={MySQL ODBC 5.1 Driver};Server=VBNET4;Port=3306; Database=netmusk; User=admin; Password=pass123;Option=3; Min Pool Size=5; Max Pool Size=60; Connect Timeout=2;");

Answer Question  Select Best Answer

siva14329

 Profile Answers by siva14329 Questions by siva14329

• Mar 17th, 2009

That time use Abstract Data Type i.e.,first step create type.SQL>create type full_addSQL>( addr1 varchar2(15), addr2 varchar2(15),addr3 varchar2(15)); Second stepNow full_add is abstract type, then a...

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 10th, 2007

Can any body explain the concept here

Answer Question  Select Best Answer

Tell the step by step procedure of taking backup of database & restore the same in case of database crash.

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 9th, 2009

Well there are several methods used to backup and recover the database. So it depends on scenario which methods has to be followed.Go through the link given below to learn more about Backup & Restore:-http://download.oracle.com/docs/cd/B10501_01/server.920/a96519/toc.htm

Answer Question  Select Best Answer

kumars77

 Profile Answers by kumars77 Questions by kumars77

• Dec 27th, 2008

Right click on SQLPLUS icon on desktop and place username/password in target box after existing path? e.g C:oracleora92binsqlplusw.exe username/password

sravan1

 Profile Answers by sravan1 Questions by sravan1

• Dec 12th, 2006

Good tip.  working great.. thanks

Answer Question  Select Best Answer

jmauriciovp

 Profile Answers by jmauriciovp Questions by jmauriciovp

• Dec 18th, 2008

select row_number() over (order by a.marks1+a.marks2+a.marks3 desc) as Ranking, a.sName, a.marks1+a.marks2+a.marks3 total, a.marks1, a.marks2, a.marks3from students aorder by total desc

shubhangig

 Profile Answers by shubhangig Questions by shubhangig

• Mar 24th, 2006

Try this query for rankingselect s.studentname,count(b.studentname)from studenttable s, studenttable bwhere s.totalmarks<=b.totalmarksgroupby s.studentname;

Answer Question  Select Best Answer

How to find Number of Updated rows from a procedure which is having a Update Query?

prasads_delight1

 Profile Answers by prasads_delight1 Questions by prasads_delight1

• Dec 14th, 2008

Add COUNT keyword to the Update queary by which we can get the number of rows effected by the applied update queary. Else by using the front end code we can call the update queary as string which will run after the loop which will count the rows under the given condition. (by using a perameter)

Answer Question  Select Best Answer