Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

相似题目

• The SQL Tuning Advisor configuration has default settings in your database instance. Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task?（）

  A . statistics recommendations B . SQL Profile recommendations C . Index-related recommendations D . restructuring of SQL recommendatio

  查看最佳答案

• Your database is open and the LISTENER listener is running. The new DBA of the system stops thelistener by using the command：  LSNRCTL> STOP  What happens to the sessions that are presently connected to the database instance（）

  A . The sessions are able to perform only queries. B . The sessions are not affected and continue to function normally. C . The sessions are terminated and the active transactions are rolled back. D . The sessions are not allowed to perform any operations till the listener is started.

  查看最佳答案

• In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non­ASM instance to an ASM instance？（）

  A . Oracle Migration Assistant B . Recovery Manager （RMAN） C . Oracle Data Pump Export and Import D . conventional Oracle Export and Import E . operating system utilities to copy the files to the ASM instance

  查看最佳答案

• Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?（）

  A . They are able to perform only queries. B . They are not affected and continue to function normally. C . They are terminated and the active transactions are rolled back. D . They are not allowed to perform any operations until the listener LISTENER is started

  查看最佳答案

• You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database？（）

  A . The database would open normally. B . The database would not open， and it would stop at mount stage. C . The database would open after automatically performing instance recovery. D . The database would not open， and you have to perform database recovery to open it.

  查看最佳答案

• Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.  Which tool or utility would you use to start the listener？（）

  A .  Oracle Net Manager B .  Listener Control utility C .  Database Configuration Assistant D .  Oracle Net Configuration Assistant

  查看最佳答案

• Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener byusing the command：LSNRCTL> STOP What happens to the sessions that are presently connected to the database instance（）

  A . The sessions are able to perform only queries. B . The sessions are not affected and continue to function normally. C . The sessions are terminated and the active transactions are rolled back. D . The sessions are not allowed to perform any operations till the listener is started

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?（）

  A . statistics recommendations B . SQL profile recommendations C . index-related recommendations D . restructuring of SQL recommendatio

  查看最佳答案

• You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files（）

  A . Archiving will be disabled because the destination for the redo log files is missing. B . The database instance will shut down and the error details will be logged in the alert log file. C . Archiving will be enabled and the destination for the archived redo log file will be set to the Flash RecoveryArea implicitly. D . Archiving will be enabled and the location for the archive redo log file will be created in the default location$ORACLE_HOME/log.

  查看最佳答案

• You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）

  A . User session data B . Stack space C . Private SQL area D . Location of the runtime area for DML and DDL Statements E . Location of a part of the runtime area for SELECT statement

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA’s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

  A .  statistics recommendations B .  SQL profile recommendations C .  index-related recommendations D .  restructuring of SQL recommendatio

  查看最佳答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

  查看最佳答案

• our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

  A . Oracle Net Manager B . Listener Control utility C . Database Configuration Assistant D . Oracle Net Configuration Assistant

  查看最佳答案

• The SQL Tuning Advisor configuration has default settings in your database instance.  Which recommendation is automatically implemented after the SQL Tuning Advisor is run as part of the automatic maintenance task？（）

  A .  statistics recommendations B .  SQL Profile recommendations C .  Index-related recommendations D .  restructuring of SQL recommendatio

  查看最佳答案

• You want to set the following initialization parameters for your database instance： https://assets.asklib.com/images/image2/2018080214463923133.jpg Identify the statement that correctly describes this setting.（）

  A . The MANDATORY location must be a flash recovery area. B . The optional destinations may not use the flash recovery area. C . This setting is not allowed because the first destination is not set as MANDATORY. D . The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

  查看最佳答案

• You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

  A .  The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE B .  The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA C .  The database instance starts，but Automatic Memory Management is disabled D .  The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

  查看最佳答案

• In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What isthe impact of this setting（）

  A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

  查看最佳答案

• A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

  A . Data Pump B . Oracle Net Manager C . Oracle Enterprise Manager D . Oracle Universal Installer （OUI） E . Database Configuration Assistant （DBCA）

  查看最佳答案

• in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.  What is the impactof this setting（）

  A . Optimizer statistics are collected automatically. B . Only timed operating system （OS） statistics and plan execution statistics are collected. C . The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. D . Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

  查看最佳答案

• 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）.

  查看最佳答案

• A database instance is using an Automatic Storage Management （ASM) instance, which has a d

  A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:SQL＞ CREATE DISKGROUP dgroup1 NORMAL REDUNDANCYFAILGROUP controller1 DISK ‘/devices/diska1‘, ‘/devices/diska2‘FAILGROUP controller2 DISK ‘/devices/diskb1‘, ‘/devices/diskb2‘ ;What happens when the whole CONTROLLER1 Failure group is damaged？（） A. The transactions that use the disk group will halt. B. The mirroring of allocation units occurs within the CONTROLLER2 failure group. C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered. D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.

  查看最佳答案

• 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？（）

  <img src='https://img2.soutiyun.com/shangxueba/ask/64233001-64236000/64234478/9691c5b47b07d813739fc0e9660c9439.jpg' /> A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively

  查看最佳答案

• The SQL Tuning Advisor has been configured with default configurations in your database instance.Which recommendation is automatically implemented without the DBA‘s intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework？（）

  A. statistics recommendations B. SQL profile recommendations C. index-related recommendations D. restructuring of SQL recommendations

  查看最佳答案

• Examine the parameters for your database instance:Which three statements are true about the process of automatic optimization by using cardinalityfeedback？（）

  A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics. B. The optimizer can re optimize a query only once using cardinality feedback. C. The optimizer enables monitoring for cardinality feedback after the first execution of a query. D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled. E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by thecollectors are submitted to the optimizer.

  查看最佳答案