Answer Posted / iamanocp

Answer is b.
b. select/from/table_name/groupby/having/orderby

How many sql statements are used? Define them.

571

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

549

---

What are different types of triggers?

548

---

How do you optimize a query?

528

---

Can you sum a count in sql?

549

---

---

What is foreign key and example?

502

---

What is full join in sql?

516

---

What is rank dense_rank and partition in sql?

531

---

What is the difference between local variables and global variables?

600

---

What is difference between stored procedure and trigger?

527

---

Which constraints we can use while creating database in sql?

606

---

What are conditional predicates?

579

---

What is procedure and function in sql?

524

---

How do I partition a table in sql?

531

---

How can we link a sql database to an existing android app?

542

---