单选题What is true regarding a shared， server-side parameter file for a Real Application Cluster database？ （）AIt can contain parameters with distinct values for each distance.BIt can contain only parameters with identical values for each instance.CIt must contain an IFILE parameter for each instance’s individual parameter file.DIt must be located in the default location for the primary instance’s parameter file.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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.
What is true regarding Cisco Network Registrar in Cable networks？（）A、It provides comprehensive Domain Name systemB、It provides DHCP administrative functionalityC、It provides TFTP server functionality.D、All of the above are true
Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）A、Displays only the list of default valuesB、Displays only the list of all basic parametersC、Displays the currently in effect parameter valuesD、Displays only the list of all advanced parametersE、Displays the list of all the parameter files of a databaseF、Displays the current contents of the server parameter file.
If the sort heap threshold parameter SHEAPTHRES_SHR is set to a value of 0, what will happen?（）A、All sorts will be done in a temporary table space. B、The shared sort memory allocation will be calculated by DB2C、No shared memory is allocated for sorting. D、All sorts will be done in shared memory.
The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）A、It will be created on the local file system.B、It will be created only in the Flash Recovery Area.C、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.D、It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
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.
Which statement regarding the contents of the V$PARAMETER view is true？（）A、displays only the list of default valuesB、displays only the list of all basic parametersC、displays the currently in effect parameter valuesD、displays only the list of all advanced parametersE、displays the list of all the parameter files of a database
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）A、 The backup contains data files， the server parameter file，and the control file even if the control file autobackup is disabled.B、 The KEEP option overrides the configured retention policy.C、 The backup contains only data files and archived redo log files.D、 The KEEP option is an attribute of an individual backup piece.
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
What components are present in an ASM instance？（）A、 SGAB、 Database processesC、 Database datafilesD、 Control filesE、 Database parameter file or spfile
Which two statements regarding the control file and Recover Manager are true？ （）A、The control file can grow in size.B、The control file can store RMAN scripts.C、CONTROL_FILE_RECORD_KEEP_TIME determines retention time for RMAN records.D、The RMAN catalog can exist solely in the control file of the target database.
After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME， the information in the control file is overwritten by RMAN. What is this parameter’s default value？（）A、1 dayB、5 daysC、7 daysD、31 days
You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A、 Only data blocks of the SYSTEM tablespace will be checked.B、 Only data blocks of the SYSAUX tablespace will be checked.C、 A checksum will occur only on the checkpoint.D、 A checksum will occur every time a block is modified.
多选题Which two statements are true regarding the SGA_TARGET initialization parameter（）AIt can be increased up to the value of the SGA_MAX_SIZE parameter.BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
单选题Which statement regarding the contents of the V$PARAMETER view is true？（）Adisplays only the list of default valuesBdisplays only the list of all basic parametersCdisplays the currently in effect parameter valuesDdisplays only the list of all advanced parametersEdisplays the list of all the parameter files of a database
多选题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？ （）AModifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.BModifying 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.CIncreasing 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.DDecreasing 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.EIncreasing 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.FDecreasing 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.
多选题You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）AThe backup contains data files， the server parameter file，and the control file even if the control file autobackup is disabled.BThe KEEP option overrides the configured retention policy.CThe backup contains only data files and archived redo log files.DThe KEEP option is an attribute of an individual backup piece.
单选题After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME， the information in the control file is overwritten by RMAN. What is this parameter’s default value？（）A1 dayB5 daysC7 daysD31 days
多选题What components are present in an ASM instance？（）ASGABDatabase processesCDatabase datafilesDControl filesEDatabase parameter file or spfile
单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the contents of the V$PARAMETER view is true？（）ADisplays only the list of default valuesBDisplays only the list of all basic parametersCDisplays the currently in effect parameter valuesDDisplays only the list of all advanced parametersEDisplays the list of all the parameter files of a databaseFDisplays the current contents of the server parameter file.
单选题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 isD 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.
单选题You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file： DB_BLOCK_CHECKING = TRUE； What will be the result of setting this parameter？（）A Only data blocks of the SYSTEM tablespace will be checked.B Only data blocks of the SYSAUX tablespace will be checked.C A checksum will occur only on the checkpoint.D A checksum will occur every time a block is modified.
单选题How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）AInclude an SPFILE parameter in each instance-specified initialization file.BCreate an SPFILE copy on each client from which the instance will be started.CStore the SPFILE in a raw partition with a vendor-specifies location and name.DUse a single client to start the instances and create the SPFILE on this client.
单选题The database is running in ARCHIVELOG mode. Examine the initialization parameters and theirvalues set to enable archiving on your database server： LOG_ARCHIVE_FORMAT = arch_%t_%s_%r.arc LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’ DB_RECOVERY_FILE_DEST_SIZE = 20G Which statement is true regarding the archived redo log files（）AIt will be created on the local file system.BIt will be created only in the Flash Recovery Area.CIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the defaultlocation $ORACLE_HOME/dbs.DIt will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and locationspecified by the DB_RECOVERY_FILE_DEST parameter.
多选题Which statements regarding the server parameter file （SPFILE） are true（）AAn SPFILE is a binary file.BAn SPFILE cannot reside on a client.CAn SPFILE cannot contain static parameters.DAn SPFILE can store changes persistently across instance restarts.EAn SPFILE can be read by the database server， but it is not written to by the server.FAn SPFILE must be created manually， before creating a database， even if you use the DatabaseConfiguration Assistant （DBCA） to create the database
单选题What is true regarding a transaction executed in Automatic Undo Management mode？（）A AB BC CD D