Online Access Free 1z1-034 Exam Questions

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.
One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
Which action should you perform immediately after using this command?

• A.You should make a backup of the database
• B.You should shut down the database instance and perform a complete database recovery
• C.You should switch the database to the NOARCHIVELOG mode
• D.You should perform a log switch

Which steps are mandatory to enable Direct NFS?
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11.so_stub with libodm11.so.

• A.1 and 3
• B.1, 2 and 3
• C.2 and 3
• D.1 and 2

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.

• A.To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
• B.To restrict the amount of space that is used by the backups
• C.To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.
• D.To store the backup information of multiple database

Which four resources can directives be specified by using the Oracle Resource Manager?

• A.number of open cursors
• B.number of I/Os requests
• C.number of sorts performed
• D.degree of parallelism
• E.CPU usage
• F.idle time for blocking sessions

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?

• A.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.
• B.It is a list of remote database links stored in the XML file that are available to the users of the database.
• C.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 such as UTL_TCP.
• D.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.