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

1) What is meant by Joint DEPENDENCY in normalization?
2) What is a MULTIVALUED DEPENDENCY? Explain.

shivakumar

• Jan 12th, 2016

When you decompose a relation into sub relations and when you assembled those sub relations it should result in original loss-less relation. Such dependency is called join dependency. Example relation...

Athira.m.m

• Oct 12th, 2015

You see joint dependency means that when you decompose tables those decomposed table should satisfy JOIN dependency ie., when they are joined they should make the original table without any conflicts ...

Answer Question  Select Best Answer

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

What is modules

• Feb 24th, 2017

In easy language for beginner

Jai pal reddy

• Jun 9th, 2007

Set con=createobject("ADODB.connection")set rs=createobject("ADODB.recordset")set cmd=createobject("ADODB.command")con.provider=(Microsoft.jet.oledb.4.0")con.open "select the path of the database"rs.open "enter sql querry",con

Answer Question  Select Best Answer

Srinivas Ellendula

 Profile Answers by Srinivas Ellendula Questions by Srinivas Ellendula

• May 13th, 2007

Check is there any high CPU using , u can find the infomartion by using below commands in SOLARIES/AIX servers.nmonsudo topasvmstat 1 10sar 1 10topRegardsSrinivas Ellendula

Srinivas Ellendula

 Profile Answers by Srinivas Ellendula Questions by Srinivas Ellendula

• May 13th, 2007

First  of all check the process running on that server...if the idle process is 0, look  if there are any run away processes taking most of the CPU and find exactly what it is doing... ...

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Dec 1st, 2007

Try thisCREATE OR REPLACE FUNCTION FIN2008.rowtocol( p_slct IN VARCHAR2,p_dlmtr IN VARCHAR2 DEFAULT ',' ) RETURN VARCHAR2AUTHID CURRENT_USER ASTYPE c_refcur IS REF CURSOR;lc_str VARCHAR2(4000)...

ora.nachs

 Profile Answers by ora.nachs Questions by ora.nachs

• Feb 5th, 2007

we can also do this by insert all statement.....INSERT ALLINTO sales_info VALUES (employee_id,week_id,sales_MON)INTO sales_info VALUES (employee_id,week_id,sales_TUE)INTO sales_info VALUES (employee_i...

Answer Question  Select Best Answer

Diwakar

• Oct 20th, 2017

AWR-Automiatic Workload repository is the report which provides finer details of work that was performed on DB during specific period. It provides following important details 1. Wait events causing...

Ora-Masala

• May 4th, 2016

The AWR is used to collect performance statistics including: Wait events used to identify performance problems. Time model statistics indicating the amount of DB time associated with a process fro...

Answer Question  Select Best Answer

ANURAG

• Oct 22nd, 2016

How do we configure that? Any help would be appreciated...

Enamul

 Profile Answers by Enamul Questions by Enamul

• Jul 9th, 2008

At first configure webconfig file that have in server folder.

Answer Question  Select Best Answer

I have read somewhere as DDL statement as it has implicit commit statement.

Chiranjeevi Manne

• Mar 30th, 2007

TRUNCATE is a DDL statement which can't be rolled back as there won't be any redolog generated during the trun operation and it is the fastest way of dropping big tables avoiding tons and tons of redolog generation.

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

Other point it will not fire any trigers so it is fast .and it releases the storage space also. where delete command slower than truncate command fires triggers

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

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

nandk.sharma

 Profile Answers by nandk.sharma Questions by nandk.sharma

• Jun 16th, 2008

nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function r...

thumunagamani

 Profile Answers by thumunagamani Questions by thumunagamani

• Jun 13th, 2008

Nvl2(exp1,exp2,exp3)if exp1 is null it manipulate exp3,if exp1 is not null it manipulates exp2eg:select ename,nvl2(comm,comm+sal,sal) net from emp;

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

gtomar

 Profile Answers by gtomar Questions by gtomar

• Jul 25th, 2008

Select sum(sal) from (select distinct sal from emp order by sal desc) where rownum < 4try this

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

YOU CAN USE DENSE RANK TO RETRIEVES MAX SALARIES AND EMPLOYEES DETAILSSELECT * FROM ( SELECT A.* ,DENSE_RANK () OVER ( ORDER BY SALARY DESC ) R FROM EMPLOYEES A) WHERE R

Answer Question  Select Best Answer

kmuddana

 Profile Answers by kmuddana Questions by kmuddana

• Apr 30th, 2008

Select top1 * from in SQL Server

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 12th, 2007

SELECT * FROM EMPLOYEES WHERE ROWNUM=1; IN ORACLE

Answer Question  Select Best Answer

Diwakar

• Oct 20th, 2017

Anonymous block is independent piece of code to implement certain pseudo code. subprogram are some named entities like procedure and function which can be invoked from outside window.

YES procedure can be invoked using anonymous block.

Nupur

• Apr 25th, 2015

Answer to second part of the question : yes we can call a procedure from an anonymous block

Answer Question  Select Best Answer

prashant.kathole

 Profile Answers by prashant.kathole Questions by prashant.kathole

• Nov 11th, 2008

select distinct sal from emp e where &n=(select count(distinct sal) from emp where e.sal<=sal);

Geetha

• Nov 5th, 2007

Select distinct sal from emp e where &n=(select count(distinct sal) from emp where e.sal>=sal);

Answer Question  Select Best Answer