You connected to the database using the following connection

题目
多选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You have a computer that runs Windows Vista.You connect to your company’s network by using a virtual private network (VPN) connection. You notice that when you establish the VPN connection, you are unable to access Internet Web sites. When you disconnect the VPN connection, you can access Internet Web sites.You need to access Internet Web sites while you are connected to the VPN connection.What should you do?()

A.A

B.B

C.C

D.D


参考答案:D

第2题:

In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command:  CONFIGURE CONTROLFILE AUTOBACKUP ON;  Which two events would cause the control file to be backed up automatically? ()

  • A、a tablespace is taken offline
  • B、the database instance is restarted
  • C、a new data file is added to an existing tablespace
  • D、a successful backup is recorded in the RMAN repository
  • E、the RMAN connection is disconnected from the target database

正确答案:C,D

第3题:

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?()

A. The source database should be open

B. The target database should be in ARCHIVELOG mode if it is open

C. RMAN should be connected to both the instances as SYSDBA

D. The target database backups should be copied to the source database backup directories

E. The password file must exist for the source database and have the same SYS user password as the target


参考答案:B, C, E

第4题:

In Recovery Manager (RMAN), you have set control file autobackup to ON by using the following command: CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically? ()

  • A、 A tablespace is taken offline.
  • B、 The database instance is restarted.
  • C、 A new data file is added to an existing tablespace.
  • D、 A successful backup is recorded in the RMAN repository.
  • E、 The RMAN connection is disconnected from the target database.

正确答案:C,D

第5题:

Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command:  LSNRCTL> STOP  What would happen 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 active transactions are rolled back and the sessions get terminated.
  • D、The sessions are not allowed to perform any operations till the listener is started.

正确答案:B

第6题:

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.

正确答案:D

第7题:

The WebSphere Application Server provides a Dynamic Cache Monitor.  Which of the following can be monitored using this tool?()

  • A、Servlet Response Times
  • B、Cache Statistics
  • C、Database Connection Pool Statistics
  • D、Disk Statistics

正确答案:B,D

第8题:

You have a computer that runs Windows Vista. You create a virtual private network (VPN) connection between the computer and your company’s network.You notice that while the computer is connected through the VPN connection, users on the company network can access shared folders on the computer.You need to prevent network users from accessing your shared folders when you are connected to the company’s network by using the VPN connection.What should you do?()

A.A

B.B

C.C

D.D


参考答案:C

第9题:

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.

正确答案:A,C,F

第10题:

You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMAN>BACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP; command?()

  • A、 Start the database in the MOUNT stage.
  • B、 Back up the control file to trace.
  • C、 Set the DBID
  • D、 Issue the RECOVER DATABASE command.

正确答案:C

更多相关问题