网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
The following are the details of your database:   Instance name:test   Host name:tech1.us.oracle.com   IP address:145.33.230.186  Enterprise Manager Console HTTP Port number:5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()
A

http://145.33.230.186:5500/em

B

http://www.145.33.230.186:5500/em

C

http://tech1.us.oracle.com:5500/em

D

http://test.145.33.230.186:5500/em

E

http://test.tech1.us.oracle.com:5500

F

http://www.tech1.us.oracle.com:5500/em

G

http://test.tech1.us.oracle.com:5500/em


参考答案

参考解析
解析: 暂无解析
更多 “多选题The following are the details of your database:   Instance name:test   Host name:tech1.us.oracle.com   IP address:145.33.230.186  Enterprise Manager Console HTTP Port number:5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()Ahttp://145.33.230.186:5500/emBhttp://www.145.33.230.186:5500/emChttp://tech1.us.oracle.com:5500/emDhttp://test.145.33.230.186:5500/emEhttp://test.tech1.us.oracle.com:5500Fhttp://www.tech1.us.oracle.com:5500/emGhttp://test.tech1.us.oracle.com:5500/em” 相关考题
考题 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 are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()A、to enable the ASM instance to identify the alert log fileB、to enable the ASM instance to identify the server parameter fileC、to enable the ASM instance to define the locations for Oracle Managed Files (OMF)D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

考题 You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state, but all the background processes will be restarted.

考题 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_SIZEB、 The database instance starts,and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGAC、 The database instance starts,but Automatic Memory Management is disabledD、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

考题 n 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 AssistantB、 Recovery Manager (RMAN)C、 Oracle Data Pump Export and ImportD、 conventional Oracle Export and ImportE、 operating system utilities to copy the files to the ASM instance

考题 For which database operation would you need the database to be in the MOUNT state()A、renaming the control filesB、re-creating the control filesC、dropping a user in your databaseD、dropping a tablespace in your databaseE、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

考题 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 AssistantB、Recovery Manager (RMAN)C、Oracle Data Pump Export and ImportD、conventional Oracle Export and ImportE、operating system utilities to copy the files to the ASM instance

考题 When you try to open your database, you receive the following error:  ORA-00205: error in identifying control file   Where would you find the details required to resolve this error?()A、audit trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer

考题 You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number (SCN) to which you can flash back your database

考题 You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A、 The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B、 Before the instance starts, you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

考题 You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding the outcome of this command?()A、The command succeeds but it retrieves only the disk names.B、The command produces an error because the ASM instance is down.C、The command succeeds but it shows only the status of the ASM instance.D、The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

考题 Your database is not configured for session failover. Your tnsnames.ora file contains the following details:  test.us.oracle.com= (DESCRIPTION=  (ADDRESS_LIST= (LOAD_BALANCE=off)   (FAILOVER=ON)   (ADDRESS= (PROTOCOL=tcp)(HOST=test1-server)(PORT=1521))   (ADDRESS= (PROTOCOL=tcp)(HOST=test2-server)(PORT=1521)))   (CONNECT_DATA= (SERVICE_NAME=test.us.oracle.com)))   Which feature is enabled in this case?()A、Load balancingB、Instance failoverC、Database failoverD、Connect-time failoverE、Transparent Application Failover (TAF)

考题 单选题n 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 AssistantB  Recovery Manager (RMAN)C  Oracle Data Pump Export and ImportD  conventional Oracle Export and ImportE  operating system utilities to copy the files to the ASM instance

考题 单选题You work as a database administrator for Certkiller .com. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.  How would you proceed to recover the database?()A Start the instance and open the database, instance recovery automatically recovers control files B Create a file based on the contents of the trace file and save it to the control file locations and start the database C Re-create the database (The recovery of the control file is not possible because you have lost all the control files.) D Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. E Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 单选题For which database operation would you need the database to be in the MOUNT state()A renaming the control filesB re-creating the control filesC dropping a user in your databaseD dropping a tablespace in your databaseE configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

考题 单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ,you issued the following ASMCMD command:   ASMCMD lsdsk -I -d DATA   Which statement is true regarding the outcome of this command?()A  The command succeeds but it retrieves only the disk names.B  The command produces an error because the ASM instance is down.C  The command succeeds but it shows only the status of the ASM instance.D  The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

考题 单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred, resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario?()A The instance would hang.B The instance needs to be shut down.C The instance would be in the open state.D The instance would abort in such cases.E The instance would be in the open and invalid state.F The instance would in the open state, but all the background processes will be restarted.

考题 单选题You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()A  mount the new disk group in the ASM instanceB  restart the ASM instance and the production database instanceC  register the new disk groups in the production database instanceD  restart the ASM instance without restarting the production database instanceE  include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

考题 单选题Your production database uses an Automatic Storage Management (ASM) instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users?()A mount the new disk group in the ASM instanceB restart the ASM instance and the production database instanceC register the new disk groups in the production database instanceD restart the ASM instance without restarting the production database instanceE include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

考题 单选题You work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()A You must have started the database instance in restricted mode.B You must have started the database instance inNORMALmode.C You must have started the database instance with server parameter file.D You must have started the database instance but must not have mounted.E You must have started the database instance but must not have opened.

考题 单选题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/x7fASM instance to an ASM instance?()A Oracle Migration AssistantB Recovery Manager (RMAN)C Oracle Data Pump Export and ImportD conventional Oracle Export and ImportE operating system utilities to copy the files to the ASM instance

考题 单选题You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. While studying the parameter file of the ASM instance, you find the following entry:  ASM_DISKSTRING = /devices/*  What could be the reason for this setting?()A to enable the ASM instance to identify the alert log fileB to enable the ASM instance to identify the server parameter fileC to enable the ASM instance to define the locations for Oracle Managed Files (OMF)D to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

考题 单选题You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database?()A Start the instance and open the database, instance recovery automatically recoverscontrol filesB Create a file based on the contents of the trace file and save it to the control file locations and start the databaseC Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)D Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.E Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

考题 多选题The following are the details of your database:Instance name:test  Host name : tech1.us.oracle.com IP address:145.33.230.186 Enterprise Manager Console HTTP Port number:5500  You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser.  Which two URLs would you use to access the Database Control?()Ahttp://145.33.230.186:5500/emBhttp://www.145.33.230.186:5500/emChttp://tech1.us.oracle.com:5500/emDhttp://test.145.33.230.186:5500/emEhttp://test.tech1.us.oracle.com:5500Fhttp://www.tech1.us.oracle.com:5500/emGhttp://test.tech1.us.oracle.com:5500/em

考题 单选题When you try to open your database, you receive the following error:  ORA-00205: error in identifying control file   Where would you find the details required to resolve this error?()A audit trailB alert log fileC user trace fileD online trace fileE background trace fileF operating system event viewer

考题 单选题You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.  What will be the implications on the 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 FlashRecovery Area implicitly.D Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.

考题 单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD lsdsk -I -d DATA Which statement is true regarding the outcome of this command?()A The command succeeds but it retrieves only the disk names.B The command produces an error because the ASM instance is down.C The command succeeds but it shows only the status of the ASM instance.D The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.