Question
Oracle SQL questions 1. what is output of this query SELECT e.role, j.jobtitle, j.jobname from employee e left outer join jobs j on (e.jobtitle =
Oracle SQL questions
1. what is output of this query
SELECT e.role, j.jobtitle, j.jobname from employee e left outer join jobs j on (e.jobtitle = j.jobtitle)
2. What is the output of this query
select * from table where tableid = null
3. What is the output if subquery returns no rows.
select name, date, job from table where name = (select name from table where name = "David")
4. You can place the subquery in ____ of SELECT statement
where, having, from, all of the above
5. Which is false about single-row functions
accept arguments and return one value per argument, manipulate data items, act on each returned row, can be nested
6. Which is false about group functions
cant use where to restrict group, use having to restrict groups, cant use group functions in where clause
7. What is returned if name column contains Nulls
select name, date, job from table where name NOT IN (select name from table)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started