Answer Posted / anand

DBMS IS THE DATA BASE MANAGEMENT SYSTEM
RDBMS IS THE RELATIONAL DATA BASE MANAGEMENT SYSTEM


DBMS IS THE SINGLE USER
RDBMS IS THE MULTI USER


DBMS - THERE IS NO TABLES
RDBMS - THERE IS TABLES

DBMS - THERE IS NO LOGIC
RDBMS - LOGIC IS THERE

DBMS - THERE IS NO LOGIC SO COMPLEXITY IS HIGH
RDBMS - HERE LOGIC IS THERE SO COMPLEXITY IS LESS

DBMS - DATA CAN BE STORED IN FILES
RDBMS - DATA CAN BE STORED IN DBMS

What is an oracle function?

1133

---

Explain the use of compress option in exp command.

1004

---

How to initialize variables with default values?

1214

---

What are the differences between blob and clob in oracle?

1066

---

What is the relationship among database, tablespace and data file?

965

---

Where do we use decode and case statements?

987

---

What are the attributes that are found in a cursor?

1045

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1675

---

What is the difference between a hot backup and a cold backup in oracle?

998

---

Explain an exception and its types?

1052

---

What do you mean by merge in oracle and how can you merge two tables?

935

---

How do I limit the number of oracle database connections generated by weblogic server?

1052

---

How to select some columns from a table in oracle?

1064

---

In oracle there is column command, how will you explain that?

1020

---

How to name query output columns in oracle?

1166

---