OCP Oracle 12C Advanced Administration(1Z0-063) Set 1

Which of the following is true with respect to multitenant backups?


Options are :

  • You cannot use Oracle Data Pump if the source database is a PDB.
  • Oracle Data Pump can export from only a single PDB at a time.
  • All of the above are false statements.
  • You cannot use RMAN to restore a PDB.
  • You cannot use RMAN to back up an entire CDB database.

Answer : Oracle Data Pump can export from only a single PDB at a time.

1Z0-519 Oracle E-Business Suite R12.1 Inventory Essentials Set 1

Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name, and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list?


Options are :

  • Flashback Drop
  • Flashback Transaction Query
  • Flashback Version Query
  • Flashback Query
  • Flashback Table

Answer : Flashback Transaction Query

What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?


Options are :

  • CROSSCHECK
  • LIST BACKUP
  • YCONFIRM
  • RESYNC
  • BACKUP VALIDATE

Answer : CROSSCHECK

You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?


Options are :

  • BACKUP DATABASE PLUS ARCHIVELOG DURATION '10:00';
  • BACKUP DATABASE PLUS ARCHIVELOG TIMEOUT 10:00;
  • BACKUP DATABASE PLUS ARCHIVELOG UNTIL TIME '10:00';
  • BACKUP DATABASE PLUS ARCHIVELOG;
  • BACKUP DATABASE PLUS ARCHIVELOG TIMEOUT '10:00';

Answer : BACKUP DATABASE PLUS ARCHIVELOG DURATION '10:00';

1Z0-497 Oracle Database 12c Essentials Certification Exam Set 4

Which of the following statements are true regarding the Recycle Bin? 


Options are :

  • The Recycle Bin stores the results of a Flashback Drop operation.
  • None of the above
  • The Recycle Bin is a physical storage area for dropped objects.
  • The Recycle Bin is a logical container for dropped objects.

Answer : The Recycle Bin is a logical container for dropped objects.

Why would you run the DELETE OBSOLETE command? 


Options are :

  • To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
  • To remove missing backup set pieces physically from disk
  • To remove metadata related to backup set pieces in the control file and the recovery catalog
  • To remove old versions of RMAN backups

Answer : To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets

Which command is used to begin a tablespace point-in-time recovery?


Options are :

  • TABLESPACE RECOVER
  • RECOVER TABLESPACE
  • RECOVER TO TIME
  • RESTORE TABLESPACE
  • RECOVER DATAFILE

Answer : RECOVER TABLESPACE

1Z0-969 Oracle Payroll Cloud 2017 Implementation Essentials Set 2

What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?


Options are :

  • CHECK_TSPITR
  • PITR_TS_CHECK
  • TS_PITR_CHECK
  • TS_CHECK
  • TPITR_CHECK

Answer : TS_PITR_CHECK

What does it mean if a backup is expired?


Options are :

  • The backup set contains one or more tablespaces no longer in the database.
  • The backup set is from a previous version of RMAN and was not upgraded.
  • The backup set contains one or more missing backup set pieces.
  • The backup set has one or more invalid blocks in it and is not usable for recovery.
  • The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.

Answer : The backup set contains one or more missing backup set pieces.

Which command would you use to determine what database backups are currently available for restore?


Options are :

  • LIST BACKUP OF DATABASE;
  • REPORT BACKUP OF DATABASE;
  • LIST DATABASE BACKUP;
  • LIST SUMMARY BACKUP;
  • REPORT DATABASE BACKUP;

Answer : LIST BACKUP OF DATABASE;

1Z0-516 Oracle EBS R12.1 General Ledger Essentials Exam Set 3

If a backup set is expired, what can you do to correct the problem?


Options are :

  • Nothing. The backup set piece is lost forever.
  • Run the CROSSCHECK command to correct the location for the backup set piece contained in the metadata.
  • Change the retention criteria.
  • Make the lost backup set pieces available to RMAN again and rerun the CROSSCHECK command.
  • Call Oracle Support. Their assistance is required.

Answer : Make the lost backup set pieces available to RMAN again and rerun the CROSSCHECK command.

True or false: RMAN supports duplication of only the entire CDB to another CDB.


Options are :

  • False
  • True

Answer : False

Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?


Options are :

  • Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert duplicate target database to neworcl from active database nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
  • Set oracle_sid=orcl rman target=sys/robert auxname=sys/[email protected] duplicate target database nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
  • Set oracle_sid=orcl rman target=sys/robert auxname=sys/[email protected] create duplicate target database to neworcl from active database nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
  • Set oracle_sid=orcl rman target=sys/robert auxname=sys/[email protected] duplicate target database to neworcl from active database nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';
  • Set oracle_sid=orcl rman target=sys/robert auxname=sys/[email protected] duplicate target database to neworcl nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

Answer : Set oracle_sid=orcl rman target=sys/robert auxname=sys/[email protected] duplicate target database to neworcl from active database nofilenamecheck spfile set control_files 'c:\oracle\oradata\neworcl\control01.ctl', 'c:\oracle\oradata\neworcl\control02.ctl' set db_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl' set log_file_name_convert 'c:\oracle\oradata\orcl','c:\oracle\oradata\neworcl';

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 1

A user named Arren is executing this query:

select table_name, operation, undo_sql
from
flashback_transaction_query t,
(select versions_xid as xid
from employees versions between scn minvalue
and maxvalue
where employee_id = 123) e
where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error.
Since the user owns the employees table, you know that it is not the problem. Which of the following SQL statements will correct this problem?


Options are :

  • GRANT SELECT ANY TRANSACTION TO ARREN;
  • GRANT SELECT ANY VIEW TO ARREN;
  • GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;
  • GRANT FLASHBACK TO ARREN;
  • GRANT SELECT_ANY_TRANSACTION TO ARREN;

Answer : GRANT SELECT ANY TRANSACTION TO ARREN;

Which of the following Oracle features utilize the undo tablespace?


Options are :

  • Flashback Query
  • Recycle Bin
  • Flashback Drop
  • Flashback Database

Answer : Flashback Query

You run the following commands:
RMAN> list expired backup;
RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the LIST EXPIRED BACKUP command?


Options are :

  • They will be deleted immediately since they are not in the fast recovery area.
  • You will need to manually remove the physical files listed in the output of the commands.
  • They will be renamed.
  • Nothing will happen to them. The backup set pieces do not exist.
  • They will become hidden files and removed 10 days later.

Answer : Nothing will happen to them. The backup set pieces do not exist.

1Z0-969 Oracle Payroll Cloud 2017 Implementation Essentials Set 3

When performing a database duplication, which DUPLICATE DATABASE parameter would you set to ensure that the online redo logs are created in the correct location?


Options are :

  • LOG_FILE_NAME_CONVERT
  • CONVERT_LOG_FILE_NAME
  • REDO_LOG_FILE_NAME_CONVERT
  • LOGFILE_CONVERT_DIRECTORY
  • FILE_NAME_CONVERT_LOG

Answer : LOG_FILE_NAME_CONVERT

How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database ;


Options are :

  • The command will generate an error.
  • 2 days
  • 2 hours
  • This backup is not constrained by any time limitation.
  • 2 minutes

Answer : 2 hours

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have an automated cross-check script that also does a DELETE EXPIRED BACKUPSET com- mand. You have restored all the backup set pieces from tape. What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again?


Options are :

  • REGISTER DATABASE
  • RECOVER CATALOG
  • LOAD BACKUPSET
  • SYNCH METADATA
  • CATALOG START WITH

Answer : CATALOG START WITH

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 2

How many database instances are used during a database-duplication process?


Options are :

  • one
  • four
  • five
  • two
  • three

Answer : two

Which command would correctly start a TSPITR of the USERS tablespace?


Options are :

  • recover tablespace users until time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary';
  • recover tablespace users except time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary';
  • recover tablespace users time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary';
  • recover tablespace users to point-in-time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary';
  • recover tablespace users until time '10/06/2013:22:42:00' auxiliary 'c:\oracle\auxiliary';

Answer : recover tablespace users until time '10/06/2013:22:42:00' auxiliary destination 'c:\oracle\auxiliary';

AUM has been retaining about 15 minutes’ worth of undo. You want to double the retention period but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000 . However, AUM still retains only about 15 minutes’ worth of undo. What is the problem? 


Options are :

  • You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
  • You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.
  • The undo tablespace is not set to autoextend.
  • You need to increase the size of the undo tablespace.

Answer : The undo tablespace is not set to autoextend.

1Z0-516 Oracle EBS R12 General Ledger Essentials Exam Set 1

You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?


Options are :

  • RESTORE CATALOG
  • REPLICATE CATALOG
  • RESYNC CATALOG
  • SYNCH CATALOG
  • UPDATE CATALOG

Answer : RESYNC CATALOG

What command is used to reset a database to a previous incarnation?


Options are :

  • RESET INCARNATION
  • RESET DATABASE TO INCARNATION
  • RESET DATABASE INCARNATION NUMBER
  • RESET DATABASE INCARNATION
  • INCARNATION RESET

Answer : RESET DATABASE TO INCARNATION

When you’re performing active database duplication, a backup of what kind is required?


Options are :

  • A current RMAN backup-set backup is required.
  • A manual backup is required.
  • A duplicate preparatory backup is required.
  • An RMAN image backup is required.
  • No backup is required.

Answer : No backup is required.

1Z0-516 Oracle EBS R12.1 General Ledger Essentials Exam Set 8

If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated?


Options are :

  • The next time you connect to the recovery catalog and the target database with RMAN
  • Connecting to the recovery catalog and issuing the RESYNC ALL DATABASES command
  • The next time you back up the database when you are also connected to the recovery catalog and the target database
  • The next time you connect RMAN to just the recovery catalog

Answer : The next time you back up the database when you are also connected to the recovery catalog and the target database

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 9

What is the end result of these commands if they are successful?
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
Backup database tag='gold_copy' plus archivelog
tag='gold_copy' delete input;
Backup database tag='silver_copy' plus archivelog
tag='silver_copy' delete input;


Options are :

  • Attempting to restore gold_copy will fail.
  • Attempting to restore silver_copy will fail.
  • Both backups will be available for restore without question.
  • You will not be able to restore either gold_copy or silver_copy.
  • Attempting to restore gold_copy may or may not succeed.

Answer : Attempting to restore gold_copy may or may not succeed.

True or false: RMAN offers the equivalent of the SQL command ALTER DATABASE BACKUP CONTROLFILE TO TRACE.


Options are :

  • false
  • true

Answer : false

What is the purpose of the RMAN recovery catalog?


Options are :

  • It provides a convenient, optional, repository of backup- and recovery-related metadata.
  • It provides a means of storing all RMAN backup sets physically in an Oracle Database server.
  • None of the above
  • It must be used because all RMAN-related backup and recovery metadata information is contained in it.

Answer : It provides a convenient, optional, repository of backup- and recovery-related metadata.

1Z0-409 Oracle Linux Fundamentals Practice Test Set 2

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?


Options are :

  • Issue the GRANT command from the SYS user (or equivalent) of the recovery catalog database.
  • Issue the GRANT command from the recovery catalog–owning schema user account in the recovery catalog.
  • Issue the GRANT command from RMAN when connected to the target database.
  • Issue the GRANT command from the SYS user (or equivalent) of the target database.
  • Issue the GRANT command from RMAN when connected to the recovery catalog– owning schema.

Answer : Issue the GRANT command from RMAN when connected to the recovery catalog– owning schema.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions