Answer / Prabhat Rawat

System Identifier (SID) in Oracle is a unique identifier for an instance of the Oracle Database. It helps the client to connect to the correct database instance.

What are a query and state the different types of queries and their uses?

1 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

What is query image?

1 Answers  

---

write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,

---

How do I know if oracle client is installed on windows?

1 Answers  

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

1 Answers   CTS,

---

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

2 Answers  

---

How to insert a new row into a table in oracle?

1 Answers  

---

What is the purpose of save points in oracle database?

1 Answers  

---

What is a named program unit?

1 Answers  

---

State all possible different index configurations a table can possibly have?

1 Answers  

---

What is a system tablespace and when it is created?

1 Answers  

---