Infosys Certified Oracle 12c Administration Professional
Practice with real exam-pattern questions for Infosys Certified Oracle 12c Administration Professional. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified Oracle 12c Administration Professional practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Oracle 12c Administration Professional certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
As a DBA, you are working on the container database MEDIPROC database, which is configured in archivelog mode. No backups were available on the database. You connected to RMAN and executed the following commands in the given order.
$ export ORACLE_SID=MEDIPROC
$ rman target /
RMAN > BACKUP INCREMENTAL LEVEL=1 DATABASE;
RMAN > BACKUP INCREMENTAL LEVEL=0 DATABASE;
Which of the following statement(s) is/are TRUE with respect to the backups taken?
- ✓
Level 1 database backup cannot be performed even though level 0 database backup has not been performed
Correct - B
Both the backups are performed successfully
- C
As cumulative or differential keyword is not given, the backup statements will not execute successfully
- D
After performing level 1 backup, level 0 backup cannot be performed
- ✓
- Question 2
You as a DBA, planned to take the backup of PDB_INF pluggable database, of the INFY container database.
Which of the following command(s) is/are TRUE to perform the above activity? [ Choose 2 CORRECT options]
- ✓
$ export ORACLE_SID=INFY
$ rman
RMAN> CONNECT TARGET
RMAN> BACKUP PLUGGABLE DATABASE PDB_INF;
Correct - B
$ export ORACLE_SID=PDB_INF
$ rman
RMAN> CONNECT TARGET
RMAN> BACKUP DATABASE;
- C
$ export ORACLE_SID=INFY
$ rman TARGET /
RMAN> BACKUP PLUGGABLE DATABASE PDB_INF;
- D
$ export ORACLE_SID=PDB_INF
$ rman TARGET /
RMAN> BACKUP DATABASE;
- ✓
- Question 3
You are managing INFY container database, as a DBA. As part of the maintenance activity, you have planned to take the backup of root container of INFY database.
Which of the following statements is/are TRUE to perform above activity? [ Choose 2 CORRECT options]
- ✓
$ export ORACLE_SID=INFY
$ rman target sys/******
RMAN> BACKUP DATABASE ROOT
Correct - B
$ export ORACLE_SID=INFY
$ rman target sys/******
RMAN> BACKUP CONTAINER DATABASE
- C
$ export ORACLE_SID=INFY
$ rman target /
RMAN> BACKUP CONTAINER DATABASE
- D
$ export ORACLE_SID=INFY
$ rman target /
RMAN> BACKUP DATABASE ROOT
- ✓
- Question 4
As a DBA,you are managing the container database CDBTEST along with the two pluggable databases PDB_DATA and PDB_CAT. As part of the maintenance activity, you are performing the backup of the database. Which are all the files will be backed up after executing the following commands ?
$ export ORACLE_SID=CDBTEST
$ rman TARGET /
RMAN> BACKUP DATABASE;
-----------------------------------------------
(i)Datafiles of root container
(ii)Datafiles of both the pluggable database PDB_DATA and PDB_CAT
(iii)Datafiles of the pdbseed pluggable database
(iv)Control file and server parameter file
- ✓
Only (i) and (ii)
Correct - B
Only (i) and (iii)
- C
All (i), (ii), (iii) and (iv)
- D
Only (i) and (iv)
- ✓
- Question 5
As a DBA, you need to perform control file backup of INFY database. Which of the following commands will be used to take backup of the control file?
(i) $ export ORACLE_SID=INFY
$ rman target /
RMAN > BACKUP CURRENT CONTROLFILE;
(ii) $ export ORACLE_SID=INFY
$ rman target /
RMAN > BACKUP AS COPY CURRENT CONTROLFILE;
- ✓
Only (i)
Correct - B
Either (i) or (ii)
- C
Only (ii)
- D
Neither (i) or (ii)
- ✓
- Question 6
As a DBA, you are managing the pluggable database PDBDATA of container database CDBINFY. The tablespace TBS_TEST of the container database CDBINFY is associated with the datafile ‘test01.dbf'. You are required to list the backups that are available for the tablespace TBS_TEST. The datafile ‘test01.dbf' is stored in $ORACLE_BASE/oradata/CDBINFY/ path.
Which of the following LIST commands can be used, to list the backups that are available for the tablespace TBS_TEST? [Choose 2 CORRECT options]
- ✓
LIST BACKUP OF DATABASE
Correct - B
LIST BACKUP OF TABLESPACE TBS_TEST
- C
LIST BACKLUP OF DATAFILE ‘/u01/app/oracle/oradata/CDBINFY/test01.dbf’
- D
LIST BACKUP BY FILE
- ✓
- Question 7
As a DBA, you performed the full backup of the INFY container database, by issuing the following command.
$ export ORACLE_SID=INFY
$ rman target /
RMAN> BACKUP DATABASE PLUS ARCHIVELOG
Which of the following files will be backed up?
(i)All datafiles
(ii)Control files
(iii)Server parameter file
(iv) Archive redo log files
- ✓
Only (i) and (iv)
Correct - B
All (i), (ii), (iii) and (iv)
- C
Only (i), (ii) and (iv)
- D
Only (i), (iii) and (iv)
- ✓
- Question 8
As a DBA, you are requested to take online backup of the container database CDBDATA. Identify the statement which is true ?
- ✓
The database should be in noarchivelog mode to perform online backup
Correct - B
The database should be in archivelog mode to perform online backup
- C
Online backup cannot be performed on the database, as the database is used to perform other transactions.
- D
Online backup does not depend on the archive mode of the database.
- ✓
- Question 9
As a DBA, you executed the following statements to take the backup of the container database ORCL.
$ export ORACLE_SID=ORCL
$ rman target /
RMAN> BACKUP AS COPY DEVICE TYPE DISK DATABASE;
Which of the following is/are TRUE with respect to the backup taken? [ Choose 2 CORRECT options]
- ✓
IMAGE COPY of the database can be written only to disk
Correct - B
IMAGE COPY of the database can be compressed
- C
IMAGE COPY can contain data from one or more datafiles
- D
IMAGE COPY can be used only for full backup
- ✓
- Question 10
Which of the following privileges are required for the user to take backup of the database?
(i)SYSDBA
(ii)SYSBACKUP
(iii)SYSOPER
- ✓
Either (i) or (iii)
Correct - B
Either (i) or (ii)
- C
Either (ii) or (iii)
- D
Either (i) or (ii) or (iii)
- ✓
More in Code
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.