While installing Oracle 10g in window 7 it is giving error------
Abnormal Program termination.An internal error has occurred . Please provide the following files to Oracle support:
"Unknown" "Unknown" "Unknown"

Oracle2066

• Apr 26th, 2013

The question is over 2 years. How can you run windows Compatibility troubleshooter on an Oracle Internal error? It is not possible period. Please revisit Oracle Internal errors documentation at Oracle...

sushant

• Apr 26th, 2013

Just open control panel then click to Action Center ..There U will find the Window Programs Troubleshooting Compatibility Click that and browse the program u want to install

Answer Question  Select Best Answer

Hi..I am a student and I am learning software quality assurance subject...I want to know how to writes test cases for an email inbox of an email account.I will be very thankful to u

Mukesh

• Oct 1st, 2016

Hi swagatika,
well written
but in case here is lots of things like Compose, Sent Mail, Draft, how to close Draft etc

swagatika

• Jan 10th, 2015

Pre Condition: 1-Device connected to open internet, able to access in the internet 2-Access the URL Steps: 1-Access www.gmail.com->login page->Enter created emailid and pwd 2-Click inbox field ->op...

Answer Question  Select Best Answer

manu

• Apr 6th, 2006

   Using group by we get set of records for particualar value or content  in column ;Means it is usde to get group of records for selecting column or grou[While Order by is used to get sorting list of  records .

Neelam Jain

• Mar 31st, 2006

groupby clause is used to group the set of record. groupby clause is used with having clause.whereas order by clause is used to sort th record either acc. or dec. order

Answer Question  Select Best Answer

sangeetha

• Dec 27th, 2006

In oracle,DDL command,if u give TRUNCATE command,storage of data will get lost and structure of table will be there as it,roll back option is not there once u truncate the table

gouthami

• Aug 15th, 2006

Truncate is a DDL Command. When used in SQL Statement Deletes the data of the table permanently?i.e It Cannot be rolledback Leaving only the structure behind.Ex.truncate table tablename;if the needs to be restored than use the delete command .Ex.Delete *or columns from tablename;

Answer Question  Select Best Answer

Mohammed Abdul Afroze

• Sep 27th, 2007

If a users is having the SYSDBA Privilege then he can be able to accesses the data dictionary views.

Chiranjeevi Manne

• Mar 30th, 2007

If scott has the privilege of "SELECT ANY DICTIONARY", then he could read the information in DICTIONARY views.

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

eswar

• Dec 28th, 2016

Basically a simple and complex views can be differentiated based on the relations, functions and groups of data not by number of tables in the views. Ex: We can not apply Insert, Delete and Update on...

Bahadar Ayaz

• Jul 20th, 2011

Here are few differences between simple and complex views. 1. A Simple view selects from one table. A Complex view selects from one or more tables. 2. A Simple view does not contain functions but Com...

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

padmanabham

• Jul 28th, 2007

Non primary column direclty depended on the primarykey column is called a 3rd narmalization form

rajesh

• Oct 17th, 2005

In order to be in Third Normal Form, a relation must first fulfill the requirements to be in Second Normal Form. Additionally, all attributes that are not dependent upon the primary key must be eliminated.

Answer Question  Select Best Answer

visitor

• Apr 13th, 2007

Normalization is a process to reduce  the redundancy in databases.meaning finding a way to represent a particular data in such a way that  with least representation also it can be accessed in all the ways possible. There are a few ways of doing it like 1nf 2nf 3nf bcnf etc..

lance cheng

• May 22nd, 2006

It adds data integrity

Answer Question  Select Best Answer

mohtaak

 Profile Answers by mohtaak Questions by mohtaak

• Nov 21st, 2008

Object group can be used within same form but Object library can be used through out the data base connectivity in any form.

akhileshkaddi

• Jun 23rd, 2006

when object library is attached to a form, complete object library are compile/used in compilation, assume that object library has some objects like 1, 2,3. But my form don't use 1,2 & 3 all, it u...

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

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

there is a concept called dependencies .please check in oracle websiteif tables is altered then view becomes invalid...............but some conditions it is not invalid for example create table table1...

ravitala

• Jul 18th, 2006

NO, the view do not get refreshed when you update a data base table immediately.We have to recompile, to get them refreshed.There are 2 methods to get that refreshed .Method One:Manual approach:-ALTER VIEW COMPILEMethod Two:Automatic approach:-Select * from

Answer Question  Select Best Answer

Annapurna

• Sep 20th, 2006

select (rowid) count*(distinct schoolcode)     from ( select schoolcode(rowid)                from teacher&nbs...

namita

• May 12th, 2006

Select count(distinct schoolcode) from ( select schoolcode from teacher where sex 'female') ;

Answer Question  Select Best Answer

gtomar

 Profile Answers by gtomar Questions by gtomar

• Jul 28th, 2008

Hi, you can do it directly also by saving datagrid as sql loader file .and then login to toad and choose csv file directly to load data into table.Thanks,Gunjan

gtomar

 Profile Answers by gtomar Questions by gtomar

• Jul 28th, 2008

Hi,If you are using Toad then you need to follow up the steps given below:-1. Right click on the left top of the grid then Save datagrid in .xls format.2. Open .xls file and again ...

Answer Question  Select Best Answer

Mad Hatter

 Profile Answers by Mad Hatter Questions by Mad Hatter

• Nov 6th, 2008

For example, if tables Emp1 and Emp2 both have identical structure, and some changes were applied in them, then MINUS can show the difference. Likeselect *from Emp1MINUSselect * from Emp2 UNIONselect * from Emp2 MINUSselect * from Emp1

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 10th, 2007

With triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table

Answer Question  Select Best Answer

Mohammed Sameer

• Nov 27th, 2007

Dude Remember!when its your first job you should say"It doesnt matter if you pay me less or more i believe with my good work I would get a handsome salary today or tomorrow and I am sure organisation ...

Gururaj

• Nov 30th, 2006

Well,It depends upon your company policies.I liked this figure 10000 so i demanded if ur company wants to pay more u r welcomed.and it depends on year exp.if ur exp then alwaz ask >  30% hike

Answer Question  Select Best Answer

pavalisofthard

 Profile Answers by pavalisofthard Questions by pavalisofthard

• Oct 31st, 2008

By using index we can increase the accessing speed.

chenw2000

 Profile Answers by chenw2000 Questions by chenw2000

• Jul 11th, 2008

The first thing I can think of is to do indexingsecond, modify the table structure to reduce the possible comparison like "where col like '%AA%'third, modify the query to retrieve less rows of intermediate data.

Answer Question  Select Best Answer

Kandeepan

 Profile Answers by Kandeepan Questions by Kandeepan

• Jun 4th, 2008

How many days, we are going to retain the data after taking the backup.  For example the data which backed up today that will get expire in 90 days. That means, it is 90 days retention policy for backup

Mohammed Abdul Afroze

• Oct 30th, 2007

You can configure retention policy command to create a persistent and automatic backup retention policy.When a backup retention policy is in effect, RMAN considers backups of datafiles and control fil...

Answer Question  Select Best Answer

Why do we need a DDL and DML in a database system?

laikka_buddy

 Profile Answers by laikka_buddy Questions by laikka_buddy

• May 5th, 2008

DDL  is  nothing   but   Data  Definition  Language .  It is very important for a  dadabase that we have to  define  the data   such that  we can  create tables , alter tables, truncate  and  drop  tables

ugly1

 Profile Answers by ugly1 Questions by ugly1

• Jan 25th, 2008

DDL stands for data definition language and DML stands for data manipulation language.DML changes data in an object (eg-insert,update,delete) and when we create,change or remove a database object thats DML (eg-create). so both are important.

Answer Question  Select Best Answer