Test your knowledge by answering following questions. Note: Kindly use the below mentioned tables only from HR Schema. Don’t create your own tables. Sample out will be shown on for 10 records. There are various ways to arrive at solution of the questions listed below. The solutions shared below is just to help you inContinue reading “Solution for Test Your Knowledge 2”
Tag Archives: Oracle Assignment
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. RollNo integer 10 => Auto Increment FName string 50 LName stringContinue 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”
