Welcome to TechOraFAQ
All about SQL & PL/SQL
Latest from the Blog
Few more questions
Q1. What is sysdate? Is it a pseudo column or system variable or a function?Ans. It is a function. Q2. Which one is faster Delete or Truncate?Ans. Truncate is faster. Q3. Can we use Decode function is PL/SQL without SQL statement?Ans. No. Q4. Can a primary key column have a null value?Ans. No. Q5. Can…
Solution for Test Your Knowledge 2
Test your knowledge by answering following questions. Note: • COUNTRIES • DEPARTMENTS • EMPLOYEES • JOBS • JOB_HISTORY • LOCATIONS • REGIONS 1. Write a query in SQL to display the first name, last name, department number, and department name for each employee. Solution: 2. Write a query in SQL to display the first and…
Get new content delivered directly to your inbox.
TechOraFAQ 