write the Sql query for creating database backup?

7 Answers   TCS,

---

Is left join faster than inner join?

0 Answers  

---

what are string data types? : Sql dba

0 Answers  

---

What is number function in sql?

0 Answers  

---

Give me some examples of predefined exceptions.

3 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What are pl/sql packages?

0 Answers  

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

can we create index on index?

7 Answers   iFlex, Symphony,

---