Oracle Oracle Database 1Z0-052 Questions & Answers

• Question 11:

  View the Exhibit and examine the setting for a table.

  

  Which statement is true about the PCTFREE setting for the table?

  A. It sets the minimum percentage of a data block to be reserved to contain chained rows from other

  blocks.

  B. It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.

  C. It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.

  D. It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.

  Correct Answer: B

• Question 12:

  Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)

  A. Undo tablespace

  B. USERS tablespace

  C. SYSAUX tablespace

  D. SYSTEM tablespace

  E. Temporary tablespace

  Correct Answer: CD

• Question 13:

  You executed the following commands in an RMAN session for your database instance that has failures:

  RMAN> LIST FAILURE;

  After some time, you executed the following command in the same session:

  RMAN> ADVISE FAILURE;

  But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of

  the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?

  A. It produces a warning for new failures before advising for CRITICAL and HIGH failures.

  B. It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

  C. It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

  D. It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

  Correct Answer: A

• Question 14:

  Identify the logical structure that will never have more than one data segment created for it.

  A. external table

  B. partitioned table

  C. partitioned index

  D. nonclustered table

  E. global temporary table

  Correct Answer: D

• Question 15:

  View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.

  Which type of index would you select in this scenario?

  Exhibit:

  

  A. Bitmap index

  B. Reverse key index

  C. Normal BTree index

  D. Functionbased index

  Correct Answer: A

• Question 16:

  The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:

  

  Which statement is true after HR issues the REVOKE command?

  A. The command fails because SCOTT still has privileges.

  B. The command succeeds and privileges are revoked from JIM.

  C. The command fails because HR cannot revoke the privileges from JIM.

  D. The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.

  Correct Answer: C

• Question 17:

  Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

  A. An update in a leaf row takes place.

  B. The index becomes invalid after the update.

  C. The leaf block containing the row to be updated is marked as invalid.

  D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

  Correct Answer: D

• Question 18:

  You suspect unauthorized data manipulation language (DML) operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. You also plan to transfer these values to another table for analysis. How would you achieve this?

  A. by using triggers

  B. by using Data Pump

  C. by using external tables

  D. by using anonymous PL/SQL blocks

  Correct Answer: A

• Question 19:

  You execute a command to resize a data file, sales.dbf, of size 200 MB in your database:

  ALTER DATABASE DATAFILE '/remorse/sales.dbf' RESIZE 150M;

  Which statement is true about this command?

  A. The command must be issued in MOUNT state.

  B. The command succeeds only if the data file is offline.

  C. The command must be issued when the database is in the archivelog mode.

  D. The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

  Correct Answer: D

• Question 20:

  You executed the following commands to find the location of the alert log file:

  

  Where is the alert log file stored? (Choose all that apply.)

  A. in the BACKGROUND_DUMP_DEST location; in text format

  B. in the BACKGROUND_DUMP_DEST location; in XML format

  C. in the BACKGROUND_DUMP_DEST location; in both text and XML format

  D. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format

  E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format

  F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format

  Correct Answer: AE