Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 141:

  Note the following structures in your database server:

  1.

  Extents

  2.

  OS Blocks

  3.

  Tablespace

  4.

  Segments

  5.

  Oracle Data Block

  Which option has the correct arrangement of these structures from the smallest to the largest?

  A. 2, 5, 1, 4, 3

  B. 1, 2, 3, 4, 5

  C. 5, 2, 1, 3, 4

  D. 2, 1, 5, 4, 3

  Correct Answer: A

• Question 142:

  Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

  A. Data Files

  B. Control Files

  C. Parameter Files

  D. Online Redo Log Files

  E. Server Parameter File

  Correct Answer: BE

• Question 143:

  Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

  A. You can load data into multiple tables during the same load session

  B. You can load data from multiple files to a table during the same load session

  C. You cannot perform selective data loading based on the values available in the records

  D. You can use an export file generated by the EXPDP utility as an input data file to load the data

  E. You can load data only if the input file is available on the disk and tape but not a named pipes

  Correct Answer: AB

• Question 144:

  View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:

  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';

  Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the

  TRANS table:

  SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));

  What would happen in this scenario?

  Exhibit:

  

  A. The ALTER TABLE command modifies the column successfully

  B. The DDL operation gets higher priority and transaction for user A is rolled back

  C. The ALETER TABLE command waits indefinitely until user A ends the transaction

  D. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

  Correct Answer: D

• Question 145:

  You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

  A. Lock statistics for the tables.

  B. Change STALE_PERCENT to zero for the tables.

  C. Set the TIMED_STATISTICS parameter to TRUE.

  D. Set the STATISTICS_LEVEL parameter to BASIC.

  E. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

  Correct Answer: A

• Question 146:

  Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.

  What would be your next step to improve performance?

  A. Run the SQL Access Advisor

  B. Run the memory Advisor for the SGA

  C. Run the memory Advisor for the PGA

  D. Run the memory advisor for the shared pool

  E. Run the memory advisor for the buffer cache

  Correct Answer: D

• Question 147:

  You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.

  View the Exhibit to examine the commands used to create tables.

  Which action would you take to delay the referential integrity checking until the end of the transaction?

  Exhibit:

  

  A. Set the constraint to deferred before starting the transaction

  B. Alter the constraint to NOVALIDATE state before starting the transaction

  C. Enable the resumable mode for the session before starting the transaction

  D. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

  Correct Answer: A

• Question 148:

  Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

  A. The database files are corrupted when the database is open

  B. The user has dropped an important table that needs to be recovered

  C. The archived redo log files are missing for which the backup is not available

  D. The database is not opening because the required database files are missing

  Correct Answer: AD

• Question 149:

  You have an ORDERS table with the following structure: The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future.

  

  Which method would serve the purpose?

  A. Modify the column using the ALTER TABLE ... MODIFY command.

  B. Add a UNIQUE constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

  C. Add a NOT NULL constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

  D. Add a PRIMARY KEY constraint to the column using the ALTER TABLE ... ADD CONSTRAINT command.

  Correct Answer: A

• Question 150:

  Examine the values for the following initialization parameters:

  FAST_START_MTTR_TARGET=0

  LOG_CHECKPOINT_INTERVAL=0

  Which two will be the implications of these values in your database? (Choose two.)

  A. The SGA advisor will be disabled

  B. The MTTR advisor will be disabled

  C. Automatic checkpoint tuning will be disabled

  D. Checkpoint information will not be written to the alert log file

  Correct Answer: BC