Answer Posted / dinesh

Its not batter to modify where clause column with function(Performance issue). So we need to create function based index. Eg.
Create Index Fun_indx on EMP (UPPER(FIRST_NAME).
we can't create function based index on aggregate function.
but we can create NVL function as function.
also we can create function based index on user define function but function should be"DETERMINISTIC".
eg
create or replace function fun_index(a in number) Return
Number DETERMINISTIC IS
BEGIN
'''
,,,
END;

Explain the difference in execution of triggers and stored procedures?

1063

---

What is record type in pl sql?

1036

---

What type of database is cloud sql?

1158

---

how many ways we can we find the current date using mysql? : Sql dba

1145

---

Name the different types of indexes in sql and define them.

1222

---

What are different methods to trace the pl/sql code?

1171

---

What does fetching a cursor do?

1133

---

What is bind reference and how can it be created?

1068

---

where are cookies actually stored on the hard disk? : Sql dba

1079

---

How is use pl and sql?

1108

---

What are all ddl commands?

1129

---

Explain the insert into statements in sql?

1053

---

What is varchar data type in sql?

1138

---

What is the difference between drop and truncate commands?

1110

---

What are the benefits of stored procedures?

1126

---