Base de datos

CREATE TABLE employees(

Nro_empleado NUMBER(6),

Nombre VARCHAR2(25) NOT NULL,

email VARCHAR2(25),

Salario NUMBER(8,2),...

CONSTRAINT emp_email_uk UNIQUE(email));

• · crea una tabla con campo primario

• · Crea una tabla con campo no repetitivo

• · Crea tabla con campo Foraneo

• · Hay error en la instrucción

CONSTRAINT emp_dept_fk FOREIGN KEY (department_id)

REFERENCES departments(department_id),

CONSTRAINT emp_email_uk FOREIGN KEY (email));

• · · Me crea un CONSTRAINT Unique

• · Hay error en el comando

• · Este comando sirve para crear una llave foránea

• Ninguna

UPDATE employees

SET department_id = 60

WHERE department_id = 110;

• 1. Este comando me permite en la tabla employees modificar department_id de 110 a 60

• 1. Este comando me permite en la tabla employees modificar department_id de 60 a 110

• 1. Actualiza datos de la tabla employees

• 1. Error en el comando

DELETE FROM locations

WHERE country_id = 60;

• Este borra los campos de la tabla locations los campos country igual a 60

• No se puede ejecutar este comando por integridad referencial

• Esta mal ejecutado el comando

• Borra countrys solo con nuero 60 de cualquier tabla

Mostrar el apellido y el salario de los empleados que ganan entre $ 50 y $ 100 y están en el departamento 20 o 50. Etiquete las columnas Empleado y Salario mensual, respectivamente.

• SELECT last_name as "empleado", salary as "salario mensual"

  FROM employees

  WHERE salary BETWEEN 50 AND 100

  AND (department_id = 50 ,20);

• SELECT last_name as "empleado", salary as "salario mensual"

  FROM employees

  WHERE salary BETWEEN 50 OR 100

  AND (department_id = 50 OR department_id = 20);

• SELECT last_name as "empleado", salary as "salario mensual"

  FROM employees

  WHERE salary BETWEEN 50 AND 100

  AND (department_id = 50 AND department_id = 20);

• SELECT last_name as "empleado", salary as "salario mensual"

  FROM employees

  WHERE salary BETWEEN 50 AND 100

  AND (department_id = 50 OR department_id = 20);

El departamento de recursos humanos necesita un informe que muestre el apellido y la fecha de contratación de todos los empleados que fueron contratados en 2010.

• SELECT last_name, hire_date

  FROM hr.employees

  WHERE hire_date == '2010';

• SELECT last_name, hire_date

  FROM hr.employees

  WHERE hire_date LIKE '%10%';

• SELECT last_name, hire_date

  FROM hr.employees

  WHERE hire_date LIKE '%10';

• Ninguna

Cree un informe para mostrar el apellido, salario y comisión de todos los empleados que ganan comisiones. Ordene los datos en orden ascendente de salario y comisiones

• SELECT last_name, salary, commission_pct

  FROM hr.employees

  WHERE commission_pct NOT null

  ORDER BY salary, commission_pct asc;

• SELECT last_name, salary, commission_pct

  FROM employees

  WHERE commission_pct > 0

  ORDER BY salary, commission_pct;

• SELECT last_name, salary, commission_pct

  FROM employees

  WHERE commission_pct > 0

  ORDER BY commission_pct;

• SELECT last_name, salary, commission_pct

  FROM employees

  WHERE commission_pct = null

  ORDER BY salary, commission_pct;

mostrar el apellido y el salario de los empleados que ganan entre $ 10,000 y $ 20,000 y están en el departamento 60 Y 70. Etiquete las columnas Empleado y Salario mensual, respectivamente

• select last_name as "Empleado", salary as "DSalario"

  from employees

  where salary between 10000 and 20000 and (department_id=60 or department_id=70)

• select last_name as "Empleado", salary as "DSalario"

  from employees

  where salary between 10000 and 20000 and (department_id=60 AND department_id=70)

• select last_name as "Empleado", salary as "Salario"

  from employees

  where salary between 10000 and 20000 and NOT IN (department_id=60, department_id=70)

• Ninguno

mostrar el apellido y el salario de los empleados que ganan entre $ 5,000 y $ 12,000 y están en el departamento 20 o 50. Etiquete las columnas Empleado y Salario mensual, respectivamente

• select last_name as "Employee", salary as "Month Salary"

  from employees

  where salary > 5000 and salary > 12000 and (department_id=20 or department_id=50)

• select last_name as "Employee", salary as "Month Salary"

  from employees

  where salary between 5000 and 12000 and (department_id=20 AND department_id=50)

• select last_name as "Employee", salary as "Month Salary"

  from employees

  where salary between 5000 and 12000 and (department_id=20 or department_id=50)

• Ninguna

El señor Edgar Frank Codd, da los conceptos

• Modelo jerárquico

• Base de Datos Relacionales

• Crea la primera BD

• Ninguna