The error message forces the user to log off from and

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: - The Power of Knowing 1Z0-042 to the database to continue his work. ORA-02392: exceeded session limit on CPU usage, you are being logged off Which action would you take to increase the session limit on CPU usage? A. Modify the profile assigned to the user. B. Modify the roles assigned to the users. C. Modify the object privileges assigned to the user. D. Modify the system privileges assigned to the users. E. Modify the value for the RESOURCE_LIMIT parameter in the parameter file. Answer: A QUESTION 111: Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users' queries. Which component of the Oracle Instance would you change to improve performance? A. Java pool B. Large pool C. Shared pool D. Streams pool E. Library cache F. Redo log buffer G. Data dictionary cache H. Database buffer cache Answer: H QUESTION 112: User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp include = table include = view:"like '%DEPARTMENTS%'" content = DATA_ONLY Which task would the command accomplish? A. Oracle Data Pump would export only the data of all of the tables and views. B. Oracle Data Pump would export all of the table structures along with data and all the views. C. Oracle Data Pump would export the table data and the view definitions where the view Actualtests.com - The Power of Knowing 1Z0-042 name contains a string named DEPARTMENTS. D. Oracle Data Pump would export the table data and the view definitions with data where view name contains a string named DEPARTMENTS. E. Oracle Data Pump would export all of the table structures and the view definitions with data where view name contains a string named DEPARTMENTS. Answer: C QUESTION 113: When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details required to resolve this error? A. audit trail B. alert log file C. user trace file D. online trace...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online