Question 96
Which three statements are true regarding the WHEREand HAVINGclauses in a SQL statement? (Choose three.)
Question 97
Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:
You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?
You want to generate a report that shows all course IDs irrespective of whether they have corresponding department IDs or not but no department IDs if they do not have any courses.
Which SQL statement must you use?
Question 98
Examine the structure proposed for the TRANSACTIONStable:
Which two statements are true regarding the creation and storage of data in the above table structure?
(Choose two.)
Which two statements are true regarding the creation and storage of data in the above table structure?
(Choose two.)
Question 99
Examine the structure of the PROGRAMS table:
Which two SQL statements would execute successfully? (Choose two.)
Which two SQL statements would execute successfully? (Choose two.)
Question 100
View the exhibit and examine the description of the DEPARTMENTSand EMPLOYEEStables.
The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following SQL statement was written:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?
The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, the following SQL statement was written:
SELECT employee_id, first_name, department_name
FROM employees
NATURAL JOIN departments;
The desired output is not obtained after executing the above SQL statement. What could be the reason for this?