Docsity
Log inSign up
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search Store documents

The best documents sold by students who completed their studies

Search through all study resources
Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

University Rankings

Discover the best universities in your country according to Docsity users

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

From our blog

Exams and Study
Go to the blog

Oracle 11g Practice Exercises: Set Operations, Exercises of Database Programming

Central New Mexico Community College (CNM)Database Programming

A set of practice exercises for oracle 11g, focusing on the use of set operators in sql queries. The exercises cover various scenarios, including finding departments without a specific job id, identifying countries without departments, creating lists of jobs for specific departments, and identifying employees with the same job id as their initial job. Each exercise includes a clear description and a sql query to solve the problem. Suitable for students learning sql and set operations in oracle 11g.

Typology: Exercises

2021/2022

Uploaded on 10/24/2024

javier-ivan-cervantes-armenta
javier-ivan-cervantes-armenta 🇺🇸

5 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Universidad Autónoma de Querétaro
Facultad de Informática
Diplomado de Oracle 11g
Práctica 10
Instrucciones: Cree las siguientes consultas. Adjunte, para cada ejercicio, la captura de pantalla del
resultado.
1. Mediante operadores de conjuntos, enumere los identificadores de departamentos, para
departamentos que no contienen el id de cargo ST_CLERK.
SELECT department_id
FROM employees
MINUS
SELECT department_id
FROM job_history
WHERE job_id = 'ST_CLERK'
pf3
pf4
pf5

Partial preview of the text

Download Oracle 11g Practice Exercises: Set Operations and more Exercises Database Programming in PDF only on Docsity!

Universidad Autónoma de Querétaro Facultad de Informática Diplomado de Oracle 11g Práctica 10 Instrucciones: Cree las siguientes consultas. Adjunte, para cada ejercicio, la captura de pantalla del resultado.

  1. Mediante operadores de conjuntos, enumere los identificadores de departamentos, para departamentos que no contienen el id de cargo ST_CLERK. SELECT department_id FROM employees MINUS SELECT department_id FROM job_history WHERE job_id = 'ST_CLERK'
  1. Mediante operadores de conjuntos, visualice el identificador de país y el nombre de los países que no tengan departamentos ubicados en ellos. SELECT COUNTRY_ID,COUNTRIES.COUNTRY_NAME FROM COUNTRIES MINUS SELECT a.COUNTRY_ID,b.COUNTRY_NAME FROM LOCATIONS a JOIN COUNTRIES b ON (a.COUNTRY_ID = b.COUNTRY_ID) JOIN DEPARTMENTS c ON c.LOCATION_ID = a.LOCATION_ID;
  1. Enumere los identificadores de empleado y de cargo de los empleados que actualmente tengan el cargo que ocupaban al momento de comenzar a trabajar con la compañía. SELECT EMPLOYEE_ID, JOB_ID FROM employees INTERSECT SELECT EMPLOYEE_ID, JOB_ID FROM JOB_HISTORY;
  1. Escriba una consulta que enumera: a. Apellido e identificadores de departamento de todos los empleados de la tabla EMPLOYEES, independientemente de si pertenecen o no a algún departamento. b. Identificador y nombre de departamento de todos los departamentos de la tabla DEPARTMENTS, independientemente de si tienen o no empleados trabajando en ellos. SELECT last_name, department_id, TO_CHAR(null) department_name FROM employees UNION SELECT TO_CHAR(null), department_id, department_name FROM departments;