What could be the possible reason for getting such an

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: ing such an error? A.Database is not open Actualtests.com - The Power of Knowing 1Z0-042 B.Listener is not running C.Service name is not correct D.Wrong port number used in URL E.Usersysdoes have themediaprivilege Answer: C QUESTION 57: You work as a database administrator for Certkiller .com. While granting a role, SELECT_CATALOG_ROLE, to a user, Certkiller, using Oracle Enterprise Manager 10g Database Control, you have cleared the DEFAULT check box. What will be the result? A.The user cannot use the role at all. B.The role would not be granted to the user. C.The user needs to enable the role explicitly. D.The user can start using the role immediately. E.The user would have the admin option for the role. Answer: C QUESTION 58: You work as a database administrator for Certkiller .com. You are working on Oracle Database 10g. To forward client connections to an instance, the listener must know information such as the name of the instance and where the instance's ORACLE_HOME is located. How does the listener get this information? Choose two. A.It gets it from the parameter file. B.The listener prompts for details on startup. C.The listener gathers information from the control file. D.The instance automatically registers with the default listener. E.The listener gets this information through thelistener.orafile. Answer: D, E QUESTION 59: Exhibit, requirements Actualtests.com - The Power of Knowing 1Z0-042 You work as a database administrator for Certkiller .com. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective? Choose three A.Profile B.Account lock C.Account unlock D.Password expire E.Quota 10MB on Certkiller TBS1 F.Password never expire G.Defaulttablespace Certkiller TBS1 H.Quota unlimited on Certkiller TBS1 I.TemporarytablespaceTEMP J.TemporarytablespaceSYSTEM Answer: D, E, G QUESTION 60: You work as a database administrator for Certkiller .com. You want to configure database backups to...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online