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?（） -题库考试答案搜索网

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?（）

单选题

2022-11-04 14:49

A、CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));
B、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));
C、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));
D、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))

查看答案

正确答案

试题解析

标签： 1Z0-007

感兴趣题目

You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2. You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure. What should you recommend？（）

You need to design a remote access strategy for portable computers. Your solution must meet business requirements. What should you do？（）

Some people believe that a college or university education should be available to all students. Others believe that higher education should be available only to good students. Which view do you agree with and why?

You have a class C network, and you need to design it for 5 usable subnets with each subnet handling a minimum of 18 hosts each. Which of the following network masks should you use?

You have a print server that runs Windows Server 2003 Service Pack 2 (SP2).
You need to receive a notification each time a document fails to print.
What should you do? （）

Exhibit:

You develop a Web control to manage credit card information. The Web control is shown in the exhibit. You register the control on the Web Form by using the following code segment. <%@ Register Assembly="CreditCardUserDetails" Namespace="CreditCardUserDetails" TagPrefix="cc1" %> You need to declare the control on the Web Form. Which code segment should you use?（）

You need to design the retrieval of advertising statistics without compromising security. What should you do?（）

You are designing a top-level OU structure to meet the business and technical requirements. Which top-evel OU or OUs should you use?（）

You are deploying a Web site to a server managed by a hosting company. The only access you have to the server is through FTP. You need to precompile and deploy the Web site without its source files.
What should you do? （）

You are developing WPF application for managing student information... btnSort and a DataGrid control named dgStudents on the design surface of the MainWindow.xaml properties : FirstName and LastName. You create the following code segment in the constructor of...

The DataGrid control displays the list of students unsorted.
You need to ensure that the list of students is sorted by last name.
Which code segment should you add to the click event handler of the Button control？（）

You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）

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?（）