Training Test 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”

Solution for Test Your Knowledge 1

Kindly note that there are various ways to arrive at solution of the questions listed below. The solutions shared below is just to help you in arriving at a solution. Q1. Create Table Students with following fields & Write 2 insert statements for it. First field will be used as a unique identifier for theContinue reading “Solution for Test Your Knowledge 1”

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”

Test Your Knowledge 1

You can test to basic SQL & PL/SQL knowledge using the following listed questions. Q1. Create Table Students with following fields & Write 2 insert statements for it. RollNo integer 10 => Auto Increment FName string 50 LName string 50 DOB Date => Date of Birth Add1 string 150 Add2 String 150 City String 100Continue reading “Test Your Knowledge 1”