[单选]
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?（）

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))

按危机来源的不同，小企业可能遇到多种危机，除了（）。供应危机。财务危机。品牌危机。战略危机。 In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（） The STATISTICS_LEVEL initialization parameter is set to BASIC。 The PGA_AGGREGATE_TARGET initialization parameter is set to zero.。 The SGA_MAX_SIZE initialization parameter is set to less than 20 GB。 The DB_CACHE_SIZE initialization parameter is set to less than 5 GB。 The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.。 A customer has an existing high availability SAN environment with CLARiiON, which has been stable for 16 months. They have recently experienced several outages with their current storage systems. They need to purchase additional storage and have asked about tier 1 storage. They are concerned with connecting their existing storage and servers without trouble. Which resource should be consulted while developing the solution options?（） Disk Magic。 TPC for Data。 CLARiiON Procedure Generator。 System Storage Interoperability Center。我国小学阶段，德育内容主要体现在（）中班级教育活动。思想品德课。全校性思想政治教育活动。班会和校会。 How many expansion frames can be attached to an IBM TS3500 model L23 or L53 base frame? （） 15。 16。 17。 18。

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

参考答案：

● 参考解析

本题暂无解析

当前位置：1Z0-007题库

相关题目: