PL SQL basic questions. Overall it was good.
1) How do you select all columns from a table
2) What is DML and DDL
3) How do you get current date. How to get next date of a particular month
4) Employee table
Hr := 10;
Dev := 20;
Testing := 30
Each dept 5 employee
ID dept salary are columns. Find highest salary of each dept
5) Create sequence syntax
6) How do find a long running query in DB
7) Define constraint, What are types of constraint
8) What is the use of V$SESSION
9) Basic pL SQL block
10) Table A has 10 million data, write a procedure to put all data in table B
11) Example for exception handling
12) What is a synonym give example