多选题Which two statements are true regarding a PL/SQL package body？（）AIt cannot be created without a package specification.BIt cannot invoke subprograms defined in other packages.CIt can contain only the subprograms defined in the package specification.DIt 

题目
多选题
Which two statements are true regarding a PL/SQL package body？（）
A

It cannot be created without a package specification.

B

It cannot invoke subprograms defined in other packages.

C

It can contain only the subprograms defined in the package specification.

D

It can be changed and recompiled without making the package specification invalid.

相似考题

1.Which two statements regarding a SQL profile are true?()A. It is built by Automatic Tuning Optimizer.B. It cannot be stored persistently in the data dictionary.C. It can be used by the query optimizer automatically.D. It can be created manually by using the CREATE PROFILE command.

2.A member variable defined in a class can be accessed only by the classes in the same package. Which modifier should be used to obtain the access control？（）         A、 privateB、 no modifierC、 publicD、 protected

3. package foo； public class Outer （  public static class Inner （  ）  ）   Which statement is true？ （） A、 An instance of the Inner class can be constructed with “new Outer.Inner （）”B、 An instance of the inner class cannot be constructed outside of package foo.C、 An instance of the inner class can only be constructed from within the outer class.D、 From within the package bar， an instance of the inner class can be constructed with “new inner（）”

4. package foo；  public class Outer {  public static class Inner {  }  }   Which statement is true？（） A、 Compilation fails.B、 An instance of the Inner class can be constructed with “new Outer.Inner（）”.C、 An instance of the Inner class cannot be constructed outside of package foo.D、 An instance of the Inner class can be constructed only from within the Outer class.E、 From within the package foo， and instance of the Inner class can be constructed with “new Inner（）”.

更多“多选题Which two statements are true regarding a PL/SQL package body？（）AIt cannot be created without a package specification.BIt cannot invoke subprograms defined in other packages.CIt can contain only the subprograms defined in the package specification.DIt ”相关问题

  • 第1题：

    Which statements are true regarding the creation of an incident package file by using the EM Workbench Support？（）

    • A、 You can add or remove the trace files to the package.
    • B、 You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
    • C、 You can add SQL test cases to the incident package.
    • D、 You cannot create an incremental incident package when the physical files are purged rom the ADR.

    正确答案:A,B,C

  • 第2题：

    Which two statements are true regarding the SQL Repair Advisor？（） 

    • A、 The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
    • B、 The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
    • C、 The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
    • D、 The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

    正确答案:B,D

  • 第3题：

    Which two statements are true regarding a PL/SQL package body？（）

    • A、It cannot be created without a package specification.
    • B、It cannot invoke subprograms defined in other packages.
    • C、It can contain only the subprograms defined in the package specification.
    • D、It can be changed and recompiled without making the package specification invalid.

    正确答案:A,D

  • 第4题：

    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

  • 第5题：

    Which two are true regarding external tables？ （）

    • A、External tables can be updated. 
    • B、External tables are read-only tables. 
    • C、Indexes can be created on external tables. 
    • D、Indexes cannot be created on external tables.

    正确答案:B,D

  • 第6题：

    多选题
    What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)
    A

    It cannot generate recommendations that support multiple workload queries.

    B

    It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

    C

    It can recommend partitioning only on tables that have at least 10,000 rows.

    D

    It can recommend only B-tree indexes and not bitmap or function-based indexes


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

  • 第7题：

    多选题
    What two statements are true regarding the recommendations received from the SQL Access Advisor？（）
    A

    It cannot generate recommendations that support multiple workload queries.

    B

    It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

    C

    It can recommend partitioning only on tables that have at least 10，000 rows.

    D

    It can recommend only B-tree indexes and not bitmap or function-based indexes.


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

  • 第8题：

    多选题
    Which two statements regarding a SQL profile are true？（）
    A

    It is built by Automatic Tuning Optimizer.

    B

    It cannot be stored persistently in the data dictionary.

    C

    It can be used by the query optimizer automatically.

    D

    It can be created manually by using the CREATE PROFILE command.


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

  • 第9题：

    多选题
    Which two statements are true regarding the SQL Repair Advisor？（）
    A

    The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.

    B

    The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.

    C

    The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.

    D

    The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.


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

  • 第10题：

    多选题
    Which two statements are true regarding a tablespace（）
    A

    It can span multiple databases.

    B

    It can consist of multiple data files.

    C

    It can contain blocks of different sizes.

    D

    It can contain segments of different sizes.

    E

    It can contain a part of a nonpartitioned segment.


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

  • 第11题：

    多选题
    Which two are true regarding external tables？ （）
    A

    External tables can be updated.

    B

    External tables are read-only tables.

    C

    Indexes can be created on external tables.

    D

    Indexes cannot be created on external tables.


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

  • 第12题：

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

  • 第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题：

    Which two statements about subqueries are true? （）

    • A、A subquery should retrieve only one row.
    • B、A subquery can retrieve zero or more rows.
    • C、A subquery can be used only in SQL query statements.
    • D、Subqueries CANNOT be nested by more than two levels.
    • E、A subquery CANNOT be used in an SQL query statement that uses group functions.
    • F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

    正确答案:B,F

  • 第15题：

    Which two statements regarding a SQL profile are true？（）

    • A、 It is built by Automatic Tuning Optimizer.
    • B、 It cannot be stored persistently in the data dictionary.
    • C、 It can be used by the query optimizer automatically.
    • D、 It can be created manually by using the CREATE PROFILE command.

    正确答案:A,C

  • 第16题：

    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

  • 第17题：

    多选题
    Which statements are true regarding the creation of an incident package file by using the EM WorkbenchSupport（）
    A

    You can add SQL test cases to the incident package.

    B

    You can add or remove the trace files to the package.

    C

    You cannot create an incremental incident package when the physical files are purged from the ADR.

    D

    You can create the incremental incident package ZIP file for new or modified diagnostic information for theincident package already created.


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

  • 第18题：

    单选题
    package foo；  public class Outer {  public static class Inner {  }  }   Which statement is true？（）
    A

     Compilation fails.

    B

     An instance of the Inner class can be constructed with “new Outer.Inner（）”.

    C

     An instance of the Inner class cannot be constructed outside of package foo.

    D

     An instance of the Inner class can be constructed only from within the Outer class.

    E

     From within the package foo， and instance of the Inner class can be constructed with “new Inner（）”.


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

  • 第19题：

    单选题
    A member variable defined in a class can be accessed only by the classes in the same package. Which modifier should be used to obtain the access control？（）
    A

     private

    B

     no modifier

    C

     public

    D

     protected


    正确答案： C
    解析： 一个类中定义的成员变量只能被同一包中的类访问。

  • 第20题：

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

  • 第21题：

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

    A subquery should retrieve only one row.

    B

    A subquery can retrieve zero or more rows.

    C

    A subquery can be used only in SQL query statements.

    D

    Subqueries CANNOT be nested by more than two levels.

    E

    A subquery CANNOT be used in an SQL query statement that uses group functions.

    F

    When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.


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

  • 第22题：

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

  • 第23题：

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

相关内容