Answer / nishi

Database trigger is a stored procedure that invokes automatically when a predefined event occurs.The usage of database trigger is to audit the data modification.

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

---

I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.

6 Answers  

---

List the types of joins used in writing subqueries?

0 Answers  

---

How much memory your 10g xe server is using?

0 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  

---

Is it possible to enter only time value into a column of a table in sql?

2 Answers  

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

0 Answers  

---

interview questions with answer for cts

0 Answers   Cognizant,

---

when loggined as SYSTEM,how to display all the users of database using sql query?

2 Answers  

---

Explain temporal data types in oracle

0 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

How can we view last record added to a table?

0 Answers  

---