Oracle SQL 9i, Databases

Question: Which type of join will you write to perform an outer join of tables A and B that returns all rows from B-:
A
Any outer join

B
A left outer join

C
A cross join

D
A right outer join

E
An inner join

Note: Not available
1. Report
Question: You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which of the following statements will accomplish this task?
A
ALTER TABLE students ADD PRIMARY KEY student_id;

B
ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);

C
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

D
ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

E
ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

Note: Not available
1. Report
Question: Which of the following SQL statements should be used to remove a view called EMP_DEPT_VU from the schema?
A
DROP emp_dept_vu;

B
DELETE emp_dept_vu;

C
REMOVE emp_dept_vu;

D
DROP VIEW emp_dept_vu;

E
DELETE VIEW emp_dept_vu;

F
REMOVE VIEW emp_dept_vu;

Note: Not available
1. Report
Question: _______ operator can be used with a multiple row subquery.
A
=

B
LIKE

C
BETWEEN

D
NOT IN

E
Is

Note: Not available
1. Report
Question: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4, 3) Which of the following statements finds the highest Grade Point Average (GPA) per semester?
A
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;

B
SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

C
SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

D
SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;

E
SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Note: Not available
1. Report

First Prev 3 4 5 Next Last

Question: Which type of join will you write to perform an outer join of tables A and B that returns all rows from B-:

Question: You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which of the following statements will accomplish this task?

Question: Which of the following SQL statements should be used to remove a view called EMP_DEPT_VU from the schema?

Question: _______ operator can be used with a multiple row subquery.

Question: The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER (12) SEMESTER_END DATE GPA NUMBER (4, 3) Which of the following statements finds the highest Grade Point Average (GPA) per semester?