网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, 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 on the database node.
B
The TNS_ADMIN environment variable is set to the wrong value.
C
The orcl.oracle.com database service is not registered with the listener.
D
The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
E
The listener is running on a different port.
参考答案
参考解析
解析：
暂无解析
更多 “单选题The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, 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 on the database node.B The TNS_ADMIN environment variable is set to the wrong value.C The orcl.oracle.com database service is not registered with the listener.D The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E The listener is running on a different port.” 相关考题
考题
You executed the following command:RMAN RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()
A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copyB. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backupC. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbfD. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails
考题
View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN REPAIR FAILURE;Which statement describes the consequence of the command?（）A. The command performs the recovery and closes the failures.B. The command only displays the advice and the RMAN script required for repair.C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
考题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, 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 on the database node.B. The TNS_ADMIN environment variable is set to the wrong value.C. The orcl.oracle.com database service is not registered with the listener.D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E. The listener is running on a different port.
考题
Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database. A、 rman target=/ catalog=/@rcatB、 rman target=/ catalog=rcat_own/rcat_ownC、 rman target=/ catalog=rcat_own/rcat_own@RCATD、 rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCATE、 You cannot connect to the target database and the recovery catalog at the same time.
考题
You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 You erroneously deleted the password file while the database was running. You re-create the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4 However， when you try to connect as the SYS user， you receive the following error： ORA-01031： insufficient privileges What should you do to resolve this error？（）A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.
考题
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD， and then assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege. What would youachieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying the username and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database 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.
考题
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
考题
You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（） A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
考题
You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyB、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC、 Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfD、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
考题
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, 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 on the database node.B、The TNS_ADMIN environment variable is set to the wrong value.C、The orcl.oracle.com database service is not registered with the listener.D、The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.E、The listener is running on a different port.
考题
You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks. To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 After creating the password file， you remove the operating system authentication and change the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（） A、 CONNECT / AS SYSDBAB、 CONNECT sys/admin AS SYSDBAC、 CONNECT sys/admin@mynewdb AS SYSDBAD、 CONNECT sys/change_on_install AS SYSDBA
考题
You work as a database administrator for Supportcenter.cn. You decided to manage client and server connections using Local Naming method in Supportcenter.cn. When you try to connect to the database you get the following error： ERROR： ORA-12154：TNS：couldnot resolve service name Which network configuration files would you look into to resolve this error？（）A、snmp.oraB、names.oraC、spfile.oraD、sqlnet.oraE、listener.oraF、tnsnames.ora
考题
You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command： LSNRCTLSTATUS listener1 Which information will NOT be displayed when you issue the above command？（） A、 whether the password is set in the listener or a file or notB、 the number of client connections the service handler has refusedC、 the information will be displayed whether the instance can accept connections or notD、 the protocol addresses on which the listener is configured to listen
考题
You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error. SQL startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 SQL alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1： ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error？（） a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery， applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.A、b， a， fB、e， b， a， fC、e， b， a， gD、b， a， gE、c， e， b， d， f
考题
单选题What could be the reason for this（）A
The listener is not running on the database node.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.
考题
多选题Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line？（） Assume that the target database is called ORCL and that the recovery catalog database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume the environment is configured for the ORCL database.Arman target=/ catalog=/@rcatBrman target=/ catalog=rcat_own/rcat_ownCrman target=/ catalog=rcat_own/rcat_own@RCATDrman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCATEYou cannot connect to the target database and the recovery catalog at the same time.
考题
单选题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.
考题
单选题You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command： LSNRCTLSTATUS listener1 Which information will NOT be displayed when you issue the above command？（）A
whether the password is set in the listener or a file or notB
the number of client connections the service handler has refusedC
the information will be displayed whether the instance can accept connections or notD
the protocol addresses on which the listener is configured to listen
考题
单选题You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks. To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 After creating the password file， you remove the operating system authentication and change the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）A
CONNECT / AS SYSDBAB
CONNECT sys/admin AS SYSDBAC
CONNECT sys/admin@mynewdb AS SYSDBAD
CONNECT sys/change_on_install AS SYSDBA
考题
单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）A
The database user OPS$SKD will be able to administer the database.B
The authentication detail for the database user OPS$SKD is recorded in the password file.C
The local operating system user SKD will be able to access the database instance without specifying theusername and password.D
The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
考题
单选题You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4 You erroneously deleted the password file while the database was running. You re-create the password file using the following command： ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4 However， when you try to connect as the SYS user， you receive the following error： ORA-01031： insufficient privileges What should you do to resolve this error？（）A
Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.B
Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.C
Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.D
Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.
考题
单选题You executed the following command： RMAN RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（）A
The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.B
The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.C
Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.D
Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
考题
单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD， and then assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege. What would youachieve by the above process（）A
The database user OPS$SKD will be able to administer the database.B
The authentication detail for the database user OPS$SKD is recorded in the password file.C
The local operating system user SKD will be able to access the database instance without specifying the username and password.D
The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
考题
单选题You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error. SQL startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 SQL alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1： ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error？（） a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery， applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.A
b， a， fB
e， b， a， fC
e， b， a， gD
b， a， gE
c， e， b， d， f
考题
单选题You executed the following command: RMAN RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）A
The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copyB
The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backupC
Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbfD
Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
热门标签
最新试卷
