itgle.com

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

题目

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

A. Database operations will be monitored only when they consume a significant amount of resource.

B. Database operations for all sessions will be monitored.

C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.

D. Only DML and DDL statements will be monitored for the session.

E. All subsequent statements in the session will be treated as one database operation and will be monitored.

相似考题

1.下面是该网站中数据库连接程序conn.inc的代码，请在空白处填入相应的程序代码。＜%Setcorm=server.(1)("adodb.connection")conn.provider="sqloledb"provstr="server=127.0.0.1；database=(2)；uid=(3)；pwd=(4)"conn.open(5)%＞

2.在模型层中,下列()负责连接数据库A.Class.forName("oracle.jdbc.OracleDriver");B.conn=DriverManager.getConnection(url,username,userpwd);C.stmt=conn.prepareStatement(sql);D.privateStringurl="jdbc:oracle:thin:@localhost:1521:orcl";

3.在模型层中,下列()负责加载驱动类A.Class.forName("oracle.jdbc.OracleDriver");B.conn=DriverManager.getConnection(url,username,userpwd);C.stmt=conn.prepareStatement(sql);D.privateStringurl="jdbc:oracle:thin:@localhost:1521:orcl";

4.You enabled an audit policy by issuing the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? （）A. SYS, SYSTEMB. SCOTTC. Only for successful executionsD. Only for failed executionsE. Both successful and failed executions

更多“Examine the commands executed to monitor database operations:$> conn sys oracle／oracle@ ”相关问题

  • 第1题：

    SQLServer数据库提供的错误信息如何查看?()

    A.查看系统视图sys.database_files

    B.查看系统视图sys.messages

    C.查看系统视图sys.error

    D.查看系统视图sys.stats


    参考答案：B

  • 第2题：

    选择远程破解Oracle的最好账户是SYS，因为此账户永远有效。()


    答案：正确

  • 第3题：

    该网站数据库连接程序conn.inc部分代码如下，请在空白处填入相应的程序代码。 ＜% set conn=(4).createobject("adodb.connection") conn.provider="sqloledb" provstr="server=10.10.10.10；database=(5);uid=swwz;pwd=9765123" conn. (6) provstr %＞ (4)～(6)备选答案：A．run B．open

    C．pubs D．pubs_log

    E．serverF．request


    正确答案：(4)E或server (5)C或pubs (6)B或open
    (4)E或server (5)C或pubs (6)B或open 解析：考查的是Web数据库的连接代码。
    根据题目说明，该网站采用ASP+SQL Server开发，其数据库名称由问题1可知为pubs，所以数据库的连接代码为：
    %
    set conn= server..createobject("adodb.connection")
    conn.provider="sqloledb"
    provstr="server=10.10.10.10; database= pubs; uid=swwz; pwd=9765123"
    conn. open provstr
    %＞

  • 第4题：

    Oracle的SYS账户在数据库中具有最高权限，能够做任何事情，包括启动/关闭Oracle数据库。即使SYS被锁定，也已然能够访问数据库。()


    答案：正确

  • 第5题：

    ORACLE初始化参数文件的默认路径是:()

    A.对于UNIX，在$ORACLE_HOME/dbs

    B.对于UNIX，在$ORACLE_HOME/dbs/admin

    C.对于Linux，在%ORACLE_HOME%\database

    D.对于Windows，在%ORACLE_HOME%\dbs

    E.对于Windows，在%ORACLE_HOME%\database\admin


    参考答案：A

  • 第6题：

    可以通过（)系统目录视图查看指定数据库的基本信息。

    A．sys.database_files

    B．sp_helpdb

    C．sp_spaceused

    D．sys.database


    sys.database_files

相关内容