UPS interview questions

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

Setup an appointment with the interviewer. Interviewed with a large group of applicants. They took us on a tour of the building during one of the shifts. It gave us an idea the job consists of and what we would be doing.