Answer Posted / nashiinformaticssolutions

• SQL (Structured Query Language):
o Used to interact with databases (e.g., querying, inserting, updating data).
o Declarative in nature.
• PL/SQL (Procedural Language/SQL):
o Procedural extension of SQL in Oracle.
o Supports loops, conditions, and error handling.
o Used for creating functions, triggers, and stored procedures.

What are the different types of sql commands?

1055

---

Is sql a programming?

932

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

890

---

Explain how can you save or place your msg in a table?

978

---

How to sort the rows in sql.

1002

---

What is mutating trigger?

965

---

What are sql constraints?

1120

---

Which sql statement is used to delete data from a database?

895

---

What are the uses of sysdate and user keywords?

1045

---

What are the datatypes available in pl/sql ?

1041

---

What is the process of debugging?

999

---

What is a delimiter in sas?

972

---

how to check server status with 'mysqladmin'? : Sql dba

1009

---

What is composite primary key in sql?

935

---

Explain the methods used to protect source code of pl/sql.

956

---