http://https://www.lead1pass.com/Oracle/1Z0-052-practice-exam-dumps.html (285 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 8
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.
A. 2, 1, 4, 3, 5, 6
B. 1, 4, 3, 2, 6, 5
C. 1, 4, 2, 6, 3, 5
D. 3, 2, 1, 4, 5, 6
Answer: A
Explanation/Reference:
Explanation:
How to change Flash Recovery Area to a new location?
If you need to move the Flash Recovery Area of your database to a new location, invoke SQL*Plus to change the DB_RECOVERY_FILE_DEST initialization parameter.
For example:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='+disk1' SCOPE=BOTH SID='*';
After you change this parameter, all new Flash Recovery Area files will be created in the new location.
The permanent files (control files and online redolog files), flashback logs and transient files can be left in the old Flash Recovery Area location. The database will delete the transient files from the old Flash Recovery Area location as they become eligible for deletion.
For the FLASHBACK logfiles to be able to to pick up the new 'db_recovery_file_dest' location, the flashback option needs to be toggled off and on.
This can be done like this:
- Shutdown the Database
- Startup mount the Database:
SQL> startup mount;
- Toggle the Flashback off:
SQL> alter database flashback off;
- Toggle the Flashback on:
SQL> alter database flashback on;
- Open the Database:
SQL> alter database open;
If you need to actually move your current permanent files, transient files, to the new Flash Recovery Area, then follow the following steps:
1) To move the existing backupsets and archived redo log files, use the following command:
RMAN> BACKUP AS COPY ARCHIVELOG ALL DELETE INPUT;
RMAN> BACKUP DEVICE TYPE DISK BACKUPSET ALL DELETE INPUT;

NEW QUESTION NO: 9
Which three operations require undo data? (Choose three.)
A. Committing a transaction
B. Flashing back a transaction
C. Recovering a failed transaction
D. Running a read-consistent query
E. Changing a tablespace status from READ ONLY to READ WRITE
Answer: B,C,D
Explanation/Reference:
Explanation:
Module 10 - Managing Undo Data Objectives
These notes teach you about managing undo data including the method used to implement automatic undo data management. You will also learn to create and modify undo segments and how to query the data dictionary to retrieve undo segment information.
* Beginning with Release 11 g, for a default installation, Oracle Database automatically manages undo.
There is typically no need for DBA intervention.
* If your installation uses Oracle Flashback operations, you may need to perform some undo management tasks to ensure the success of these operations.
Undo Purpose
Undo records are used to:
* Roll back transactions when a ROLLBACK statement is issued
* Recover the database
* Provide read consistency
* Analyze data as of an earlier point in time by using Oracle Flashback Query
* Recover from logical corruptions using Oracle Flashback features

NEW QUESTION NO: 10
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?
A. The extents in the undo tablespace retain data until the next full database backup
B. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
C. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down
D. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 11
You want to configure and schedule offline database backups to run automatically.
Which tool or utility would you use to achieve this?
A. The XML script
B. The PL/SQL script
C. The DBMS_SCHEDULER package
D. Enterprise Manager to schedule the backup
Answer: D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 12
User SCOTTexecutes the following command on the EMPtable but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:

SCOTThas opened another session to work with the database instance.
Which three operations would wait when issued in SCOTT'ssecond session? (Choose three.)
A. LOCK TABLE emp IN SHARE MODE;
B. LOCK TABLE emp IN EXCLUSIVE MODE;
C. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'
D. INSERT INTO emp(empno,ename) VALUES (1289,'Harry');
E. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;
Answer: A,B,E
Explanation/Reference:
Explanation:

NEW QUESTION NO: 13
|View the Exhibit to observe the roles assigned to the SL_REPuser.

Which statement is true about the assignment of the SELECT_CATALOG_ROLErole to the SL_REPuser?
A. The user must enable the role explicitly
B. The user can grant the role to other users
C. The user cannot user the role until the DBA enables it explicitly
D. The user can start using the role immediately without any changes
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 14
Which three statements are correct about temporary tables? (Choose three.)
A. Indexes and views can be created on temporary tables.
B. Both the data and the structure of temporary tables can be exported.
C. Temporary tables are always created in a user's temporary tablespace.
D. The data inserted into a temporary table in a session is available to other sessions.
E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.
Answer: A,C,E
Explanation/Reference:
Explanation:

NEW QUESTION NO: 15
Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?
A. Run the root.sh script.
B. Create the oraInst.loc file.
C. Create the tnsnames.ora file.
D. Run the oraInstRoot.sh script.
Answer: B
Explanation/Reference:
Explanation:


NEW QUESTION NO: 16
View the Exhibit and examine the attributes of an undo tablespace.
In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
Exhibit:

What could be the reason for this error?
A. The query is unable to get a read-consistent image.
B. There is not enough space in Flash Recovery Area.
C. There is not enough free space in the flashback archive.
D. The query is unable to place data blocks in undo tablespace.
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 17
You are installing Oracle Database 11g on a machine. When you run the installer, the Oracle Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed:

What happens to the installation in this situation?
A. It can be continued.
B. It resizes the swap space automatically when you proceed further.
C. It can be continued, but the instance cannot be started without increasing the swap space.
D. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.
Answer: A
Explanation/Reference:
Explanation:

NEW QUESTION NO: 18
In your production database, data manipulation language (DML) operations are executed on the SALES table. You have noticed some dubious values in the SALEStable 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?
A. Apply fine-grained auditing.
B. Implement value-based auditing.
C. Impose standard database auditing to audit object privileges.
D. Impose standard database auditing to audit SQL statements.
Answer: B
Explanation/Reference:
Explanation: