Read Best Answer

Editorial / Best Answer

RicGupta1984  

 Profile Answers by RicGupta1984 Questions by RicGupta1984

• Member Since Sep-2007 | Mar 5th, 2008

---

A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some uniform methods independent of a specific application for accessing the information that is stored.

RDBMS is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables. This excludes the databases that don't support a tabular structure or don't enforce relationships between tables.

Many DBA's think that RDBMS is a Client Server Database system but thats not the case with RDBMS.

Yes you can say DBMS does not impose any constraints or security with regard to data manipulation it is user or the programmer responsibility to ensure the ACID PROPERTY of the database whereas the rdbms is more with this regard bcz rdbms difine the integrity constraint for the purpose of holding ACID PROPERTY.

asif shaikh

• Nov 22nd, 2014

And other major difference are dbms does not support constraints and normalization.

prashant_hcu

 Profile Answers by prashant_hcu Questions by prashant_hcu

• Aug 1st, 2010

DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to provide some un...

Improve 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

Ashwini

• Jan 25th, 2018

Procedure - Definition - Procedure is a program unit or a module that performs a particular task. Execution - A stored procedure is executed explicitly by issuing procedure call Parameters - St...

qptopm

 Profile Answers by qptopm Questions by qptopm

• Nov 3rd, 2016

Commit cannot be done in case of triggers except for autonomous transactions. When you create a trigger you have to identify event and action of your trigger. Triggers are implicitly called by DB itself

Answer Question  Select Best Answer

ashu

• Mar 20th, 2013

Are you talking about EF Codds 12 rules?

I seem to recall that Oracle has satisfied MAX of 12, with the exception being that the empty string is treated as a NULL.

rojalinpanigrahi

 Profile Answers by rojalinpanigrahi Questions by rojalinpanigrahi

• Sep 30th, 2008

Oracle should satisfy 13 rules of codd

Answer Question  Select Best 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

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

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

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

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

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

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