多选题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
多选题
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
参考解析
解析：
暂无解析
相关考题：
You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）A、It gets it from the parameter file.B、The listener prompts for details on startup.C、The listener gathers information from the control file.D、The instance automatically registers with the default listener.E、The listener gets this information through thelistener.orafile.
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.
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
Your tnsnames.ora file has the following entry for the service alias ORCL： ORCL = （DESCRIPTION = （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521）） （CONNECT_DATA = （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com） ） ） The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command： SQL CONNECT scott/tiger@orcl What could be the reason for this？（）A、The listener is not running at the server.B、The TNS_ADMIN environmental variable is set to a wrong value.C、The orcl.oracle.com database service is not registered with the listener.D、The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.
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 connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb Which three statements are correct regarding the connection string？（）A、mydb is a service name.B、test.us.oracle.com is a database name.C、1521 is the listener port number.D、mydb is a host name.E、test.us.oracle.com is a net service name.F、hr is a username.G、test.us.oracle.com is an instance name.
When issuing the duplicate database command， you use the parameter DB_FILE_NAME_CONVERT. For what purpose do you use this parameter？（） A、 To indicate the location of the auxiliary-instance online redo logs.B、 To indicate the location of the target database datafiles.C、 To indicate the location of the auxiliary-instance control file and online redo logs.D、 To indicate the location of the auxiliary-instance database datafiles.E、 This is not a valid parameter when duplicating a database.
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）
单选题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？（）AStart the instance and open the database, instance recovery automatically recovers control files BCreate a file based on the contents of the trace file and save it to the control file locations and start the database CRe-create the database (The recovery of the control file is not possible because you have lost all the control files.) DStart the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file. EStart 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（）Arenaming the control filesBre-creating the control filesCdropping a user in your databaseDdropping a tablespace in your databaseEconfiguring 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 want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）A LARGE_POOL_SIZEB DB_CREATE_FILE_DESTC LOG_ARCHIVE_DESTD CONTROL_FILESE LOG_ARCHIVE_FORMATF DB_BLOCK_SIZE
单选题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？（）AThe instance would hang.BThe instance needs to be shut down.CThe instance would be in the open state.DThe instance would abort in such cases.EThe instance would be in the open and invalid state.FThe instance would in the open state， but all the background processes will be restarted.
单选题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？（）ALoad balancingBInstance failoverCDatabase failoverDConnect-time failoverETransparent Application Failover （TAF）
单选题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？（）AOracle Migration AssistantBRecovery Manager （RMAN）COracle Data Pump Export and ImportDconventional Oracle Export and ImportEoperating system utilities to copy the files to the ASM instance
多选题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
单选题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？（）Ato enable the ASM instance to identify the alert log fileBto enable the ASM instance to identify the server parameter fileCto enable the ASM instance to define the locations for Oracle Managed Files （OMF）Dto enable the ASM instance to identify all disks that can be accessed by it in the /devices directory
单选题You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_ARCHIVE_DEST = +dgroupA LOG_ARCHIVE_FORMAT = "$ORACLE_SID_%s_%t.%t" DB_CREATE_FILE_DEST = +dgroupA COMPATIBLE = 10.1.0.2.0 CONTROL_FILES = +dgroupA Which parameter would be ignored while starting up the instance for the database PROD？（）ADB_BLOCK_SIZEBCONTROL_FILESCLARGE_POOL_SIZEDLOG_ARCHIVE_DESTELOG_ARCHIVE_FORMATFDB_CREATE_FILE_DEST
单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）AThe database instance is not available.BThe ALTER TABLE command does not have WAIT optionCThe table or a row in the table is currently locked by another user session.DThe database instance is busy processing other user sessions commands.EThe CUSTOMERS table has no long running query active at the time when this request is made.FThe server process executing the ALTER TABLE command is busy with another command execution
多选题You connected to the database using the following connection string： CONNECT hr/hr@test.us.oracle.com：1521/mydb Which three statements are correct regarding the connection string？（）Amydb is a service name.Btest.us.oracle.com is a database name.C1521 is the listener port number.Dmydb is a host name.Etest.us.oracle.com is a net service name.Fhr is a username.Gtest.us.oracle.com is an instance name.
多选题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
多选题You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）AIt gets it from the parameter file.BThe listener prompts for details on startup.CThe listener gathers information from the control file.DThe instance automatically registers with the default listener.EThe listener gets this information through thelistener.orafile.
单选题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？（）Aaudit trailBalert log fileCuser trace fileDonline trace fileEbackground trace fileFoperating 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（）AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.DArchiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.