Answer / Amber Goel

Creating a memory-optimized table can offer several benefits, such as faster data access due to the in-memory storage design, reduced disk I/O operations, and improved query performance for complex data manipulation tasks. However, it's important to note that these tables require more memory than traditional disk-based tables.

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

Why is there a need for sqlcode and sqlerrm variables?

1 Answers  

---

Can cursors be part of a trigger body?

1 Answers  

---

What do you understand by case manipulation functions?

1 Answers  

---

What are the features of pl sql?

1 Answers  

---

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1 Answers   Prodapt,

---

Explain foreign key in sql?

1 Answers  

---

Can we update views in sql?

1 Answers  

---

Does a user_objects view have an entry for a trigger?

1 Answers  

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

Is grant a ddl statement?

1 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1 Answers  

---