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.
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.
相关考题:
下面是该网站中数据库连接程序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)%>
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
在模型层中,下列()负责连接数据库 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";
在模型层中,下列()负责加载驱动类 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";
SQLServer数据库提供的错误信息如何查看?() A.查看系统视图sys.database_filesB.查看系统视图sys.messagesC.查看系统视图sys.errorD.查看系统视图sys.stats
ORACLE初始化参数文件的默认路径是:() A.对于UNIX,在$ORACLE_HOME/dbsB.对于UNIX,在$ORACLE_HOME/dbs/adminC.对于Linux,在%ORACLE_HOME%\databaseD.对于Windows,在%ORACLE_HOME%\dbsE.对于Windows,在%ORACLE_HOME%\database\admin
该网站数据库连接程序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.openC.pubs D.pubs_logE.serverF.request
可以通过()系统目录视图查看指定数据库的基本信息。A.sys.database_filesB.sp_helpdbC.sp_spaceusedD.sys.database