You work with a newly created database. Presently, there is no application load on the database instance. You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.
What action must you take to achieve this?
Answer : D
Because of a logical corruption in your production database, you wanted to perform
Tablespace Point in TimeRecovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPEDview and realized that there are a large number of objects that would be dropped when you start the recoveryby using this method. You want to preserve these objects. Which option must you use to perform
TSPITR andpreserve the object?
Answer : A
View the following SQL statements:
Transaction T1 -
SQL> INSERT INTO hr.regions -
2 VALUES (5,'Pole');
3 COMMIT;
Transaction T2 -
SQL> UPDATE hr.regions -
2 SET region_name='Poles'
3 WHERE region_id = 5;
4 COMMIT;
Transaction T3 -
SQL> UPDATE hr.regions -
2 SET region_name='North and South Poles'
3 WHERE region_id = 5;
You want to back out transaction T2. Which option would you use?
Answer : B
Explanation:
Table 12-2 Flashback TRANSACTION_BACKOUT Options
CASCADE -
Backs out specified transactions and all dependent transactions in a post-order fashion
(that is, children arebacked out before parents are backed out).
Without CASCADE, if any dependent transaction is not specified, an error occurs.
NOCASCADE -
Default. Backs out specified transactions, which are expected to have no dependent transactions. Firstdependent transactions causes an error and appears in
*_FLASHBACK_TXN_REPORT.
NOCASCADE_FORCE -
Backs out specified transactions, ignoring dependent transactions. Server runs undo SQL statements forspecified transactions in reverse order of commit times.If no constraints break and you are satisfied with the result, you can commit the changes; otherwise, you canroll them back.
NONCONFLICT_ONLY -
Backs out changes to nonconflicting rows of the specified transactions. Database remains consistent, buttransaction atomicity is lost.
Which data dictionary view would you query to find the name of the default permanent tablespace of the database?
Answer : E
Explanation: SQL*Plus: Release 10.2.0.1.0 Production on Sat Feb 4 20:31:26 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn / as sysdba -
Connected.
SQL>desc DATABASE_PROPERTIES -
Name Null? Type -
PROPERTY_NAME NOT NULL
VARCHAR2(30)
PROPERTY_VALUE VARCHAR2(4000)
DESCRIPTION VARCHAR2(4000)
SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE
2 FROM DATABASE_PROPERTIES
3WHERE PROPERTY_NAME=DEFAULT_PERMANENT_TABLESPACE;
PROPERTY_NAME PROPERTY_VALUE -
- -
DEFAULT_PERMANENT_TABLESPACE USERS
You issued the following commands to configure settings in RMAN:
RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO Sbt;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;
RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Then you issued the following command to take the backup:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of the above command?
Answer : D
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?
Answer : B
You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes the following command to grant privileges to a new user vpc1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
Answer : A
Examine the following command for RMAN backup:
RMAN> RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE sbt;
ALLOCATE CHANNEL c2 DEVICE TYPE sbt;
ALLOCATE CHANNEL c3 DEVICE TYPE sbt;
BACKUP -
INCREMENTAL LEVEL = 0 -
(DATAFILE 1,4,5 CHANNEL c1)
(DATAFILE 2,3,9 CHANNEL c2)
(DATAFILE 6,7,8 CHANNEL c3);
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
Which statement is true regarding the approach in the command?
Answer : C
Which two statements are true about the duplexing of the backups taken by RMAN?
Answer : B,D
To enable faster incremental backups, you enabled block change tracking for the database.
Which two statements are true about the block change tracking file? (Choose two.)
Answer : C,D
You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November
15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00
AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?
Answer : A
Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?
Answer : C
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)
Exhibit:
Answer : A,C,D
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?
Answer : C
Evaluate the following block of code:
What is the outcome of the above code?
Answer : C