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

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

相似考题

1.You are connected to a pluggable database (PDB) as a common user with DBA privileges.The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE;Which is true about the result of this command?（）A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.B. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.C. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.

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 maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

4.You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.You plan to create the database using SQL statements.Which three techniques can you use to achieve this?（）A. Use Oracle Managed Files (OMF).B. Specify the SEED FILE_NAME_CONVERT clause.C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.D. Specify the DB_FILE_NAMECONVERT initialization parameter.E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）

    • A、The command succeeds only if Automatic Memory Management is not enabled.
    • B、The command succeeds， but you need to restart the database for changes to take effect.
    • C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
    • D、The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

    正确答案:C

  • 第4题：

    What components are present in an ASM instance？（）

    • A、 SGA
    • B、 Database processes
    • C、 Database datafiles
    • D、 Control files
    • E、 Database parameter file or spfile

    正确答案:A,B,E

  • 第5题：

    You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）

    • A、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
    • B、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.
    • C、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is
    • D、 If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

    正确答案:D

  • 第6题：

    You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE://        SGA_TARGET = 512M        SHARED_POOL_SIZE = 256M   Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？ （）

    • A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.
    • B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.
    • C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.
    • D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.
    • E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool  component to the desired size by reallocating the additional memory from the auto-tuned memory components.
    • F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

    正确答案:D,E

  • 第7题：

    单选题
    Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH；  What would be the outcome of this command（）
    A

    The command succeeds only if Automatic Memory Management is not enabled.

    B

    The command succeeds， but you need to restart the database for changes to take effect.

    C

    The command returns an error because the size of the redo log buffer cannot be changed dynamically.

    D

    The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.


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

  • 第8题：

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

  • 第9题：

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

  • 第10题：

    单选题
    You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?（）
    A

    The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.

    B

    The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.

    C

    The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.

    D

    Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.


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

  • 第11题：

    单选题
    The SPFILE for the PROD database specifies the following initialization parameter values：   SGA_TARGET = 2G   DB_8K_CACHE_SIZE = 128M   You create a tablespace named HR with the non-standard block size of 8K. Four database users are running queries on a table in the HR tablespace. These users complain that the queries are taking longer than usual to complete. While investigating the reasons for this delay， you discover that the database encounters extensive cache misses on the database buffer cache with the block size of 8K. You issue the following statement to increase the value of the DB_8K_CACHE_SIZE initialization parameter to 256M：   SQL>ALTER SYSTEM SET DB_8K_CACHE_SIZE=256M SCOPE = BOTH；   What is the result of this statement？（）
    A

     The statement fails because you cannot set the memory components manually if the SGA_TARGET initialization parameter is set to a nonzero value.

    B

     The statement fails because the DB_8K_CACHE_SIZE initialization parameter is not a dynamic parameter.

    C

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and extracts an additional 128M of memory from the automatically sized memory components.

    D

     The statement increases the value of the DB_8K_CACHE_SIZE initialization parameter to 256M and reallocates an additional 128M memory from the memory components that are not auto-tuned.


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

  • 第12题：

    单选题
    You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）
    A

     10M

    B

     400M

    C

     600M

    D

     800M


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

  • 第13题：

    You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）

    • A、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • B、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
    • C、 Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
    • D、 Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    正确答案:A

  • 第14题：

    You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories. You plan to create the database using SQL statements. Which three techniques can you use to achieve this?（）

    • A、Use Oracle Managed Files (OMF).
    • B、Specify the SEED FILE_NAME_CONVERT clause.
    • C、Specify the PDB_FILE_NAME_CONVERT initialization parameter.
    • D、Specify the DB_FILE_NAMECONVERT initialization parameter.
    • E、Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

    正确答案:A,B,C

  • 第15题：

    You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  

    • A、 10M
    • B、 400M
    • C、 600M
    • D、 800M

    正确答案:D

  • 第16题：

    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

  • 第17题：

    Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH；  What would be the outcome of this command？ （）

    • A、The command would return an error because LOG_BUFFER is a static parameter.
    • B、The parameter value would be changed and it would come into effect immediately.
    • C、You need to restart the database so that parameter changes can come into effect.
    • D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

    正确答案:A

  • 第18题：

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

  • 第19题：

    单选题
    You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）
    A

     Create another password file and then re-execute the GRANT statement.

    B

     Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.

    C

     Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.

    D

     Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.


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

  • 第20题：

    单选题
    Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）
    A

    The command would return an error because LOG_BUFFER is a static parameter.

    B

    The parameter value would be changed and it would come into effect immediately.

    C

    You need to restart the database so that parameter changes can come into effect.

    D

    The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.


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

  • 第21题：

    单选题
    You have included the following parameter settings in your SPFILE://    SGA_MAX_SIZE=8G   SGA_TARGET=6G   DB_CACHE_SIZE=2G   SHARED_POOL_SIZE=1G   LOG_BUFFER=64M   DB_KEEP_CACHE_SIZE=960M   Which statement is true if you modify the SGA_TARGET initialization parameter？（）
    A

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

    B

     The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G

    C

     The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G

    D

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M 

    E

     The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M


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

  • 第22题：

    单选题
    You have created a password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）
    A

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    B

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges.

    C

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is

    D

     If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.


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

  • 第23题：

    单选题
    You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors， such as erroneously dropping users， tables， and important data， to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database， you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors， you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running？（）
    A

     Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    B

     Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.

    C

     Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.

    D

     Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.


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

  • 第24题：

    单选题
    You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
    A

     Increase the value of the FAST_START_MTTR_TARGET initialization parameter.

    B

     Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.

    C

     Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.

    D

     Increase the value of the SGA_TARGET initialization parameter.


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

相关内容