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

题目

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

1.Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA．ⅠonlyB．Ⅱ onlyC．Ⅰ and ⅡD．none of the above

2.The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action? ()(Choose two)A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data

3.Which two statements are true about pool－based source NAT? ()(Choose two.)A. PAT is not supported.B. PAT is enabled by default.C. It supports the address-persistent configuration option.D. It supports the junos-global configuration option.

4.The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data

更多“Which two statements about views”相关问题

  • 第1题：

    Which two statements are true about AH?() (Choose two.)

    A. AH provides data integrity.

    B. AH is identified by IP protocol 50.

    C. AH is identified by IP protocol 51.

    D. AH cannot work in conjunction with ESP


    参考答案：A, C

  • 第2题：

    Which two statements are true about L2TP tunnels?（） (Choose two.)

    • A、Traffic is clear text
    • B、Traffic is encrypted 
    • C、They are initiated by the LNS
    • D、They are initiated by the LAC

    正确答案:A,D

  • 第3题：

    Which two statements are true about traffic shaping？（）

    • A、Out-of-profile packets are queued.
    • B、It causes TCP retransmits.
    • C、Marking/remarking is not supported.
    • D、It does not respond to BECN and ForeSight Messages.
    • E、It uses a single/two-bucket mechanism for metering.

    正确答案:A,C

  • 第4题：

    Which two statements are true about precedence values in policy?（） (Choose two.)

    • A、1 is the default precedence.
    • B、A lower number is preferred.
    • C、A higher number is preferred.
    • D、100 is the default precedence.

    正确答案:B,D

  • 第5题：

    Which two statements are true about the Automatic Workload Repository （AWR）（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR contains systemwide tracing and logging information.
    • C、The snapshots collected by the AWR are accessible through data dictionary views.
    • D、The snapshots collected by the AWR are used by self-tuning components in the database.

    正确答案:C,D

  • 第6题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

    • A、 All the related indexes and views are automatically dropped
    • B、 The flashback drop feature can recover only the table structure
    • C、 Only the related indexes are dropped whereas views are invalidated
    • D、 The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第7题：

    Which two statements are true about record groups?（）

    • A、They are stored in the database. 
    • B、They are stored in local Forms memory. 
    • C、The type is specified explicitly at design time. 
    • D、The type is implied by when and how it is created.

    正确答案:B,D

  • 第8题：

    多选题
    Which two statements are true about L2TP tunnels?（） (Choose two.)
    A

    Traffic is clear text

    B

    Traffic is encrypted 

    C

    They are initiated by the LNS

    D

    They are initiated by the LAC


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

  • 第9题：

    多选题
    By default, which two statements are true about export routing polices?（）
    A

    Export polices can evaluate only active routes

    B

    Export polices can evaluate all routes

    C

    Export polices can be applied to the forwarding table

    D

    Export polices can be applied to interfaces


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

  • 第10题：

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


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

  • 第11题：

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

  • 第12题：

    多选题
    Which two statements are true about traffic shaping？（）
    A

    Out-of-profile packets are queued.

    B

    It causes TCP retransmits.

    C

    Marking/remarking is not supported.

    D

    It does not respond to BECN and ForeSight Messages.

    E

    It uses a single/two-bucket mechanism for metering.


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

  • 第13题：

    Which two statements are true about precedence values in policy?() (Choose two.)

    A. 1 is the default precedence.

    B. A lower number is preferred.

    C. A higher number is preferred.

    D. 100 is the default precedence.


    参考答案：B, D

  • 第14题：

    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

  • 第15题：

    Which two statements are true about pool-based source NAT? （）(Choose two.)

    • A、PAT is not supported.
    • B、PAT is enabled by default.
    • C、It supports the address-persistent configuration option.
    • D、It supports the junos-global configuration option.

    正确答案:B,C

  • 第16题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

    • A、All the related indexes and views are automatically dropped
    • B、The flashback drop feature can recover only the table structure
    • C、Only the related indexes are dropped whereas views are invalidated
    • D、The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第17题：

    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

  • 第18题：

    Which two statements are true about standard database auditing（）

    • A、DDL statements can be audited.
    • B、Statements that refer to stand-alone procedure can be audited.
    • C、Operations by the users logged on as SYSDBA cannot be audited.
    • D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

    正确答案: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题：

    多选题
    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）
    A

    All the related indexes and views are automatically dropped

    B

    The flashback drop feature can recover only the table structure

    C

    Only the related indexes are dropped whereas views are invalidated

    D

    The flashback drop feature can recover both the table structure and its data


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

  • 第21题：

    多选题
    Which two statements are true about AH?（） (Choose two.)
    A

    AH provides data integrity.

    B

    AH is identified by IP protocol 50.

    C

    AH is identified by IP protocol 51.

    D

    AH cannot work in conjunction with ESP


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

  • 第22题：

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

    The bus is limited to 32 devices

    B

    It is a full duplex serial standard

    C

    It is a half-duplex serial standard

    D

    It allows up to 320 MB/s of shared channel bandwidth


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

  • 第23题：

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

  • 第24题：

    多选题
    Which two statements are true about the Automatic Workload Repository （AWR）（）
    A

    All AWR tables belong to the SYSTEM schema.

    B

    The AWR contains systemwide tracing and logging information.

    C

    The snapshots collected by the AWR are accessible through data dictionary views.

    D

    The snapshots collected by the AWR are used by self-tuning components in the database.


    正确答案： C,B
    解析： AWR 基础结构由两个主要部分组成：  • 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。  • 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。  它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。

相关内容