Enterprise manager em script e recovery manager rman

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: E QUESTION 144: You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases, creating and managing tablespaces and database users, and taking regular backups, for all of the three databases from London. Actualtests.com - The Power of Knowing 1Z0-042 Which component must be enabled and running on each host machine to achieve your objective? A. Oracle Management Agent B. Enterprise Manager with Grid Control C. Enterprise Manager with Database Control D. Operating System Socket for incoming requests E. Real Application Cluster (RAC) with three instances F. Enterprise Manager with Generic Database Management Answer: A QUESTION 145: Exhibit: View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables. User A wants to insert rows from EMPLOYEES and DEPARTMENTS table into EMP_DEP table by using following insert command. INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) SELECT e.employee_id, e.first_name ||' '|| e.last_name, e.salary, d.department_name, e.manager_id FROM employees e, departments d where e.department_id = d.department_id; Actualtests.com - The Power of Knowing 1Z0-042 While user A executes the command, it errors out, displaying the following error message: INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id) * ERROR at line 1: ORA-01653: unable to allocate extent table A.EMP_DEP by 8 in tablespace USERS What would have caused the error? A. The user A does not have space quota. B. RESOURCE role has not been granted to user A. C. User A does not have insert privilege on EMP_DEP table. D. The EMP_DEP table is residing on a temporary tablespace. E. The default tablespace of user A does not have enough free space. F. The tablespace where EMP_DEP table resides does not have enough free space. Answer: F QUESTION 146: You decided to increase the value for the SHARED_SERVERS parameter by using the following command: SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=?; Which three values can be specified for the SCOPE clause? (Choose three...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online