Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through
1 6546Post New Azri Solutions Interview Questions
What is the usage of sql functions?
Why there is actually a need for the businesses to invest in a RDBMS tool in the present time?
What is vlookup and how does it work?
How do you find the independent variable?
Why use oops?
Explain about confusion matrix in r?
What is a metadata in .net?
Should I install spark on all nodes of yarn cluster?
Mention two ways of binding supported by JSF?
Explain what are the different action types in peoplesoft? (Add / update / correct history/ include history)?
What icon is used in WinRunner to get an explanation of the syntax of TSL?
Differentiate between Funds Flow and Cash Flow statements?
Why does apple use swift?
List the different types of files that can be made available with unix?
Define User Objects?