Answer / Avdhesh P.singh

A table stores data in rows and columns, while a view is a virtual table that does not physically store any data. Instead, it represents a select statement that is executed each time the view is referenced. A view can be used to simplify complex queries, provide security by limiting access to certain data, or combine data from multiple tables.

Explain what are the uses of rollback segment?

1 Answers  

---

What is the difference between SQL and SQL Server?

2 Answers   CTS, TCS,

---

How to convert a date to char in oracle? Give one example.

1 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

What happens to the current transaction if the session is killed?

1 Answers  

---

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  

---

Why we choose emp number as primarykey?

4 Answers  

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

How to create a new oracle data file?

1 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

Explain do view contain data?

1 Answers  

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

1 Answers  

---