QUESTION: 49

Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them. Which SQL statement must you use?

SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c. department_id);
SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c. department_id);
SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d. department_id);
SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d. department_id);

Answer(s): B

Show Answer Next Question

QUESTION: 50

Which two tasks can be performed by using Oracle SQL statements? (Choose two.)

changing the password for an existing database user
connecting to a database instance
querying data from tables in different databases
starting up a database instance
executing operating system (OS) commands in a session

Answer(s): A,C

Reference:

http://www.techonthenet.com/oracle/password.php https://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm

Show Answer Next Question

QUESTION: 51

View the exhibit for the structure of the STUDENT and FACULTY tables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location.
Examine the following two SQL statements:

Statement 1

SQL>SELECT faculty_name, COUNT(student_id)
FROM student JOIN faculty
USING (faculty_id, location_id)
GROUP BY faculty_name;

Statement 2

SQL>SELECT faculty_name, COUNT(student_id)
FROM student NATURAL JOIN faculty
GROUP BY faculty_name;

Which statement is true regarding the outcome?