Written 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”

Written Test Questions

Q1. From the following SQL Statements which one is the most reliable? Answer. E] is the most reliable statement. Q2. From the following statements which one will you prefer to use & why? Answer. B] as select will consume more time than PL/SQL code. Q3. Which relational operators in where clause results in non-usage ofContinue reading “Written Test Questions”