Download Oracle.1z0-034.PrepAway.2018-11-28.87q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-034 |
| Exam Name: | Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP |
| Date: | Nov 28, 2018 |
| File Size: | 2 MB |
| Downloads: | 1 |
Demo Questions
Question 1
You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the
DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?
- It is a list of remote database links stored in the XML file that are available to the users of the database.
- It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.
- It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.
- It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages suchas UTL_TCP.
Correct answer: B
Explanation:
The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access ControlList (ACL). Refer to here for About Fin-Grained Access to External Network ServicesConfiguring fine-grained access control for users and roles that need to access external network services fromthe database. This way, specific groups of users can connect to one or more host computers, based onprivileges that you grant them. Typically, you use this feature to control access to applications that run onspecific host addresses. To configure fine-grained access control to external network services, you create an access control list (ACL),which is stored in Oracle XML DB. You can create the access control list by using Oracle XML DB itself, orby using the DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages. This guideexplains how to use these packages to create and manage the access control list. To create an access controllist by using Oracle XML DB and for general conceptual information about access control lists, see Oracle XMLDB Developer's Guide. The DBMS_NETWORK_ACL_ADMIN package provides the interface to administer the network Access ControlList (ACL).
Refer to here for About Fin-Grained Access to External Network ServicesConfiguring fine-grained access control for users and roles that need to access external network services fromthe database. This way, specific groups of users can connect to one or more host computers, based onprivileges that you grant them.
Typically, you use this feature to control access to applications that run onspecific host addresses.
To configure fine-grained access control to external network services, you create an access control list (ACL),which is stored in Oracle XML DB. You can create the access control list by using Oracle XML DB itself, orby using the DBMS_NETWORK_ACL_ADMIN and DBMS_NETWORK_ACL_UTILITY PL/SQL packages. This guideexplains how to use these packages to create and manage the access control list. To create an access controllist by using Oracle XML DB and for general conceptual information about access control lists, see Oracle XMLDB Developer's Guide.
Question 2
Which four resources can directives be specified by using the Oracle Resource Manager?
- CPU usage
- degree of parallelism
- number of open cursors
- number of sorts performed
- idle time for blocking sessions
- number of I/Os requests
Correct answer: ABEF
Question 3
You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).
Identify two scenarios in which you must have a recovery catalog.
- To store the backup information of multiple database
- To restrict the amount of space that is used by the backups
- To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
- To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.
Correct answer: AD
