网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
当在SQL*Plus中需要以DBA连接到Oracle数据库，可以使用如下（）方式。
- A、CONNECT SYS/password SYSDBA
- B、CONNECT SYS/password AS SYSDBA
- C、CONNECT AS SYSDBA SYS/password
- D、CONNECT DBA SYS/password
参考答案
更多 “当在SQL*Plus中需要以DBA连接到Oracle数据库，可以使用如下（）方式。A、CONNECT SYS/password SYSDBAB、CONNECT SYS/password AS SYSDBAC、CONNECT AS SYSDBA SYS/passwordD、CONNECT DBA SYS/password” 相关考题
考题
以数据库超级管理员的身份连接到一个用户名system、密码oracle、名称为lteomc的数据库的命令为________。A.sqlplus system/oracle@lteomc as sysdbaB.sqlplus sys/oracle@lteomc as dbaC.sqlplus system：oracle@lteomc as sysdbaD.sqlplus sys：oracle@lteomc as dba
考题
heDBAisabouttoenableauditingontheOracledatabaseinanattempttodiscoversomesuspiciousactivity.Audittrailinformationisstoredinwhichofthefollowingdatabaseobjectnames?()
A.SYS.SOURCE$B.SYS.AUD$C.DBA_SOURCED.DBA_AUDIT_TRAIL
考题
当在SQL*Plus中需要以DBA连接到Oracle数据库,可以使用如下()方式。
A.CONNECT SYS/password SYSDBAB.CONNECT SYS/password AS SYSDBAC.CONNECT AS SYSDBA SYS/passwordD.CONNECT DBA SYS/password
考题
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.
考题
Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A、The user must be granted the database administrator （DBA） privilege.B、The user must be listed in the password file for the authentication.C、No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.D、Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.
考题
PONNBI等待TL1 GW响应的超时时间可以通过参数来修改的A、tl1agent_client_ip.confB、ponnbi_sys.confC、service.xmlD、tl1connect.conf
考题
在DOS命令行输入以下哪一命令，不能正确地连接SQL*Plus（）。A、sqlplus sys/oracleB、sqlplus system/oracle@orclC、sqlplus sys/o123assysdbaD、sqlplus system/o123
考题
以数据库超级管理员的身份连接到一个用户名system、密码oracle、名称为lteomc的数据库的命令为（）A、sqlplus system/oracle@lteomc as sysdbaB、sqlplus sys/oracle@lteomc as dbaC、sqlplus system：oracle@lteomc as sysdbaD、sqlplus sys：oracle@lteomc as dba
考题
Which two passwords must be supplied in order to connect by Telnet to a properly secured Cisco switch and make changes to the device configuration? (Choose two.)（）A、console passwordB、vty passwordC、aux passwordD、tty passwordE、enable secret passwordF、username password
考题
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）A、SYSDBAB、SYSOPERC、No system privileges are required for the RMAN user.D、Only SYS user can connect and execute RMAN commands on a target database.
考题
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 want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）A、control fileB、password fileC、listener controller fileD、control file and password file
考题
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）A、SYSTEM B、OUTLN C、INTERNAL D、SYS
考题
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）A、SYS.SOURCE$ B、SYS.AUD$ C、DBA_SOURCE D、DBA_AUDIT_TRAIL
考题
单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A
The user must be granted the database administrator （DBA） privilege.B
The user must be listed in the password file for the authentication.C
No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.D
Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.
考题
单选题以数据库超级管理员的身份连接到一个用户名system、密码oracle、名称为lteomc的数据库的命令为:A
sqlplus system/oracle@lteomc as sysdbaB
sqlplus sys/oracle@lteomc as dbaC
sqlplus system：oracle@lteomc as sysdbaD
sqlplus sys：oracle@lteomc as dba
考题
单选题当在SQL*Plus中需要以DBA连接到Oracle数据库，可以使用如下（）方式。A
CONNECT SYS/password SYSDBAB
CONNECT SYS/password AS SYSDBAC
CONNECT AS SYSDBA SYS/passwordD
CONNECT DBA SYS/password
考题
单选题You want to implement the backup and recovery strategy in your database using Recovery Manager （RMAN）. You have chosen the control file of the target database for the RMAN repository. Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication？（）A
rman TARGET / NOCATALOGB
rman TARGET sys/passwordC
rman TARGET sys/password AS SYSDBAD
rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat
考题
单选题You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）A
SYSDBAB
SYSOPERC
No system privileges are required for the RMAN user.D
Only SYS user can connect and execute RMAN commands on a target database.
考题
单选题You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database. You executed the following RMAN commands： RMAN CONNECT TARGET sys/sys@APPPROD RMAN CONNECT AUXILIARY sys/sys@DUPDB RMAN DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPILE NOFILENAMECHECK； What are the implications of this command？（）A
It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.B
It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.C
It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.D
It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
考题
判断题SYS用户是Oracle中默认的系统管理员，它拥有DBA权限。A
对B
错
热门标签
最新试卷