Oracle Database 10g: Administration II
Exam Number/Code : 1Z0-043
Exam Name : Oracle Database 10g: Administration II
Questions and Answers : 217 Q&As

itcerthome Cisco certification offers free 1Z0-043 dumps,1Z0-043 Practice exam,1Z0-043 exam questions for 10g DBA certification(Oracle Certified Network Associate). You can check out the question quality and usability of our 1Z0-043 practice exam before you decide to buy it.Before you purchase our 1Z0-043 Q&A,you can click the link http://www.itcerthome.org/1Z0-043.html to download the latest 1Z0-043 pdf dumps.

Exam : Oracle 1Z0-043
Title : Oracle Certification Database 10g: Administration II
1. You execute the following command to enable a session in resumable mode:
SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60;
What is the impact of a timeout on the statements being suspended?
A. The statements remain suspended for at least 60 seconds.
B. The statements are suspended for 60 seconds and then they are executed.
C. The suspended statements error out if the problem is not rectified within 60 seconds.
D. The statements are automatically suspended 60 seconds after an error is received, and then attempt to execute normally again.
Answer: C
2. Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement.
What was the first step that was needed in the process to achieve this objective?
A. The user must have been granted the DBA role.
B. The user must have been granted the switch privilege as a part of a role.
C. The user must have been granted the Resource Manager administrator privilege.
D. The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
Answer: D

The related exams:
1z0-045 Data Center Networking Infrastructure Support Specialist
1z0-047 Cisco Data Center Application Services Implementation
1z0-048 Advanced Routing and Switching for Account Managers