This preview shows page 1. Sign up to view the full content.
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
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.
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
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
E.Quota 10MB on Certkiller TBS1
F.Password never expire
G.Defaulttablespace Certkiller TBS1
H.Quota unlimited on Certkiller TBS1
Answer: D, E, G
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.
- Fall '09