在Oracle中，你以SYSDBA登录，CUSTOMER表位于Mary用户方案中，下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词（）。A、CREATE PUBLIC SYNONYM cust ON mary.customerB、CREATE PUBLIC SYNONYM cust FOR mary.customerC、CREATE SYNONYM cust ON mary.customer FOR PUBLICD、不能创建CUSTOMER的公用同义词
在Oracle中，你以SYSDBA登录，CUSTOMER表位于Mary用户方案中，下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词（）。
- A、CREATE PUBLIC SYNONYM cust ON mary.customer
- B、CREATE PUBLIC SYNONYM cust FOR mary.customer
- C、CREATE SYNONYM cust ON mary.customer FOR PUBLIC
- D、不能创建CUSTOMER的公用同义词
相关考题：
在oracle数据库中,你想访问EMPLOYEE表中的employee列该列的数据存储在操作系统文件中,你需要在表中增加一列,选择什么数据类型?() A.BFILEB.LONGRAWC.BLOBD.CLOB
参数remote_login_passwordfile设置为EXCLUSIVE是什么含义?() A. 不支持远程sysdba的登录B. 支持远程sysdba的登录,一个数据库使用一个密码文件C. 支持远程sysdba的登录,多个数据库可以使用同样的密码文件
在Oracle中,你以SYSDBA登录,CUSTOMER表位于Mary用户方案中,下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词()。 A.CREATE PUBLIC SYNONYM cust ON mary.customerB.CREATE PUBLIC SYNONYM cust FOR mary.customerC.CREATE SYNONYM cust ON mary.customer FOR PUBLICD.不能创建CUSTOMER的公用同义词
当在SQL*Plus中需要以DBA连接到Oracle数据库,可以使用如下()方式。 A.CONNECT SYS/password SYSDBAB.CONNECT SYS/password AS SYSDBAC.CONNECT AS SYSDBA SYS/passwordD.CONNECT DBA SYS/password
下面是远程破解Oracle账户的方法,选择一个错误的?() A.选择远程破解Oracle的最好帐户是SYS，因为此帐户永远有效B.用Orabrute工具来进行远程破解需要依赖SQLplus进行登录验证C.用户的密码以明文方式保存在SYS.USER$表中D.Oracle10g默认可通过WEB的8080端口来远程管理数据库
Linux下使用命令行方式登录iSQL方法（）。A、直接执行isql命令执行即可B、进入DM安装bin目录，执行./isql命令，剩余配置同windowsC、在终端执行./isql SYSDBA/SYSDBA@localhost命令D、在终端执行./isql start命令
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.
Oracle中如何设置audittrail审计，正确的说法是：（）A、在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”B、以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计C、Oracle不支持对audittrail的审计D、在设置audittrail审计前，要保证已经打开Oracle的审计机制
在Oracle允许你在子表中创建FOREIGNKEY约束条件之前，父表应当先具备什么条件（）A、在父表的主键列已经存在FOREIGNKEY约束条件B、在父表中必须存在PRIMARYKEY或UNIQUEKEY约束条件C、在父表中必须存在索引D、在父表中必须存在CHECK约束条件
在oracle数据库中，你想访问EMPLOYEE表中的employee列该列的数据存储在操作系统文件中，你需要在表中增加一列，选择什么数据类型？（）A、BFILEB、LONGRAWC、BLOBD、CLOB
A customer is looking at an Oracle eBusiness solution. They would like to know what hardware they will need for the solution. They have some preliminary information from Oracle, including hardware requirements and specifics for their environment. Which of the following should be done next?（）A、Configure a 2 node x3950 X5 B、Customer needs a System p server to support Oracle applications C、Download the Oracle eBusiness sizing questionnaire from IBM, fill out with customer and submit to IBM for System x sizing D、Configure a system that meets the minimum requirements
In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first？（） A、 authentication by password fileB、 authentication by using certificates over SSLC、 authentication by using the Oracle Internet DirectoryD、 authentication by using the local OS of the database server
单选题在Oracle允许你在子表中创建FOREIGNKEY约束条件之前，父表应当先具备什么条件（）A在父表的主键列已经存在FOREIGNKEY约束条件B在父表中必须存在PRIMARYKEY或UNIQUEKEY约束条件C在父表中必须存在索引D在父表中必须存在CHECK约束条件
单选题“注册表”“HKEY_LOCAL_MACHINE”下“Software”下的“CTAIS”注册项下主键“Oracle”下哪项设置不正确时。在CTAIS系统用户登录时，无法连接后台Oracle数据库，从而无法登录CTAIS系统。（）ASCHEMABDBPARMCSERVERDDBMS
单选题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？（）Acontrol fileBpassword fileClistener controller fileDcontrol file and password file
单选题在oracle数据库中，你想访问EMPLOYEE表中的employee列该列的数据存储在操作系统文件中，你需要在表中增加一列，选择什么数据类型？（）ABFILEBLONGRAWCBLOBDCLOB
单选题当在SQL*Plus中需要以DBA连接到Oracle数据库，可以使用如下（）方式。ACONNECT SYS/password SYSDBABCONNECT SYS/password AS SYSDBACCONNECT AS SYSDBA SYS/passwordDCONNECT DBA SYS/password
单选题在Oracle中，你以SYSDBA登录，CUSTOMER表位于Mary用户方案中，下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词（）。ACREATE PUBLIC SYNONYM cust ON mary.customerBCREATE PUBLIC SYNONYM cust FOR mary.customerCCREATE SYNONYM cust ON mary.customer FOR PUBLICD不能创建CUSTOMER的公用同义词
多选题Oracle中如何设置audittrail审计，正确的说法是：（）A在init.ora文件中设置“audit_trail=true”或者“audit_trail=db”B以SYSDBA身份使用AUDITALLONSYS.AUD$BYACCESS，语句对audittrail审计COracle不支持对audittrail的审计D在设置audittrail审计前，要保证已经打开Oracle的审计机制
单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）AThe user must be granted the database administrator （DBA） privilege.BThe user must be listed in the password file for the authentication.CNo special setup is needed for the user to connect as SYSDBA in iSQL*Plus.DSet up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.