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 (stude

题目

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);
相似考题

1.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.

2.Which three protocols should be explicitly managed by using Control Plane Policing on an Internet borderrouter？（）A、LDAPB、ICMPC、RTPD、BGPE、SSHF、RDP

3.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.

4.Which of the following resources can be explicitly locked?()A.RowB.PageC.TableD.Column

更多“Which statement explicitly names”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

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

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

    正确答案:C

  • 第4题：

    Which two statements are true regarding the ORDER BY clause? （）

    • A、It is executed first in the query execution 
    • B、It must be the last clause in the SELECT statement 
    • C、It cannot be used in a SELECT statement containing a HAVING clause
    • D、You cannot specify a column name followed by an expression in this clause 
    • E、You can specify a combination of numeric positions and column names in this clause

    正确答案:B,E

  • 第5题：

    Which statement is true？（）

    • A、A class’s finalize（） method CANNOT be invoked explicitly.
    • B、super.finalize（） is called implicitly by any overriding finalize（） method.
    • C、The finalize（） method for a given object is called no more than once by the garbage collector.
    • D、The order in which finalize（） is called on two objects is based on the order in which the two objects became finalizable.

    正确答案:C

  • 第6题：

    Which is an example of a dynamic SELECT statement? （）

    • A、A query whose object names change during its execution. 
    • B、A query whose object names are not known until run time. 
    • C、A query whose bind variables values change during execution. 
    • D、A query whose bind variable values are not known until run time.

    正确答案:B

  • 第7题：

    多选题
    Which of the following statements are true when creating NETBIOS names？ （）
    A

    NETBIOS names can only use alphanumeric characters.

    B

    You can use a ’.’ in a NETBIOS name.

    C

    You can use an ’_’ （underscore） in a NETBIOS name.

    D

    NETBIOS names must be UPPERCASE

    E

    NETBIOS names can be a maximum of 32 characters


    正确答案： B,C
    解析： 暂无解析

  • 第8题：

    多选题
    Which two statements are true regarding the ORDER BY clause? （）
    A

    It is executed first in the query execution

    B

    It must be the last clause in the SELECT statement

    C

    It cannot be used in a SELECT statement containing a HAVING clause

    D

    You cannot specify a column name followed by an expression in this clause

    E

    You can specify a combination of numeric positions and column names in this clause


    正确答案： B,C
    解析： 暂无解析

  • 第9题：

    单选题
    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);


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    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.


    正确答案： D,E
    解析： 暂无解析

  • 第11题：

    多选题
    Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）
    A

    It is used to change failure priority only for HIGH or LOW priorities.

    B

    It is used to execute the advised repair script.

    C

    It is used to change failure priority only for the CRITICAL priority.

    D

    It is used to explicitly close the open failures.

    E

    It is used to inform the database about the repair after the repair script executes.


    正确答案： A,C
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    Which statement describes the significance of the CHANGE FAILURE command in RMAN？（）

    • A、 It is used to change failure priority only for HIGH or LOW priorities.
    • B、 It is used to execute the advised repair script.
    • C、 It is used to change failure priority only for the CRITICAL priority.
    • D、 It is used to explicitly close the open failures.
    • E、 It is used to inform the database about the repair after the repair script executes.

    正确答案:A,D

  • 第17题：

    Where can subqueries be used?（）

    • A、field names in the SELECT statement 
    • B、the FROM clause in the SELECT statement 
    • C、the HAVING clause in the SELECT statement
    • D、the GROUP BY clause in the SELECT statement 
    • E、the WHERE clause in only the SELECT statement 
    • F、the WHERE clause in SELECT as well as all DML statements

    正确答案:B,C,F

  • 第18题：

    单选题
    You need to display the last names of those employees who have the letter "A" as the second character in their names.Which SQL statement displays the required results?（）
    A

    SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';

    B

    SELECT last_name FROM EMP WHERE last name ='*A%'

    C

    SELECT last_name FROM EMP WHERE last name ='_A%';

    D

    SELECT last_name FROM EMP WHERE last name LIKE '*A%'


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    Which statement is true？（）
    A

    A class’s finalize（） method CANNOT be invoked explicitly.

    B

    super.finalize（） is called implicitly by any overriding finalize（） method.

    C

    The finalize（） method for a given object is called no more than once by the garbage collector.

    D

    The order in which finalize（） is called on two objects is based on the order in which the two objects became finalizable.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    多选题
    Which three protocols should be explicitly managed by using a CoPP policy on an Internet border router？（）
    A

    SMTP

    B

    ICMP

    C

    BGP

    D

    SSH

    E

    RTP

    F

    BitTorrent

    G

    VTP


    正确答案： F,E
    解析： 暂无解析

  • 第22题：

    多选题
    Which three protocols should be explicitly managed by using Control Plane Policing on an Internet border router？（）
    A

    LDAP

    B

    ICMP

    C

    RTP

    D

    BGP

    E

    SSH

    F

    RDP


    正确答案： B,D
    解析： 暂无解析

  • 第23题：

    单选题
    Which is an example of a dynamic SELECT statement? （）
    A

    A query whose object names change during its execution. 

    B

    A query whose object names are not known until run time. 

    C

    A query whose bind variables values change during execution. 

    D

    A query whose bind variable values are not known until run time.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

相关内容