网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
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” 相关考题
考题
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?()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 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?()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.
考题
单选题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)
考题
单选题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
考题
多选题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?()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 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
DB_BLOCK_SIZEB
CONTROL_FILESC
LARGE_POOL_SIZED
LOG_ARCHIVE_DESTE
LOG_ARCHIVE_FORMATF
DB_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?()A
The database instance is not available.B
The ALTER TABLE command does not have WAIT optionC
The table or a row in the table is currently locked by another user session.D
The database instance is busy processing other user sessions commands.E
The CUSTOMERS table has no long running query active at the time when this request is made.F
The 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?()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.
热门标签
最新试卷