Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 521:

  View the Exhibit.

  You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File

  System option as the storage mechanism.

  What would be the result of choosing this option?

  Exhibit:

  

  A. Disk mirroring and striping would be done automatically

  B. The database files would be managed by the operating system's file system

  C. DBCA would not save the database files by using Optimal File Architecture (OFA)

  D. The data files are automatically spread across all available storage devices to optimize performance and resource utilization

  Correct Answer: B

• Question 522:

  What is the proper procedure to recover a lost tempfile?

  A. Restore the backup copy of the tempfile from the backup media.

  B. Re-create the tempfile with the create tempfile command.

  C. Copy an existing tempfile from another database.

  D. Re-create the tempfile with the create tablespace command.

  E. Re-create the tempfile with the alter tablespace command.

  Correct Answer: E

  ALTER TABLESPACE ADD TEMPFILE ; ALTER TABLESPACE TEMPFILE OFFLINE; ALTER TABLESPACE TEMPFILE <> ONLINE;

• Question 523:

  Which two statements are true about the compressed backups in RMAN? (Choose two.)

  A. Compressed backups can only be taken on the tape drives.

  B. The binary compression creates some performance overhead during backup operation.

  C. The ZLIB compression algorithm can be used only if the COMPATIBLE initialization parameter is set to 11.1.0.

  D. The media manager compression for the tape drive should be enabled for taking compressed backups on the tape.

  Correct Answer: BD

• Question 524:

  You opened the encryption wallet and then issued the following command:

  SQL>CREATE TABLESPACE securespace

  DATAFILE '/home/user/oradata/secure01.dbf'

  SIZE 150M

  ENCRYPTION USING '3DES168'

  DEFAULT STORAGE(ENCRYPT);

  Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.

  What is the outcome?

  A. It creates the table and encrypts the data in it.

  B. It generates an error because the wallet is closed.

  C. It creates the table but does not encrypt the data in it.

  D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

  Correct Answer: B

• Question 525:

  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. 2 and 3

  B. 1 and 3

  C. 1 and 2

  D. 1, 2 and 3

  Correct Answer: B

• Question 526:

  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.

  Correct Answer: ABC

• Question 527:

  For which of the following can you use Segment Shrink? (Choose all that apply.)

  A. Heap tables

  B. Tables with function-based indexes

  C. Indexes

  D. Partitions and subpartitions

  E. None of the above

  Correct Answer: ACD

• Question 528:

  When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

  A. INCLUDING DEPENDENCIES

  B. INCLUDING DEPENDENCIES CASCADE

  C. COMPACT

  D. CASCADE

  E. None of the above

  Correct Answer: D

• Question 529:

  Which of the following supplied functions is used to identify external tables, directories, and BFILES?

  A. DBMS_TDB.CHECK_DIRECTORIES

  B. DBMS_TDB.CHECK_EXTERNAL

  C. DBMS_TDB.CHECK_BFILE

  D. DBMS_TDB.CHECK_EXT

  Correct Answer: B

• Question 530:

  Which of the following options describes Segment Shrink?

  A. Reclaims space above and below the high-water mark without using additional space

  B. Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation

  C. Deallocates space above the high-water mark that is currently not in use

  D. None of the above

  Correct Answer: A