当前位置:1Z0-042题库

问题:

[单选] In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()

A . The optimizer statistics are collected automatically.
B . Only the timed operating system (OS) statistics and plan execution statistics are collected.
C . The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
D . The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. 
E . Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.

You are working as a DBA at NetFx Corporation. A user, Scott, is maintaining the records of all the employees in the EMPLOYEEtable. Initially, the salary of the employee, ’E0025’, was $1800. On 1 May 2004, the salary of the employee, ’E0025’, was increased by $200.   The user, Scott, issued the following statement to modify the record of the employee, ’E0025’:   SQL>UPDATE EMPLOYEE  SET SALARY = 2000   WHERE EMPNO = ’E0025’;   SQL>COMMIT;   On December 1, 2004, the salary of the employee, ’E0025’, was increased by $400. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’:   SQL>UPDATE EMPLOYEE  SET SALARY = 2400   WHERE EMPNO = ’E0025’;   SQL>COMMIT;   On July 1, 2005, the salary of the employee, ’E0025’, was increased by $500. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’   SQL>UPDATE EMPLOYEE  SET SALARY = 2900   WHERE EMPNO = ’E0025’;   SQL>COMMIT;   On July 5, 2005, the HR manager asked you to generate the increment report of the employee, ’E0025’, for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report?()  Flashback Drop。  Flashback Table。  Flashback Database。 Flashback Version Query。 涉及国有资产属于必须进行资产评估的资产业务有()。 企业经营,产成品出售。 资产转让,企业清算。 企业所有权与经营权分离。 企业兼并,企业出售。 中外合资、合作。 Company.com wants to reassign a host bus adapter (HBA) from one partition to another to  handle increased I/O workload on that partition. What needs to be done to dynamically move the card?() Use the rmdev command to remove the card from the current partition before doing the DLPAR process.。 Take the source partition down and do the DLPAR function on the target partition.。 Assign the card to the required section of the target partition and run cfgmgr.。 Dynamically remove the card from the source and add to target profile then reactivate the target profile.。 View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command: SQL> GRANT MGR_ROLE TO SKDWITH ADMIN OPTION;  Which statement is true about the user SKD after he/she is granted this role() The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it. 。 The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.。 The user SKD can grant the privileges in the MGR_ROLE role to other users, but not with ADMIN OPTION.。 The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them.。 变压器的瓦斯保护的启动是靠()。 电气动作。 机械动作。 油流和气流的运动。 In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
参考答案:

  参考解析

本题暂无解析

相关题目:

在线 客服