Answer Posted / bolearner

There are 2 ways used to find the row count of any table.

SELECT COUNT(*) FROM EMP;

SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='EMP';

Can triggers stop a dml statement from executing on a table?

1101

---

What is meant by user defined function?

1054

---

Define join and name different types of joins?

1008

---

explain primary keys and auto increment fields in mysql : sql dba

980

---

How delete all records from table in sql?

981

---

what is the use of set statement in tsql? : Transact sql

1011

---

What is Collation Sensitivity ? What are the various type ?

954

---

What is varchar data type in sql?

1088

---

Can a commit statement be executed as part of a trigger?

1055

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1067

---

Why is pl sql needed?

952

---

What are inbuilt functions in sql?

1066

---

Is sql a backend language?

1100

---

Differentiate between pl/sql and sql?

1153

---

Is left join same as inner join?

1134

---