Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 551:

  USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

  A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
  B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace.
  C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
  D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
  E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.
  A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
  B. Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace.
  C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.

• Question 552:

  Which of the following are included in a transportable tablespace set? (Choose all that apply.)

  A. The datafiles that make up a self-contained group of tablespaces required for copy
  B. The system tablespace
  C. An export of the tablespace metadata
  D. The spfile
  E. All of the above
  A. The datafiles that make up a self-contained group of tablespaces required for copy
  C. An export of the tablespace metadata

• Question 553:

  Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

  A. The ADR base keeps all diagnostic information in binary format
  B. SQL*Plus provides the ADRI script, which can be used to work with ADR
  C. The ADR can be used for problem diagnosis only when the database is open
  D. The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null
  E. The ADR can be used for problem diagnosis even when the database instance is down
  F. The ADR base is shared across multiple instances
  E. The ADR can be used for problem diagnosis even when the database instance is down
  F. The ADR base is shared across multiple instances

• Question 554:

  You executed the following command:

  RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';

  Which statement regarding the above command is correct?

  A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.
  B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.
  C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.
  D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails.
  C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN.

• Question 555:

  Given below are RMAN commands to enable backup optimization and set the retention policy:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

  RMAN> CONFIGURE BACKUP OPTIMIZATION ON;

  RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

  The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday.

  View the Exhibit to examine the operations performed by using RMAN.

  Which two statements are true about the backup of the USERS tablespace? (Choose two.)

  Exhibit:

  

  A. It will be backed up as a part of database backup on Friday.
  B. It will be backed up as a part of database backup on Tuesday.
  C. It will not be backed up as a part of database backup on Wednesday.
  D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.
  B. It will be backed up as a part of database backup on Tuesday.
  D. The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

• Question 556:

  What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

  A. The number of DBWR processes increases
  B. The number of ASMB processes increases
  C. The number of DBWR_TO_SLAVES increases
  D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead
  D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O overhead

• Question 557:

  Flashback Database relies on which technologies to recover to a point in time?

  A. Flashback Data Archive
  B. Flashback logs in the flash recovery area
  C. FlashbUndo tablespace
  D. RMAN command line
  E. None of the above
  B. Flashback logs in the flash recovery area

• Question 558:

  Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

  A. Database must be running in archivelog mode.
  B. Automatic undo management must be enabled.
  C. Undo retention guarantee must be enabled.
  D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
  B. Automatic undo management must be enabled.
  D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

• Question 559:

  Which three statements are true about persistent configuration? (Choose three.)

  A. A user cannot set privileges on the persistent lightweight jobs
  B. Persistent lightweight jobs generate a large amount of metadata
  C. It is possible to create fully self-contained persistent lightweight jobs
  D. The use of a template is mandatory to create persistent lightweight jobs
  E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
  A. A user cannot set privileges on the persistent lightweight jobs
  D. The use of a template is mandatory to create persistent lightweight jobs
  E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

• Question 560:

  View the Exhibit.

  Examine the following command that is executed for the TRANSPORT table in the SH schema:

  SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe', '(country_id, _state_province)') FROM dual;

  Which statement describes the significance of this command?

  Exhibit:

  

  A. It collects statistics into the pending area in the data dictionary.
  B. It creates a virtual hidden column in the CUSTOMERS_OBE table.
  C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
  D. It creates a histogram to hold skewed information about the data in the columns.
  B. It creates a virtual hidden column in the CUSTOMERS_OBE table.