单选题What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）A It can contain parameters with distinct values for each distance.B It can contain only parameters with identical values for each instance.C It must

题目
单选题
What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）
A

It can contain parameters with distinct values for each distance.

B

It can contain only parameters with identical values for each instance.

C

It must contain an IFILE parameter for each instance’s individual parameter file.

D

It must be located in the default location for the primary instance’s parameter file.

相似考题

1.You set the following parameters in the parameter file and restarted the database:Which two statements are true regarding these parameters after the database instance is restarted?()A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MBB. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manuallyC. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zeroD. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

2.Which statement is true regarding Dynamic Service Registration？（）A、Dynamic service registration requires configuration in the listener .ora file.B、Dynamic service registration can be used only with an Oracle9/instance.C、Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.D、The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.

3. You are trying to change the polling parameters used by the location manager via the Cisco WCS， and yourrequest is being denied. What is wrong？（）A、Your login does not have the correct permissions.B、You must wait for the location server to become available.C、Polling values can be changed only on the location server.D、Polling values can be changed only in the maintenance window.

4.Which two statements are true regarding interface properties? ()A.MTU and speed must be configured under each unit.B.Physical parameters such as MTU, duplex mode, and speed are configured under the interface name.C.IP and IPv6 addresses are configured under a unit-number.D.DLCI numbers, VPI/VCI values, and VLAN tags are physical parameters.

更多“单选题What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）A It can contain parameters with distinct values for each distance.B It can contain only parameters with identical values for each instance.C It must”相关问题

  • 第1题：

    Which two statements are true regarding interface properties? （）

    • A、MTU and speed must be configured under each unit.
    • B、Physical parameters such as MTU, duplex mode, and speed are configured under the interface name.
    • C、IP and IPv6 addresses are configured under a unit-number.
    • D、DLCI numbers, VPI/VCI values, and VLAN tags are physical parameters.

    正确答案:B,C

  • 第2题：

    Which statement about windows and blocks is true?（）

    • A、Transaction management is block-oriented rather than window-oriented. 
    • B、Forms automatically navigates to an item located in an activated window. 
    • C、A window may contain multiple blocks, but each block can only span one window. 
    • D、A window can contain multiple canvases, and an item can be located on multiple canvases. 

    正确答案:A

  • 第3题：

    Which three statements regarding the server parameter file （SPFILE） are true（）

    • A、An SPFILE is a binary file.
    • B、An SPFILE cannot reside on a client.
    • C、An SPFILE cannot contain static parameters.
    • D、An SPFILE can store changes persistently across instance restarts.
    • E、An SPFILE can be read by the database server， but it is not written to by the server.
    • F、An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database.

    正确答案:A,B,D

  • 第4题：

    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.

    正确答案:B

  • 第5题：

    How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）

    • A、Include an SPFILE parameter in each instance-specified initialization file.
    • B、Create an SPFILE copy on each client from which the instance will be started.
    • C、Store the SPFILE in a raw partition with a vendor-specifies location and name.
    • D、Use a single client to start the instances and create the SPFILE on this client.

    正确答案:A

  • 第6题：

    The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）

    • A、Only MEMORY is updated.
    • B、Only SPFILE values are updated.
    • C、Only init.ora parameters are updated.
    • D、Both init.ora parameters and SPFILE values are updated.

    正确答案:A

  • 第7题：

    多选题
    Which  statements regarding the server parameter file （SPFILE） are true（）
    A

    An SPFILE is a binary file.

    B

    An SPFILE cannot reside on a client.

    C

    An SPFILE cannot contain static parameters.

    D

    An SPFILE can store changes persistently across instance restarts.

    E

    An SPFILE can be read by the database server， but it is not written to by the server.

    F

    An SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database


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

  • 第8题：

    多选题
    You set the value of the SGA_TARGET initialization parameter to 1G to enable Oracle to automatically resize most of the memory components according to the current workload in the database. You issue the following statement：   SQL> SELECT name， value， isdefault  2 FROM v$parameter   3 WHERE name LIKE ’%size%’；   The output of this statement displays that the DB_CACHE_SIZE， SHARED_POOL_SIZE，  LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters contain a zero value.  What does this imply？（）
    A

    The SGA_TARGET initialization parameter cannot be set to a value less than 1G

    B

    The SGA_TARGET initialization parameter cannot be set to a value greater than 1G

    C

    The Memory Advisor of the Oracle Enterprise Manager 10g cannot be used to obtain advice on the important memory components of the SGA

    D

    The values of the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters cannot be set manually.

    E

    No minimum limits are imposed on the DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and  JAVA_POOL_SIZE initialization parameters.

    F

    The Automatic Shared Memory Management feature cannot be disabled unless you specify values for the  DB_CACHE_SIZE， SHARED_POOL_SIZE， LARGE_POOL_SIZE， and JAVA_POOL_SIZE initialization parameters in the initialization parameter file.


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

  • 第9题：

    单选题
    The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）
    A

    Only MEMORY is updated.

    B

    Only SPFILE values are updated.

    C

    Only init.ora parameters are updated.

    D

    Both init.ora parameters and SPFILE values are updated.


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

  • 第10题：

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


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

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    Which three statements are true regarding subqueries?（）

    • A、Subqueries can contain GROUP BY and ORDER BY clauses 
    • B、Main query and subquery can get data from different tables 
    • C、Main query and subquery must get data from the same tables 
    • D、Subqueries can contain ORDER BY but not the GROUP BY clause 
    • E、Only one column or expression can be compared between the main query and subquery
    • F、 Multiple columns or expressions can be compared between the main query and subquery

    正确答案:A,B,E

  • 第14题：

    You are trying to change the polling parameters used by the location manager via the Cisco WCS，and your request is being denied. What is wrong？（）

    • A、Polling values can be changed only in the maintenance window.
    • B、Polling values can be changed only on the location server.
    • C、Your login does not have the correct permissions.
    • D、You must wait for the location server to become available.

    正确答案:C

  • 第15题：

    Which  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

    正确答案:B,D

  • 第16题：

    What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）

    • A、It can contain parameters with distinct values for each distance.
    • B、It can contain only parameters with identical values for each instance.
    • C、It must contain an IFILE parameter for each instance’s individual parameter file.
    • D、It must be located in the default location for the primary instance’s parameter file.

    正确答案:A

  • 第17题：

    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.

    正确答案:B,D

  • 第18题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008.  You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports.  Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source.  Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）

    • A、 Filter data by using expressions.
    • B、 Specify the default values for each parameter.
    • C、 Create an available values list for each parameter.
    • D、 Create report parameters by using query parameters to filter data at the data source.

    正确答案:A,B

  • 第19题：

    单选题
    Which statement about windows and blocks is true?（）
    A

    Transaction management is block-oriented rather than window-oriented. 

    B

    Forms automatically navigates to an item located in an activated window. 

    C

    A window may contain multiple blocks, but each block can only span one window. 

    D

    A window can contain multiple canvases, and an item can be located on multiple canvases. 


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

  • 第20题：

    单选题
    What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）
    A

    It can contain parameters with distinct values for each distance.

    B

    It can contain only parameters with identical values for each instance.

    C

    It must contain an IFILE parameter for each instance’s individual parameter file.

    D

    It must be located in the default location for the primary instance’s parameter file.


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

  • 第21题：

    单选题
    How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）
    A

    Include an SPFILE parameter in each instance-specified initialization file.

    B

    Create an SPFILE copy on each client from which the instance will be started.

    C

    Store the SPFILE in a raw partition with a vendor-specifies location and name.

    D

    Use a single client to start the instances and create the SPFILE on this client.


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

  • 第22题：

    单选题
    You are trying to change the polling parameters used by the location manager via the Cisco WCS，andyour request is being denied. What is wrong？（）
    A

    Polling values can be changed only in the maintenance window.

    B

    Polling values can be changed only on the location server.

    C

    Your login does not have the correct permissions.

    D

    You must wait for the location server to become available.


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

  • 第23题：

    单选题
    Which statement is true regarding Dynamic Service Registration？（）
    A

    Dynamic service registration requires configuration in the listener .ora file.

    B

    Dynamic service registration can be used only with an Oracle9/instance.

    C

    Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.

    D

    The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.


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

  • 第24题：

    单选题
    You are trying to change the polling parameters used by the location manager via the Cisco WCS， and yourrequest is being denied. What is wrong？（）
    A

    Your login does not have the correct permissions.

    B

    You must wait for the location server to become available.

    C

    Polling values can be changed only on the location server.

    D

    Polling values can be changed only in the maintenance window.


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

相关内容