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

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

第2题：

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.

第3题：

第4题：

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.

第5题：

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.

第6题：

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（）”

第7题：

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

第8题：

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（）”.

第9题：

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.

第10题：

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.