SQL and PL/SQL Questions

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 andContinue reading “Solution for Test Your Knowledge 2”

Test Your Knowledge 2

Test your knowledge by answering following questions. Note: Kindly use the below mentioned tables only from HR Schema. Don’t create your own tables. • COUNTRIES • DEPARTMENTS • EMPLOYEES • JOBS • JOB_HISTORY • LOCATIONS • REGIONS Write a query in SQL to display the first name, last name, department number, and department name forContinue reading “Test Your Knowledge 2”

Analytical Functions

Q1. What is Rollup? Answer. ROLLUP produces group subtotals from right to left and a grand total. If “n” is the number of columns listed in the ROLLUP, then there will be n+1 levels of subtotals. FACT1_ID FACT2_ID SALES_VALUE 1 1 4363.55 1 2 4794.76 1 3 4718.25 1 4 5387.45 1 5 5027.34 1Continue reading “Analytical Functions”

General SQL & PL/SQL

Q1. Difference between DBMS & RDBMS Answer. DBMS RDBMS Data is stored in form of files. Data is stored in form of tables. Normalization is not applied. Normalization is applied. Relations between different data is not set as data is stored in form of files. Relationship between tables can be set as data is storedContinue reading “General SQL & PL/SQL”