Answer Posted / avi007

DBMS-Database management system.
1> consider as file says field,attributes,record and file.
2> table relationship mentained by programmaticaly.
3> high network trafic.
4> distributed datable not supported.
5> no security

RDBMS-Relational management system
1> says column, row and table.
2>table relationship mentained at the time of table
creations.
3>low network trafic.
4>distributed database supported.
5>login level security.

How global cursor can be declare with dynamic trigger ?

2210

---

How do you remove duplicate records from a table?

940

---

What is a left inner join?

1015

---

explain the difference between myisam static and myisam dynamic. : Sql dba

944

---

what is sql? : Sql dba

1030

---

Does execute immediate commit?

1221

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

953

---

What is scalar and vector?

1004

---

What is compiled query?

1037

---

What is difference between sql and mysql?

1133

---

Explain the purpose of %type and %rowtype data types with the example?

995

---

what is bcp? When is it used?

1112

---

What is right join in sql?

1091

---

What happens when a trigger is associated to a view?

915

---

Can we create table in function?

965

---