当前位置:1Z0-053题库

问题:

[多选]

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. 
What configuration would you effect to achieve your objective?()  

A .  Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
B .  Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
C .  Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
D .  Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

A customer wants to hold all enterprise data on their DS4000 system.  Several servers were added after they purchased another company.  The servers that have to be run are:       (1)An Oracle database running on a HP-UX server   (2)Several virtual machines running on VMWare ESX server       (3)A Microsoft cluster running Exchange 2000 server   Which of these new servers can be integrated with the DS4000?() DS4000 storage does not support HP-UX, so the HP-UX server cannot be integrated.All other new servers can be used.。 An Exchange cluster needs local disks, so the DS4000 cannot be used for this.All other new servers can be used.。 When equipped with proper HBA’s and subsystem device drivers, all new servers can operate with the DS4000 storage device.。 VMWare ESX can use the DS4000 storage; however, the virtual machines running in it will not have access to this storage other than via a virtual disk.All other new servers can be used.。 变压器扇形温度计是反映()。 线圈温度。 铁芯温度。 上层油温。 Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view? () SELECT a.last_name, a.salary, a.department_id, b.maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;。 SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))。 SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);。 SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id)。 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?() ALTER DATABASE DROP LOGFILE GROUP 1;。 ALTER DATABASE CLEAR LOGFILE GROUP 1;。 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;。 ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG。 在ABC库存分类法中,C类库存品一般占总库存品种数的() 10%以下。 15%-20%。 20%-25%。 60%-65%。

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. 
What configuration would you effect to achieve your objective?()  

参考答案:

  参考解析

本题暂无解析

在线 客服