1Z0-052 questions and answers

In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.

What action would you take to achieve this task?

Which two are true about the Fast Recovery Area (FRA)? (Choose two.)

Which three can be used to schedule automated backups of the database? (Choose three.)

To make audit information more productive, the DBA executes the following command before starting an audit operations:

SQL>ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;

Which statement is true regarding the audit record generated when auditing starts after restarting the database?

View the Exhibit1, which shows the options that are selected to create the user SL_REP.

View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.

Which two statements are true regarding this user? (Choose two.)

Exhibit1 (exhibit):

Exhibit2 (exhibit):

Your database is open and the LISTENER listener is running. The new DBA of the system stops the
listener by using the command: LSNRCTL> STOP

What happens to the sessions that are presently connected to the database instance?

Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

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

What function is performed by the System Monitor (SMON) background process in a database instance?

In which situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose all that apply.)

Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

In which situation would you use static database registration for a listener?

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

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

View the Exhibit and examine the setting for a table.

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

Which two are true about space management in tablespaces? (Choose two.)

You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure.

Which configuration will you do to accomplish the task?

View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings, respectively.
Why are advisors not available for the shared pool and the buffer cache?

09 (exhibit):

10 (exhibit):

See the Exhibit:

Identify the component marked with a question mark:

In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache. In the night, the system supports batch jobs that require a higher value to be set for the large pool. You must simultaneously configure the memory components to accommodate the peak requirement.

What would you do to automate this configuration for the memory components with change in mode of working?

Which is true about external tables?

The instance abnormally terminates because of a power outage.

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

Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)

Examine the following statement that is used to modify the primary key constraint on the SALES table:

SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE;

Which three statements are true regarding the above command? (Choose three.)

Which two statements are true regarding listeners? (Choose two.)

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.

Which two statements are true in this scenario? (Choose two.)

database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB. You execute the following command on the PRODDB database server:

$ impdp system/manager directory = DB_DATA

dumpfile = schemas.dat

schemas = hr
flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"

The command fails displaying the following error:

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA- 27037: unable to obtain file status

What would you do to overcome the error?

Which two can be exported by a non-administrative account by using Data Pump? (Choose two.)

You want to install an Oracle 11g database and deploy it on ASM. Your plan is to install both Oracle database and Grid Infrastructure.

Which two are true in this scenario? (Choose two.)

In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.

What is the impact of this setting?

Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)

You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value.

Which is true?

Which two are true about the Archive (ARCn) processes? (Choose two.)

View the Exhibit to examine the error that occurred during the database startup.

You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:

RMAN> REPAIR FAILURE;

Which statement describes the consequence of this command?

Which statements listed below describe the data dictionary views?

1. These are stored in the SYSTEM tablespace

2. These are the based on the virtual tables

3. These are owned by the SYS user
4. These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE

5. The V$FIXED_TABLE view can be queried to list the names of these views

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?

Observe the information in the columns:

Which option has the correct match between the memory areas and their contents?

The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

Which statement is true regarding the archived redo log files?

Which is true about the Database Configuration Assistant (DBCA)?

Which two are true about AWR snapshots? (Choose two.)

Note the following points describing various utilities in Oracle Database 11g: Which point describes the Oracle Data Pump utility?

1. It enables the transfer of data from one database to another

2. It provides a complete solution for the backup, restoration and recovery needs of the entire database

3. It enables the loading of data from an external file into tables of an Oracle Database

4. It provides a tape backup management for the Oracle ecosystem

Identify three situations in which you would NOT be able to drop a tablespace. (Choose three.)

You set the following parameters in the parameter file and restarted the database:

MEMORY_MAX_TARGET=0

MEMORY_TARGET=500M

PGA_AGGREGATE_TARGET=90M

SGA_TARGET=270M

Which two statements are true about these parameters after the database instance is restarted? (Choose two.)