Answer Posted / madhuri

SQL is a structured query language used for various
operations such as retrieval,manipulation of data using
DML,DDL statements.

PL/SQL is programming language used to write various sql
statements together.Advantage of pl/sql over sql is,you can
write many sql statements within a pl/sql block.One more
advantage is subprogramming like procedures and functions.
We can write cursors for fetching number of records at a time.
And also packages and triggers.

Embedded sql are those statements which are written in host
programs like pro*c,java etc.

What is the use of prepared statement?

951

---

What is the difference between inner join and outer join?

928

---

what is an index? : Sql dba

924

---

What is mutating error in pl sql?

961

---

Explain scalar functions in sql?

1014

---

How do I order by ascending in sql?

954

---

How would you convert date into julian date format?

946

---

how many tables will create when we create table, what are they? : Sql dba

1018

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

952

---

What is transaction control language (tcl)?

1069

---

what are the differences between char and varchar? : Sql dba

1000

---

What is the difference between mdf and ndf files?

1060

---

What is the purpose of a sql?

909

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

915

---

What is online transaction processing (oltp)?

959

---