| Question ID 1714 | You need to design a student registration database that contains several tables storing academic information.
The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.
You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?
|
| Option A | A. CREATE TABLE student_grades
(student_id NUMBER(12),
semester_end DATE,
gpa NUMBER(4,3),
CONSTRAINT student_id_fk FOREIGN KEY (student_id)
REFERENCES students(student_id));
|
| Option B | B. CREATE TABLE student_grades (student_id NUMBER(12),
semester_end DATE,
gpa NUMBER(4,3),
CONSTRAINT FOREIGN KEY (student_id) REFERENCES students(student_id));
|
| Option C | C. CREATE TABLE student_grades
(student_id NUMBER(12),
semester_end DATE,
gpa NUMBER(4,3),
CONSTRAINT student_id_fk REFERENCES (student_id)
FOREIGN KEY students(student_id));
|
| Option D | D. CREATE TABLE student_grades
(student_id NUMBER(12),
semester_end DATE,
gpa NUMBER(4,3),
student_id_fk FOREIGN KEY (student_id)
REFERENCES students(student_id));
|
| Correct Answer | A |
| Question ID 1715 | Examine the description of the MARKS table:
STD_ID NUMBER(4)
STUDENT_NAME VARCHAR2(30)
SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ3 NUMBER(3)
SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects.
Which two statements are valid? (Choose two.)
|
| Option A | A. SELECT COUNT(std_id) FROM marks
WHERE subj1 >= AVG(subj1);
|
| Option B | B. SELECT SUM(subj1), SUM(subj2), SUM(subj3) FROM marks;
|
| Option C | C. SELECT SUM(subj1 + subj2 + subj3) FROM marks;
|
| Option D | D. SELECT MAX(subj1, subj2, subj3) FROM marks;
|
| Option E | E. SELECT SUM(subj1, subj2, subj3) FROM marks;
|
| Correct Answer | B,C |