首页计算机考试Oracle认证
(单选题)

在Oracle中,你以SYSDBA登录,CUSTOMER表位于Mary用户方案中,下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词()。

ACREATE PUBLIC SYNONYM cust ON mary.customer

BCREATE PUBLIC SYNONYM cust FOR mary.customer

CCREATE SYNONYM cust ON mary.customer FOR PUBLIC

D不能创建CUSTOMER的公用同义词

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    在登录到Oracle Enterprise Manager时,要求验证用户的身份。下面不属于可以选择的身份是()。

    答案解析

  • (多选题)

    Examine the commands executed to monitor database operations: $> conn sys oracle/oracle@prod as sysdba SQL > VAR eid NUMBER SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’); Which two statements are true?()

    答案解析

  • (单选题)

    要重新启动ORACLE数据库服务器,首先要以哪种身份登录数据库()

    答案解析

  • (单选题)

    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?()

    答案解析

  • (单选题)

    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: Which authentication method would be used first?()

    答案解析

  • (单选题)

    在Oracle中,下列()语句不能用于控制游标。

    答案解析

  • (单选题)

    在Oracle中,通过命令()可以释放锁。

    答案解析

  • (单选题)

    在Oracle中,不属于游标属性的是()。

    答案解析

  • (单选题)

    在Oracle中,用户()拥有所有内置的程序包。

    答案解析

快考试在线搜题