Which statement explicitly names a constraint?（）A、ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students(student_id);B、ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students

题目

Which statement explicitly names a constraint?（）

A、ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students(student_id);
B、ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
C、ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
D、ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);
E、ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students(student_id);

参考答案和解析

正确答案:C

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

Which three protocols should be explicitly managed by using Control Plane Policing on an Internet borderrouter？（）

A、LDAP
B、ICMP
C、RTP
D、BGP
E、SSH
F、RDP

正确答案:B,D,E

第2题：

In which of the following situations should correlation names be used?（）

A、A table referenced in the FROM clause has no indexed column.
B、The table referenced in the FROM clause has more than 200 columns.
C、Two or more tables in the FROM clause have identical column names.
D、The FROM clause contains two or more tables in the SELECT statement.

正确答案:C

第3题：

Which statement about Automatic Memory Management with Oracle 11g is true?()

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

参考答案：B

第4题：

Which of the following resources can be explicitly locked?（）

A、Row
B、Page
C、Table
D、Column

正确答案:C

第5题：

Which two statements about views are true? （）

A、A view can be created as read only.
B、A view can be created as a join on two or more tables.
C、A view cannot have an ORDER BY clause in the SELECT statement.
D、A view cannot be created with a GROUP BY clause in the SELECT statement.
E、A view must have aliases defined for the column names in the SELECT statement.

正确答案:A,B

第6题：

The Prescott Shovel Company wants to upgrade its Cisco Unity Express from a Cisco Unified CallManager Express integration to a Cisco Unified CallManager integration. Which statement is true?（）

A、A special hybrid license is required.
B、The Cisco Unity Express license must be changed.
C、The Cisco Unity Express license does not need to be changed.
D、The license file names are identical, which allows them to be interchanged as long as the module itself is not being upgraded.

正确答案:B

第7题：

During tablespace creation， which filename format is NOT used for creating datafiles associated with a tablespace？（）

A、 incomplete names
B、 incomplete names with templates
C、 alias with template names
D、 numeric names

正确答案:D

第8题：

Which of the following resources can be explicitly locked?()

A.Row

B.Page

C.Table

D.Column

参考答案：C

第9题：

Which statement is true regarding the INTERSECT operator?（）

A、It ignores NULL values
B、Reversing the order of the intersected tables alters the result
C、The names of columns in all SELECT statements must be identical
D、The number of columns and data types must be identical for all SELECT statements in the query

正确答案:D

第10题：

View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）

A、The user must enable the role explicitly.
B、The user can grant the role to other users.
C、The user cannot use the role until the DBA enables it explicitly.
D、The user can start using the role immediately without any changes

正确答案:A

Which statement explicitly names

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容