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

The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION
enabled.
TBS1 and TBS2 are the only user-defined tablespaces in ORCL.
USER1.EMP is a table in TBS1.
Examine these commands:

From which files are modified blocks backed up?

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

Which structure can span multiple data files?

Observe the information in the columns:

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

When would you use memory advisors?

You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed:
Checking available swap space requirements ...
Expected result: 1512MB
Actual Result: 1018MB
Check complete. The overall result of this check is: Failed <<<< Problem: The system does not have the required swap space.
What happens to the installation in this situation?

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

Which two events always cause the LGWR to write? (Choose two.)

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

You want to access employee details contained in flat files as part of the EMPLOYEE table.
You plan to add a new column to the EMPLOYEE table to achieve this.
Which data types would you use for the new column?

You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.
Given below are the steps to accomplish the task in random order:
1 . Shut down the instance.
2 . Execute the ALTER DATABASE ARCHIVELOG command.
3 . Start up the instance and mount the database.
4 . Set the DB_RECOVERY_FILE_DEST initialization parameter to
$ ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?