How to change system global area (sga) in oracle?

0 Answers  

---

Explain view?

0 Answers  

---

What does `(+)` do in a where clause?

1 Answers  

---

How to join two tables in a single query using oracle?

0 Answers  

---

What is the difference between truncate & delete command?

0 Answers  

---

---

how to get count of tables in particular database in Oracle?

3 Answers  

---

Can we connect to ORACLE db using Windows Authentication?

0 Answers   MCN Solutions,

---

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

6 Answers   Mind Tree,

---

How many types of synonyms in Oracle?

0 Answers   MCN Solutions,

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---