ADBl Certificationl Examl (Latestl 2025/l
2026l Update)l Q/Al |l Gradel A|l 100%l
Correctl (Verifiedl Answers)
Q:l Whichl statementl isl truel aboutl connectingl al marketplacel Oraclel Cloudl
Infrastructurel (OCI)l imagel tol anl Autonomousl Databasel onl Sharedl Infrastructure?
Optionsl arel :
Thel Autonomousl Databasel mustl belongl tol al Networkl Securityl Groupl (NSG).l Al Privatel
Endpointl isl requiredl tol connectl tol thel Autonomousl Databasel onl sharedl Exadatal
infrastructure.
Thel Autonomousl Databasel canl onlyl bel inl thel samel virtuall cloudl networkl (VCN)l andl
subnetl asl thel marketplacel OCIl image.
Thel marketplacel OCIl imagel canl bel usedl withl anl Alwaysl Freel Autonomousl Databasel
account.l
Thel marketplacel OCIl imagel doesl notl supportl connectingl tol anl Autonomousl Databasel
onl Sharedl Infrastructure.
Answer:
Thel marketplacel OCIl imagel canl bel usedl withl anl Alwaysl Freel Autonomousl Databasel
account.
Q:l Al newl Pythonl developerl hasl joinedl yourl teaml andl needsl tol accessl thel
Autonomousl Databasel (ADB)l data.l Howl doesl thel developerl connectl tol andl interactl
withl ADBl froml Python?
Optionsl arel :
Usingl JDBCl Driver
Usingl SQLl Developer
Usingl thel Oraclel Clientl andl thel cx_Oraclel interface
Answer:
Usingl thel Oraclel Clientl andl thel cx_Oraclel interfacel (Correct)
,Q:l Anl Autonomousl Databasel (ADB)l userl withl anl instancel walletl hasl leftl thel
company.l Thel userl hadl sharedl al databasel userl IDl withl otherl usersl whenl accessingl
ADB.l Otherl thanl changingl thel sharedl userl password,l whatl canl anl administratorl dol tol
protectl thel instance?
Optionsl arel :
Deletel thel user.
Trustl thel userl whol leftl tol notl accessl thel database.
Rotatel thel instancel walletl andl sharel thel newl walletl withl thel remainingl users.l
Shutl downl andl restartl thel instance.
Answer:
Rotatel thel instancel walletl andl sharel thel newl walletl withl thel remainingl user
Q:l Whichl stagel ofl thel indexingl pipelinel dividesl textl intol tokens?
Optionsl arel :
FILTER
Sectioner
LEXERl
ToxeNrzER
Answer:
LEXERl (Correct)
Q:l Whichl twol methodsl canl youl usel tol createl databasel usersl andl grantl rolesl inl
Autonomousl Databasel services?l (Choosel alll correctl answers)
Optionsl arel :
SQLl Developerl
Thel pams_cnoup_apmrnl package
SQL*Plusl
Thel Oraclel Cloudl Infrastructurel servicel console
Answer:
SQLl Developerl
SQLl Plus
,Q:l Whichl methodl willl NOTl permitl youl tol changel thel databasel apsrnl user'sl passwordl
ofl anl Oraclel Autonomousl Databasel onl Sharedl Infrastructure?l (Choosel thel bestl answer.)
Optionsl arel :
OSl commandl linel froml thel databasel server
SQLl Developer
OCIl CLI
Adminl pagel ofl thel Cloudl Servicel Console
Answer:
OSl commandl linel froml thel databasel server
Q:l Whichl twol optionsl arel availablel tol restorel anl Oraclel Autonomousl Database?l
(Choosel alll correctl answers)
Optionsl arel :
Specifyl thel archivedl customl image.l
Usel Recoveryl Managerl (RMAN)l tol connectl tol Autonomousl Databasel andl backl itl up.
Selectl thel snapshotl ofl thel backup.
Specifyl thel pointl inl timel (timestamp)l tol restore.l
Selectl thel backupl froml whichl restorel needsl tol bel done.
Answer:
Specifyl thel archivedl customl image.l (Correct)
Specifyl thel pointl inl timel (timestamp)l tol restore.l (Correct)
Q:l Whatl arel twol differentiatorsl ofl Oraclel Autonomousl Databasel onl Dedicatedl
Infrastructure?l (Choosel alll correctl answers)
Optionsl arel :
Usersl havel OSl accessl tol thel databasel machine.l
Usersl canl customizel thel OSl stackl andl addl additionall packages.
Usersl havel morel controll overl thel maintenancel schedule.
Usersl havel sysl privilegesl inl thel database.
Tol offersl greaterl controll andl Isolationl startingl atl thel Exadatal cloudl infrastructurel level.
Answer:
Usersl havel OSl accessl tol thel databasel machine
Tol offersl greaterl controll andl Isolationl startingl atl thel Exadatal cloudl infrastructurel level.
, Q:l Yourl customerl hasl upgradedl theirl on-premisesl 11.2l Databasel tol 12.2.l Duil
databasel wasl migratedl tol al pluggablel databasel andl isl nowl inl production.l Howl shouldl
thel customerl unplugl theirl databasel tol migratel tol Autonomousl Databasel (ADB)?
Optionsl arel :
ROl Unplugl intol anl XMLl filel sol databasel filesl andl XMLl filel canl bel uploadedl tol
objectl storage.
Createl al databasel linkl froml thel sourcel databasel tol thel ADBl environmentl andl clonel thel
PDB.
Unplugl intol al PDBl archive,l whichl canl bel uploadedl tol objectl storage.
Pluggablel databasesl cannotl bel migratedl tol ADBl usingl plug,l unplug,l orl clone.
Answer:
Pluggablel databasesl cannotl bel migratedl tol ADBl usingl plug,l unplug,l orl clone.l (Correct)
Q:l Howl dol youl changel thel tablespacel quotal forl userl mrizol onl Autonomousl Databasel
onl Sharedl Infrastructure?
Optionsl arel :
Executel alterl databasel forl userl MTHEOl tablespacel DATAl quotal =l 10G;
Executel alterl userl MTHEOl quotal unlimitedl onl tablespacel DATA;
Executel nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTAl (usernamel =>l
'MTHEO�,l tablespacel quotal ~>l "UNLIMITED')l ;
Executel alterl tablespacel DATAl setl quotal =l 10G;
Answer:
Executel nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTAl (usernamel =>l
'MTHEO�,l tablespacel quotal ~>l "UNLIMITED')l ;l (Correct)
Q:l Whichl setl ofl optionsl canl bel specifiedl whenl definingl thel preferredl maintenancel
schedulel ofl thel Exadatal infrastructurel forl Autonomousl Databasel Dedicated?
Optionsl arel :
Quarterl ofl thel Year,l Monthl ofl thel Quarter,l Datel ofl thel Month,l Startl Hour
Monthl ofl thel Quarter,l Weekl ofl thel Month,l Dayl ofl thel Week,l Startl Hourl
Monthl ofl thel Year,l Weekl ofl thel Month,l Dayl ofl thel Week,l Startl Hour
Weekl ofl thel Quarter,l Dayl ofl thel Week,l Startl Hour
Answer:
2026l Update)l Q/Al |l Gradel A|l 100%l
Correctl (Verifiedl Answers)
Q:l Whichl statementl isl truel aboutl connectingl al marketplacel Oraclel Cloudl
Infrastructurel (OCI)l imagel tol anl Autonomousl Databasel onl Sharedl Infrastructure?
Optionsl arel :
Thel Autonomousl Databasel mustl belongl tol al Networkl Securityl Groupl (NSG).l Al Privatel
Endpointl isl requiredl tol connectl tol thel Autonomousl Databasel onl sharedl Exadatal
infrastructure.
Thel Autonomousl Databasel canl onlyl bel inl thel samel virtuall cloudl networkl (VCN)l andl
subnetl asl thel marketplacel OCIl image.
Thel marketplacel OCIl imagel canl bel usedl withl anl Alwaysl Freel Autonomousl Databasel
account.l
Thel marketplacel OCIl imagel doesl notl supportl connectingl tol anl Autonomousl Databasel
onl Sharedl Infrastructure.
Answer:
Thel marketplacel OCIl imagel canl bel usedl withl anl Alwaysl Freel Autonomousl Databasel
account.
Q:l Al newl Pythonl developerl hasl joinedl yourl teaml andl needsl tol accessl thel
Autonomousl Databasel (ADB)l data.l Howl doesl thel developerl connectl tol andl interactl
withl ADBl froml Python?
Optionsl arel :
Usingl JDBCl Driver
Usingl SQLl Developer
Usingl thel Oraclel Clientl andl thel cx_Oraclel interface
Answer:
Usingl thel Oraclel Clientl andl thel cx_Oraclel interfacel (Correct)
,Q:l Anl Autonomousl Databasel (ADB)l userl withl anl instancel walletl hasl leftl thel
company.l Thel userl hadl sharedl al databasel userl IDl withl otherl usersl whenl accessingl
ADB.l Otherl thanl changingl thel sharedl userl password,l whatl canl anl administratorl dol tol
protectl thel instance?
Optionsl arel :
Deletel thel user.
Trustl thel userl whol leftl tol notl accessl thel database.
Rotatel thel instancel walletl andl sharel thel newl walletl withl thel remainingl users.l
Shutl downl andl restartl thel instance.
Answer:
Rotatel thel instancel walletl andl sharel thel newl walletl withl thel remainingl user
Q:l Whichl stagel ofl thel indexingl pipelinel dividesl textl intol tokens?
Optionsl arel :
FILTER
Sectioner
LEXERl
ToxeNrzER
Answer:
LEXERl (Correct)
Q:l Whichl twol methodsl canl youl usel tol createl databasel usersl andl grantl rolesl inl
Autonomousl Databasel services?l (Choosel alll correctl answers)
Optionsl arel :
SQLl Developerl
Thel pams_cnoup_apmrnl package
SQL*Plusl
Thel Oraclel Cloudl Infrastructurel servicel console
Answer:
SQLl Developerl
SQLl Plus
,Q:l Whichl methodl willl NOTl permitl youl tol changel thel databasel apsrnl user'sl passwordl
ofl anl Oraclel Autonomousl Databasel onl Sharedl Infrastructure?l (Choosel thel bestl answer.)
Optionsl arel :
OSl commandl linel froml thel databasel server
SQLl Developer
OCIl CLI
Adminl pagel ofl thel Cloudl Servicel Console
Answer:
OSl commandl linel froml thel databasel server
Q:l Whichl twol optionsl arel availablel tol restorel anl Oraclel Autonomousl Database?l
(Choosel alll correctl answers)
Optionsl arel :
Specifyl thel archivedl customl image.l
Usel Recoveryl Managerl (RMAN)l tol connectl tol Autonomousl Databasel andl backl itl up.
Selectl thel snapshotl ofl thel backup.
Specifyl thel pointl inl timel (timestamp)l tol restore.l
Selectl thel backupl froml whichl restorel needsl tol bel done.
Answer:
Specifyl thel archivedl customl image.l (Correct)
Specifyl thel pointl inl timel (timestamp)l tol restore.l (Correct)
Q:l Whatl arel twol differentiatorsl ofl Oraclel Autonomousl Databasel onl Dedicatedl
Infrastructure?l (Choosel alll correctl answers)
Optionsl arel :
Usersl havel OSl accessl tol thel databasel machine.l
Usersl canl customizel thel OSl stackl andl addl additionall packages.
Usersl havel morel controll overl thel maintenancel schedule.
Usersl havel sysl privilegesl inl thel database.
Tol offersl greaterl controll andl Isolationl startingl atl thel Exadatal cloudl infrastructurel level.
Answer:
Usersl havel OSl accessl tol thel databasel machine
Tol offersl greaterl controll andl Isolationl startingl atl thel Exadatal cloudl infrastructurel level.
, Q:l Yourl customerl hasl upgradedl theirl on-premisesl 11.2l Databasel tol 12.2.l Duil
databasel wasl migratedl tol al pluggablel databasel andl isl nowl inl production.l Howl shouldl
thel customerl unplugl theirl databasel tol migratel tol Autonomousl Databasel (ADB)?
Optionsl arel :
ROl Unplugl intol anl XMLl filel sol databasel filesl andl XMLl filel canl bel uploadedl tol
objectl storage.
Createl al databasel linkl froml thel sourcel databasel tol thel ADBl environmentl andl clonel thel
PDB.
Unplugl intol al PDBl archive,l whichl canl bel uploadedl tol objectl storage.
Pluggablel databasesl cannotl bel migratedl tol ADBl usingl plug,l unplug,l orl clone.
Answer:
Pluggablel databasesl cannotl bel migratedl tol ADBl usingl plug,l unplug,l orl clone.l (Correct)
Q:l Howl dol youl changel thel tablespacel quotal forl userl mrizol onl Autonomousl Databasel
onl Sharedl Infrastructure?
Optionsl arel :
Executel alterl databasel forl userl MTHEOl tablespacel DATAl quotal =l 10G;
Executel alterl userl MTHEOl quotal unlimitedl onl tablespacel DATA;
Executel nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTAl (usernamel =>l
'MTHEO�,l tablespacel quotal ~>l "UNLIMITED')l ;
Executel alterl tablespacel DATAl setl quotal =l 10G;
Answer:
Executel nams_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTAl (usernamel =>l
'MTHEO�,l tablespacel quotal ~>l "UNLIMITED')l ;l (Correct)
Q:l Whichl setl ofl optionsl canl bel specifiedl whenl definingl thel preferredl maintenancel
schedulel ofl thel Exadatal infrastructurel forl Autonomousl Databasel Dedicated?
Optionsl arel :
Quarterl ofl thel Year,l Monthl ofl thel Quarter,l Datel ofl thel Month,l Startl Hour
Monthl ofl thel Quarter,l Weekl ofl thel Month,l Dayl ofl thel Week,l Startl Hourl
Monthl ofl thel Year,l Weekl ofl thel Month,l Dayl ofl thel Week,l Startl Hour
Weekl ofl thel Quarter,l Dayl ofl thel Week,l Startl Hour
Answer:
