当前位置:1Z0-052题库

问题:

[多选]

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted: INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) * 
ERROR at line 1: 
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.()

A . Grant the RESOURCE role to SCOTT.
B . Add data files to the USERS tablespace.
C . Grant the CREATE ANY TABLE privilege to SCOTT.
D . Increase the space for SCOTT on the USERS tablespace.
E . Increase the size of the data file associated with the USERS tablespace

A server has two PCI-X buses with four Active PCI-X slots.  Slots 1 and 2 are on the first PCI-X bus (100MHz) and slots 3 and 4 are on the second PCI-X bus (133MHz). The customer requires you to install adapter A and adapter B on day one.  After the server has been installed and configured, the server must  be running 24 by 7 with no downtime. Three months later, adapter C needs to be hot added. All the adapters are 64-bit and capable of speeds up to 133MHz.  The customer’s priority is to have no downtime, and performance is secondary.   Based on the information provided, into which slots should adapters A and B be installed in and later into which slot would adapter C be hot-added?() Adapter A in slot 1, adapter B in slot 4 and hot-add adapter C in slot 3。 Adapter A in slot 1, adapter B in slot 3 and hot-add adapter C in slot 2。 Adapter A in slot 2, adapter B in slot 4 and hot-add adapter C in slot 3。 Adapter A in slot 3, adapter B in slot 1 and hot-add adapter C in slot 4。 草坪养护质量标准 Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()    Create new indexes.。  Modify existing indexes.。  Implement partitioning on a nonpartitioned table.。  Create materialized views.。  All of the above。 Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.) As ASM instance mounts an ASM control file。 An ASM instance uses the ASMB process for rebalancing of disks within a disk group。 Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly。 An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started。 地理信息系统

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error after the INSERT statement is issued and few rows are inserted: INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) * 
ERROR at line 1: 
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.()

参考答案:

  参考解析

本题暂无解析

在线 客服