Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion

Which two statements are true about setting the FAST_START_MTTR_TARGET
initialization parameter to a nonzero value? (Choose two.)

You want to configure and schedule offline database backups to run automatically.
Which tool or utility would you use to achieve this?

View the Exhibit and examine the setting for a table.

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

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?

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:

In your database, the current status of a PL/SQL procedure has become INVALID. Which action would fix the problem and make the PL/SQL procedure usable?

Which three statements are correct about temporary tables? (Choose three.)

Which is true about external tables?

You have issued a SHUTDOWN ABORT command to bring down 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 opened.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data file headers 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?

Which three are true about dynamic performance views? (Choose three.)

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?