Question 41
Examine this business rule:
Each student can work on multiple projects and each project can have multiple students. _ You must design an Entity Relationship (ER) model for optimal data storage and allow for generating reports in this format:
STUDEN_ID FIRST_NAMK LASTNAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true?
Each student can work on multiple projects and each project can have multiple students. _ You must design an Entity Relationship (ER) model for optimal data storage and allow for generating reports in this format:
STUDEN_ID FIRST_NAMK LASTNAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true?
Question 42
View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.
Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT employee_id
FROM employees
WHERE job_id = 'SA_MAN'
-------------------------------------
SELECT employee_id
FROM job_history
WHERE job_id='SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result. (Choose two.)
Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT employee_id
FROM employees
WHERE job_id = 'SA_MAN'
-------------------------------------
SELECT employee_id
FROM job_history
WHERE job_id='SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result. (Choose two.)
Question 43
View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.
Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT EMPLOYEE_ID
FROM EMPLOYEES
WHERE JOB_ID = 'SA_MAN'
-------------------------------------
SELECT EMPLOYEE_ID
FROM JOB_HISTORY
WHERE JOB_ID = 'SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result.
Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.
SELECT EMPLOYEE_ID
FROM EMPLOYEES
WHERE JOB_ID = 'SA_MAN'
-------------------------------------
SELECT EMPLOYEE_ID
FROM JOB_HISTORY
WHERE JOB_ID = 'SA_MAN';
Choose two correct SET operators which would cause the query to return the desired result.
Question 44
Evaluate the following statement.
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?
Question 45
Which statement is true regarding the INTERSECT operator?