Answer / mubarish

Join index will not affected until we change the column name
or data type of the column which we have used in join condition.

Answer / suresh babu

Nothing will happen,until you alter the index column

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

how to convert character strings to dates? : Sql dba

0 Answers  

---

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

---

How do rank () and dense_rank () differ?

0 Answers  

---

---

How do we tune the code?

2 Answers  

---

How do I remove sql developer from windows 10?

0 Answers  

---

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

What is bind reference and how can it be created?

0 Answers  

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---