Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 531:

  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

  Correct Answer: D

• Question 532:

  You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in / etc. Which two statements are true regarding this oranfstab file? (Choose two.)

  A. Its entries are specific to a single database.

  B. It contains file systems that have been mounted by Direct NFS.

  C. It is globally available to all Oracle 11g databases on the machine.

  D. It contains file systems that have been mounted by the kernel NFS system.

  Correct Answer: CD

• Question 533:

  To enable resumable space allocation for the instance, which of the following initialization parameters you set to a nonzero value?

  A. RESUMABLE_SPACE_TIME

  B. RESUMABLE_SPACE

  C. RESUMABLE_TIME

  D. RESUMABLE_TIMEOUT

  E. TIME_RESUMABLE

  Correct Answer: D

• Question 534:

  ENCRYPT_TS is an encrypted tablespace that contains tables with data.

  Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  A. The data is decrypted during SORT and JOIN operations.

  B. The data remains encrypted when it is read into memory.

  C. The data remains encrypted when it is stored in the redo logs.

  D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

  Correct Answer: C

• Question 535:

  You issued the following command on the temporary tablespace LMTEMP in your database: SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M;

  Which requirement must be fulfilled for this command to succeed?

  A. The tablespace must be locally managed.

  B. The tablespace must have only one temp file.

  C. The tablespace must be made nondefault and offline.

  D. The tablespace can remain as the default but must have no active sort operations.

  Correct Answer: A

• Question 536:

  Evaluate the following command:

  SQL> CREATE TABLE design_data (id NUMBER,

  doc CLOB)

  LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);

  Which statement is true regarding the above command?

  A. The LOB values are automatically compressed.

  B. The LOB values are cached by default in the buffer cache.

  C. The LOB values are automatically stored in encrypted mode.

  D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

  Correct Answer: D

  DEDUPLICATE or KEEP_DUPLICATES (Link)

  The option DEDUPLICATE enables you to specify that LOB data which is identical in two or more rows in a LOB column should share the same data blocks. The database combines LOBs with identical content into a single copy, reducing

  storage and simplifying storage management.

  The opposite of this option is KEEP_DUPLICATES.

• Question 537:

  You want to enable resumable space allocation at the instance level.

  Which two actions would enable resumable space allocation at the instance level? (Choose two.)

  A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

  B. issuing the ALTER SESSION ENABLE RESUMABLE; statement

  C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

  D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

  Correct Answer: CD

• Question 538:

  You want to disable resumable space allocation for all sessions.

  Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?

  A. 0

  B. 10

  C. 100

  D. NULL

  Correct Answer: A

• Question 539:

  Which statement about the enabling of table compression in Oracle Database 11g is true?

  A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.

  B. Compression can be enabled only at the table level for both direct loads and conventional DML.

  C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.

  D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

  Correct Answer: D

• Question 540:

  Which dependent object will get invalidated even if it is not affected by the table redefinition?

  A. packages

  B. triggers

  C. synonyms

  D. views

  Correct Answer: B

  Results of the Redefinition Process

  The following are the end results of the redefinition process:

  The original table is redefined with the columns, indexes, constraints, grants, triggers, and statistics of the interim table.

  Dependent objects that were registered, either explicitly using REGISTER_DEPENDENT_OBJECT or implicitly using COPY_TABLE_DEPENDENTS, are renamed automatically so that dependent object names on the redefined table are the

  same as before redefinition.

  Note:

  If no registration is done or no automatic copying is done, then you must manually rename the dependent objects.

  The referential constraints involving the interim table now involve the redefined table and are enabled.

  Any indexes, triggers, materialized view logs, grants, and constraints defined on the original table (prior to redefinition) are transferred to the interim table and are dropped when the user drops the interim table. Any referential constraints

  involving the original table before the redefinition now involve the interim table and are disabled.

  Some PL/SQL objects, views, synonyms, and other table-dependent objects may become invalidated. Only those objects that depend on elements of the table that were changed are invalidated. For example, if a PL/SQL procedure queries

  only columns of the redefined table that were unchanged by the redefinition, the procedure remains valid. See "Managing Object Dependencies" for more information about schema object dependencies.