Abreast of the times Oracle 1Z0-052 pdf

Q1. Examine the commands executed in the following sequence:

Which statement is true about the above commands?

A. The commands execute successfully.

B. Command 6 produces an error because of circular role grant.

C. Command 5 produces an error because a role cannot be granted to another role.

D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.

E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

View Answer

Q2. Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)

A. All AWR tables belong to the SYSTEM schema

B. The AWR contains systemwide tracing and logging information

C. The snapshots collected by the AWR are accessible through data dictionary views

D. The snapshots collected by the AWR are used by self-tuning components in the database

View Answer

Q3. 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

View Answer

Q4. You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:

1. SGA is allocated.

2. Control file is read.

3. Redo log files are read.

4. Instance recovery is started.

5. Background processes are started.

6. Data files are checked for consistency.

7. Server parameter file or the initialization parameter file is read.

Which option has the correct order in which these steps occur?

A. 7, 1, 5, 2, 3, 6, 4

B. 1, 5, 7, 2, 3, 6; step 4 is not required

C. 7, 1, 5, 2, 3, 6 step 4 is not required

D. 1, 2, 3, 5, 6, 4; step 7 is not required

View Answer

Q5. You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.

Which action would help to use the previous set of statistics on the objects?

A. Restore statistics from statistics history.

B. Reduce the optimizer statistics retention period by 2 days.

C. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.

D. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.

View Answer

Q6. Which statement is true about the Manageability Monitor (MMON) background process?

A. It transfers statistics from memory to disk at regular intervals.

B. It coordinates the rebalance activity for disk groups when ASM is used.

C. It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance.

D. It performs dynamic memory management when Automatic Shared Memory Management is enabled for the database instance.

View Answer

Q7. The instance abnormally terminates because of a power outage.

Which statement is true about redo log files during instance recovery?

A. Inactive and current redo log files are required to accomplish recovery

B. Online and archived redo files are required to accomplish instance recovery

C. All redo log entries after the last checkpoint are applied from redo log files to data files

D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

View Answer

Q8. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?

A. Use the external table population.

B. Use the Oracle Data Pump export and import utility.

C. Use the conventional path data load of the SQL*Loader utility.

D. Use the INSERT INTO...SELECT command to load the data.

View Answer

Q9. Identify two situations in which the block header grows in a data block. (Choose two.)

A. When row directories need more row entries

B. When there is row migration in the data block

C. When there is an increase in the PCTFREE value for the data block

D. When more transaction slots are required than are initially configured

View Answer

Q10. Automatic Shared Memory Management (ASMM) has been enabled for your database instance.

The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true in this scenario?

A. The minimum memory size for the database buffer cache is set to 100 MB.

B. The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.

C. The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

D. The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.

View Answer