niusouti.com

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

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

相似考题

1.The EMPLOYEES table has these columns:Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:What is true about your ALTER statement?()A. Column definitions cannot be altered to add DEFAULT values.B. A change to the DEFAULT value affects only subsequent insertions to the table.C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

2.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.

3.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.

4. Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt：     RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF；   RMAN> BACKUP DATABASE；   Which files from the database will be backed up as a result of this BACKUP command？（）A、 control fileB、 all datafilesC、 password fileD、 online redo log fileE、 archive redo log fileF、 server parameter fileG、 only the SYSTEM datafile

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题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 upd”相关问题

  • 第1题：

    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）

    • A、 Flashback logs are not deleted.
    • B、 Flashback logs are deleted automatically.
    • C、 Flashback logs are deleted only if you are using Recovery Manager （RMAN）
    • D、 Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
    • E、 Flashback logs are deleted only if you are using Automatic Storage Management （ASM）

    正确答案:B

  • 第2题：

    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）

    • A、 The statement will be executed successfully， and a new time zone will be set for the database.
    • B、 The statement will be executed successfully， but a new time zone will not be set for the database.
    • C、 The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
    • D、 The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.

    正确答案:D

  • 第3题：

    Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）

    • A、only the control file, the current SPFILE, and data files
    • B、only the current SPFILE and data files if autobackup is disabled
    • C、only the data files and the archived redo logs
    • D、the control file, current SPFILE file, data files, and archived redo logs

    正确答案:D

  • 第4题：

    An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）

    • A、You can conned as a common user by using the connect statement.
    • B、You can connect as a local user by using the connect statement.
    • C、You can connect by using easy connect.
    • D、You can connect by using OS authentication.
    • E、You can connect by using a Net Service name.
    • F、You can connect as a local user by using the SET CONTAINER statement.

    正确答案:C,D,E,F

  • 第5题：

    In which of the following scenarios is a tablespace recovery required？（）

    • A、 when recovering a lost read-only tablespace from a read-only tablespace backup
    • B、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode
    • C、 when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten
    • D、 when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

    正确答案:B

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

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

  • 第8题：

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

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

    单选题
    our database instance is started using the server parameter file （SPFILE）. You executed a command tochange 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 theSystem Global Area （SGA）


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

  • 第11题：

    单选题
    In which of the following scenarios is a tablespace recovery required？（）
    A

     when recovering a lost read-only tablespace from a read-only tablespace backup

    B

     when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode

    C

     when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten

    D

     when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only


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

  • 第12题：

    单选题
    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs？（）
    A

    Flashback logs are not deleted.

    B

    Flashback logs are deleted automatically.

    C

    Flashback logs are deleted only if you are using Recovery Manager （RMAN）.

    D

    Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.

    E

    Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.


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

  • 第13题：

    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

  • 第14题：

    our database instance is started using the server parameter file （SPFILE）. You executed a command tochange 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 theSystem Global Area （SGA）

    正确答案:C

  • 第15题：

    You create an Oracle 10g database and configure the SPFILE as follows：   SGA_TARGET=2G   DB_CACHE_SIZE=512M  LOG_BUFFER=50M   DB_KEEP_CACHE_SIZE=128M   You modify the SGA_TARGET initialization parameter using the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；   Which entity does this statement affect？（） 

    • A、 only the auto-tuned memory components
    • B、 only the memory components that are not auto-tuned
    • C、 both the auto-tuned memory components and the non-auto-tuned memory components
    • D、 neither the auto-tuned memory components nor the non-auto-tuned memory components

    正确答案:A

  • 第16题：

    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

  • 第17题：

    You decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）

    • A、ALL
    • B、PFILE
    • C、BOTH
    • D、NONE
    • E、SPFILE
    • F、MEMORY
    • G、INSTANCE
    • H、DATABASE

    正确答案:C,E,F

  • 第18题：

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

  • 第19题：

    单选题
    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）
    A

     The statement will be executed successfully， and a new time zone will be set for the database.

    B

     The statement will be executed successfully， but a new time zone will not be set for the database.

    C

     The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.

    D

     The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.


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

  • 第20题：

    单选题
    Which statement regarding the contents of the V$PARAMETER view is true？（）
    A

    displays only the list of default values

    B

    displays only the list of all basic parameters

    C

    displays the currently in effect parameter values

    D

    displays only the list of all advanced parameters

    E

    displays the list of all the parameter files of a database


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

  • 第21题：

    单选题
    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）
    A

     Flashback logs are not deleted.

    B

     Flashback logs are deleted automatically.

    C

     Flashback logs are deleted only if you are using Recovery Manager （RMAN）

    D

     Flashback logs are deleted only if you are using Oracle Manager Files （OFM）

    E

     Flashback logs are deleted only if you are using Automatic Storage Management （ASM）


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

  • 第22题：

    单选题
    You create an Oracle 10g database and configure the SPFILE as follows：   SGA_TARGET=2G   DB_CACHE_SIZE=512M  LOG_BUFFER=50M   DB_KEEP_CACHE_SIZE=128M   You modify the SGA_TARGET initialization parameter using the following statement：   SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；   Which entity does this statement affect？（）
    A

     only the auto-tuned memory components

    B

     only the memory components that are not auto-tuned

    C

     both the auto-tuned memory components and the non-auto-tuned memory components

    D

     neither the auto-tuned memory components nor the non-auto-tuned memory components


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

  • 第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 decided to increase the value for the SHARED_SERVERS parameter by using the following command：  SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=？；  Which three values can be specified for the SCOPE clause？（）
    A

    ALL

    B

    PFILE

    C

    BOTH

    D

    NONE

    E

    SPFILE

    F

    MEMORY

    G

    INSTANCE

    H

    DATABASE


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

相关内容