Does pl/sql support create command?

0 Answers  

---

What is the main difference between sql and pl/sql?

0 Answers  

---

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

0 Answers  

---

Can we rename a column in the output of sql query?

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

How to execute a stored procedure?

0 Answers  

---

What is the difference between a database and a relational database?

0 Answers  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

What is a schema? How is it useful in sql servers?

0 Answers  

---