Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 141:

  You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN

  command:

  RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;

  Which two statements are true regarding the execution of the above command? (Choose two.)

  A. The RMAN parallelizes the backup although the parallelism is not set for a channel.
  B. The backup piece size will be limited to 300 MB.
  C. The operation is accomplished using the default channel available.
  D. Three channels for the tape drive must be configured by setting the parallelism to three.
  B. The backup piece size will be limited to 300 MB.
  C. The operation is accomplished using the default channel available.

• Question 142:

  You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?

  A. The collection level for the AWR should be set to BASIC.
  B. The moving window size must be less than Undo Retention.
  C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.
  D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.
  D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.

• Question 143:

  Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?

  A. NLS_LANG
  B. NLS_COMP
  C. NLS_SORT
  D. None of the above
  D. None of the above

• Question 144:

  What is the name of the file that identifies the set of available locale definitions?

  A. locale.def
  B. lxdef.ora
  C. lx1boot.nlb
  D. lx1boot.ora
  E. lang.def
  C. lx1boot.nlb

• Question 145:

  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 remote database links stored in the XML file that are available to the users of the database.
  B. It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
  C. It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
  D. It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.
  B. It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.

• Question 146:

  You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?

  A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
  B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ;
  C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ;
  D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
  C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ;

• Question 147:

  Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak

  workload. You set up the test RAC database and want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload:

  1) Preprocess the captured workload.

  2) Restart the database in RESTRICTED mode.

  3) Set up the Replay Clients.

  4) Restore the test database to the point when the capture started.

  5) Remap connections.

  Arrange the steps required in the correct sequence to accomplish this task on the test machine.

  A. 1, 4, 5, 3 (2 is not required.)
  B. 1, 4, 3, 5 (2 is not required.)
  C. 1, 2, 4, 5 (3 is not required.)
  D. 2, 1, 5, 3, 4
  E. 1, 2, 4, 5, 3
  A. 1, 4, 5, 3 (2 is not required.)

• Question 148:

  Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?

  A. Username, instance number, session ID
  B. Instance number, username, session ID
  C. Instance number, session ID, username
  D. Username, session ID, instance number
  E. None of the above
  D. Username, session ID, instance number

• Question 149:

  Which backup option defines a user-defined name for a backup?

  A. FORMAT
  B. NAME
  C. TAG
  D. FORMAT U%
  C. TAG

• Question 150:

  What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)

  A. RECOVERY_CATALOG_OWNER
  B. DBA
  C. RESOURCE
  D. SELECT ANY DICTIONARY
  E. CONNECT
  A. RECOVERY_CATALOG_OWNER
  C. RESOURCE