Answer / Nupur Tandon

'mysqladmin' is a command-line utility provided by MySQL. You can use it to perform various administrative tasks, including checking the server status. To check the server status, run: mysqladmin ping

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

How to fetch records from a partitioned table?

2 Answers   HSBC,

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---

What is the left table in sql?

1 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

what is ref cursor in pl/sql?

3 Answers  

---

Does inner join return duplicate rows?

1 Answers  

---

explain what is mysql? : Sql dba

1 Answers  

---

What is the purpose of primary key?

1 Answers  

---

What is oracle sql developer?

1 Answers  

---