多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the

题目
多选题
Which two statements about creating constraints are true?（）
A

Constraint names must start with SYS_C

B

All constraints must be defines at the column level

C

Constraints can be created after the table is created

D

Constraints can be created at the same time the table is created

E

Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

相似考题

1.To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()A. Multiple change tracking files can be created for a database.B. The change tracking file must be created after the first level 0 backup.C. RMAN does not support backup and recovery of the change tracking file.D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

2.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 UPPERCASEE、 NETBIOS names can be a maximum of 32 characters

3.Which two statements are true about the rescue configuration file?（）A、It must include a root passwordB、It is roll back file number 50, and you can recover it by issuing rollback 50C、It is created by issuing request system configuration rescue saveD、It is updated automatically when you commit

4.Which two statements are true about the rescue configuration file?()A. It must include a root password.B. It is rollback file number 50, and you can recover it by issuing rollback 50.C. It is created by issuing request system configuration rescue save.D. It is updated automatically when you commit.

更多“多选题Which two statements about creating constraints are true?（）AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the”相关问题

  • 第1题：

    Which two statements are true about the rescue configuration file?（）

    • A、It must include a root password.
    • B、It is rollback file number 50, and you can recover it by issuing rollback 50.
    • C、It is created by issuing request system configuration rescue save.
    • D、It is updated automatically when you commit.

    正确答案:A,C

  • 第2题：

    Which two statements are true about constraints? （）

    • A、The UNIQUE constraint does not permit a null value for the column.
    • B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
    • C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
    • D、The NOT NULL constraint ensures that null values are not permitted for the column.

    正确答案:B,D

  • 第3题：

    Which statements are true regarding system-partitioned tables？（）  

    • A、 Only a single partitioning key column can be specified.
    • B、 All DML statements must use partition-extended syntax.
    • C、 The same physical attributes must be specified for each partition.
    • D、 Unique local indexes cannot be created on a system-partitioned table.
    • E、 Traditional partition pruning and partitionwise joins are not supported on these tables.

    正确答案:D,E

  • 第4题：

    Which two statements are true about simple views？（）

    • A、Views can be created as read only.
    • B、Views are data segments like tables.
    • C、Views can be created on the basis of more than one table.
    • D、Data manipulation language （DML） operations cannot be performed on views.

    正确答案:A,C

  • 第5题：

    Which two statements about creating constraints are true? （）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level
    • C、Constraints can be created after the table is created
    • D、Constraints can be created at the same time the table is created
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

    正确答案:C,D

  • 第6题：

    多选题
    Which two statements are true about the rescue configuration file?（）
    A

    It must include a root password

    B

    It is roll back file number 50, and you can recover it by issuing rollback 50

    C

    It is created by issuing request system configuration rescue save

    D

    It is updated automatically when you commit


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

  • 第7题：

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

  • 第8题：

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


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

  • 第9题：

    多选题
    Which two statements are true about simple views？（）
    A

    Views can be created as read only.

    B

    Views are data segments like tables.

    C

    Views can be created on the basis of more than one table.

    D

    Data manipulation language （DML） operations cannot be performed on views.


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

  • 第10题：

    多选题
    Which two statements are true regarding views?（）
    A

    A subquery that defines a view cannot include the GROUP BY clause

    B

    A view that is created with the subquery having the DISTINCT keyword can be updated

    C

    A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

    D

    A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table


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

  • 第11题：

    多选题
    Which statements are true regarding system-partitioned tables?（）
    A

    Only a single partitioning key column can be specified.

    B

    All DML statements must use partition-extended syntax.

    C

    The same physical attributes must be specified for each partition.

    D

    Unique local indexes cannot be created on a system-partitioned table.

    E

    Traditional partition pruning and partitionwise joins are not supported on these tables.


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

  • 第12题：

    多选题
    To enable faster incremental backups， you enabled block change tracking for the database. Which two statements are true about the block change tracking file？（）
    A

    Multiple change tracking files can be created for a database.

    B

    The change tracking file must be created after the first level 0 backup.

    C

    RMAN does not support backup and recovery of the change tracking file.

    D

    The database clears the change tracking file and starts tracking changes again，after whole database restore and recovery operations.


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

  • 第13题：

    Which two statements are true regarding views?（）

    • A、A subquery that defines a view cannot include the GROUP BY clause 
    • B、A view that is created with the subquery having the DISTINCT keyword can be updated 
    • C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
    • D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

    正确答案:C,D

  • 第14题：

    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?（）

    • A、Multiple change tracking files can be created for a database.
    • B、The change tracking file must be created after the first level 0 backup.
    • C、RMAN does not support backup and recovery of the change tracking file.
    • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

    正确答案:C,D

  • 第15题：

    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

  • 第16题：

    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)

    • A、Multiple change tracking files can be created for a database.
    • B、The change tracking file must be created after the first level 0 backup.
    • C、RMAN does not support backup and recovery of the change tracking file.
    • D、The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

    正确答案:C,D

  • 第17题：

    Which two statements about creating constraints are true?（）

    • A、Constraint names must start with SYS_C
    • B、All constraints must be defines at the column level.
    • C、Constraints can be created after the table is created.
    • D、Constraints can be created at the same time the table is created.
    • E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

    正确答案:C,D

  • 第18题：

    多选题
    Which two statements are true about constraints? （）
    A

    The UNIQUE constraint does not permit a null value for the column.

    B

    A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.

    C

    The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.

    D

    The NOT NULL constraint ensures that null values are not permitted for the column.


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

  • 第19题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    All constraints must be defines at the column level

    C

    Constraints can be created after the table is created

    D

    Constraints can be created at the same time the table is created

    E

    Information about constraints is found in the VIEW_CONSTRAINTS dictionary view


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

  • 第20题：

    多选题
    Which two statements about creating constraints are true?（）
    A

    Constraint names must start with SYS_C

    B

    All constraints must be defines at the column level.

    C

    Constraints can be created after the table is created.

    D

    Constraints can be created at the same time the table is created.

    E

    Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.


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

  • 第21题：

    单选题
    While designing your database， you have created the EMPLOYEES table as an index-organized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
    A

    A primary key must have been created.

    B

    A mapping table must have been created.

    C

    An overflow tablespace must have been specified.

    D

    The PCTTHRESHOLD option must have been specified.


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

  • 第22题：

    多选题
    To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file? （）(Choose two.)
    A

    Multiple change tracking files can be created for a database.

    B

    The change tracking file must be created after the first level 0 backup.

    C

    RMAN does not support backup and recovery of the change tracking file.

    D

    The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.


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

  • 第23题：

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


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

  • 第24题：

    多选题
    Which two statements are true about the rescue configuration file?（）
    A

    It must include a root password.

    B

    It is rollback file number 50, and you can recover it by issuing rollback 50.

    C

    It is created by issuing request system configuration rescue save.

    D

    It is updated automatically when you commit.


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

相关内容