Infosys Certified Oracle 12c Administration Associate
Practice with real exam-pattern questions for Infosys Certified Oracle 12c Administration Associate. 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 Associate practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Oracle 12c Administration Associate certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
As part of the business requirement, you need to create a pluggable database PDB_EMP to store the employee details and executes the following SQL command,
Which of the following statement is TRUE with respect to pluggable database PDB_EMP?
- ✓
As default tablespace is not mentioned while creating, pluggable database PDB_EMP’s default tablespace will be same as that of the container database
Correct - B
The code will not get executed as default tablespace is not mentioned
- C
PDB_EMP will be created with the default tablespace as SYSTEM
- D
The default tablespace of PDB_EMP is NULL
- ✓
- Question 2
DBWn background process of oracle is responsible for writing dirty data blocks to data files.
Which of the following conditions trigger the DBWn process? [Choose 2 CORRECT options]
- ✓
When there is no free space left in database buffer cache
Correct - B
When the database buffer cache is one-third full
- C
When commit is issued
- D
When a checkpoint occurs
- ✓
- Question 3
Arrange the following statement(s) in the order of their occurrence when a SELECT query is issued on Oracle database.
- Reads data from the data file and keeps a copy in the database buffer cache
- Performs syntax and semantic check
- Creates an execution plan
- Returns the result to the users
- ✓
(i), (ii), (iii), (iv)
Correct - B
(ii), (iii), (i), (iv)
- C
(i), (iv), (iii), (ii)
- D
(ii), (iv), (iii), (i)
- Question 4
Jack is a DBA for Syntel Ltd. A container database CDBEMP is created with pluggable database PDB_CAT using DBCA. As per the business requirements, he has been updated to create another pluggable database PDB_INF inside the container database CDBEMP.
What will be the container id for the newly created PDB?
- ✓
Container id is randomly generated
Correct - B
1
- C
2
- D
4
- ✓
- Question 5
While performing monitoring activity,you as a DBA executed the below commands to view certain instance related parameters which is as below.
Which of the following statement is TRUE with respect to the above scenario?
- ✓
Automatic memory management is disabled
Correct - B
Automatic memory management is enabled and DBA will manage the memory allocation for SGA and PGA
- C
Automatic memory management is enabled
- D
Automatic memory management is disabled, therefore 60% of the MEMORY_TARGET is given for SGA and 40% of MEMORY_TARGET is assigned to PGA
- ✓
- Question 6
As SYS user, you are trying to start CDB1 database instance. While starting the database, it has to perform the instance recovery.
From the above scenario, deduce the mode of last shutdown operation.
- ✓
SHUTDOWN NORMAL
Correct - B
SHUTDOWN ABORT
- C
SHUTDOWN IMMEDIATE
- D
SHUTDOWN TRANSACTIONAL
- ✓
- Question 7
You as a DBA, has to perform the maintenance activity on PDBDATA. As part of the activity, you need to first restart the pluggable database PDBDATA.
Which of the below statement(s) can be executed to perform the restart when connected to root container?
- SQL> ALTER PLUGGABLE DATABASE PDBDATA CLOSE;
SQL> ALTER PLUGGABLE DATABASE PDBDATA OPEN;
ii. SQL> ALTER PLUGGABLE DATABASE PDBDATA OPEN FORCE;
- ✓
Only (i)
Correct - B
Only (ii)
- C
Neither (i) nor (ii)
- D
Either (i) or (ii)
- Question 8
DBA has received the request to get all the details of employees through a SQL query, for an analysis purpose.
Once the SQL query is executed, which of the following memory structure will be used to store the queried rows of employee table?
- ✓
PRIVATE SQL AREA
Correct - B
SHARED POOL
- C
DATABASE BUFFER CACHE
- D
JAVA POOL
- ✓
- Question 9
You as a DBA, required to create a container database to store the details of the customers. GUI is disabled in the server machine.
Which of the following statement is TRUE with respect to manual database creation?
- ✓
Container databases can be created only using GUI i.e. using DBCA
Correct - B
CREATE DATABASE SQL query can be used only to create non container database
- C
CREATE DATABASE SQL query can be used to create container database which can hold only one pluggable database
- D
CREATE DATABASE SQL query can be used to create container database which can hold pluggable up to 252
- ✓
- Question 10
You as a DBA, connects to the CDBINFY database. Which of the following memory structure will be used to store the session details?
- ✓
SGA
Correct - B
PGA
- C
Database Buffer Cache
- D
Data Dictionary Cache
- ✓
More in IMS Academy
Infosys Certified WebSphere Application Server 8.5 Administrator
Infosys Certified Windows 11 Administrator - Associate
Infosys Certified Windows Server 2022 Administrator – Associate
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.