Answer Posted / rutujagabhane

select* from tab; gives you the o/p as a table containing rows and columns. The rows contain the name of table ,select count(1) from tab returns the no or rows in tab .
Indirectly the statement returns no of tables in tab;

Why trigger is used in sql?

525

---

Which is faster count (*) or count 1?

535

---

How is a PL/SQL code compiled?

666

---

What are types of joins?

532

---

What port does sql server use?

502

---

---

What are the different schemas objects that can be created using pl/sql?

521

---

What is normalisation and its types?

543

---

How do I use google cloud in sql?

535

---

define join and explain different type of joins? : Sql dba

542

---

Is postgresql a server?

573

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3195

---

Which is better join or inner query?

513

---

What are the two virtual tables available at the time of database trigger execution?

628

---

What is the largest value that can be stored in a byte data field?

516

---

Why truncate is faster than delete?

556

---