Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCO!"#_PDB, bot$ o% w$ic$ use t$e CDB tablespace& "$e temp %ile is called temp'&tmp& A user issues a uer* on a table on one o% t$e PDBs and recei+es t$e %ollowing error -denti%* two wa*s to recti%* t$e error&
A& Add a new temp %ile to t$e temporar* tablespace and drop t$e temp %ile t$at t$at produced t$e error& B& "a.e t$e temporar* tablespace o%%line, reco+er t$e missing temp %ile b* appl*ing redo logs, and t$en bring t$e temporar* tablespace online& C& #$utdown t$e database instance, restore and reco+er t$e temp %ile %rom t$e bac.up, and t$en open t$e database wit$ R/#/"0O1#& D. Shut down the database instance and then restart the CDB and PDBs. E. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
/2amine t$e %ollowing commands %or rede%ining a table wit$ 3irtual Pri+ate Database (3PD) policies 4$ic$ two statements are true about rede%ining t$e table5
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
B& "$e primar* .e* constraint on t$e /6P0OY//# table is disabled during rede%inition& C. VPD policies are copied from the original table to the new table during online redefinition.
D& You must cop* t$e 3PD policies manuall* %rom t$e original table to t$e new table during online rede%inition&
/2amine t$e %ollowing commands %or rede%ining a table wit$ 3irtual Pri+ate Database (3PD) policies 4$ic$ two statements are true about rede%ining t$e table5
A. All the triggers for the table are disabled without changing any of the column names or column types in the table.
B& "$e primar* .e* constraint on t$e /6P0OY//# table is disabled during rede%inition& C. VPD policies are copied from the original table to the new table during online redefinition.
D& You must cop* t$e 3PD policies manuall* %rom t$e original table to t$e new table during online rede%inition&
4$ic$ two statements are true about t$e use o% t$e procedures listed in t$e +7s*sau2_occupants&mo+e_procedure column5 A. The procedure may be used for some components to relocate component data to the SSA!" tablespace from its current tablespace.
B& All t$e components ma* be mo+ed %rom t$e #Y#A8 tablespace& C. The procedure may be used for some components to relocate component data from the SSA!" tablespace to another tablespace.
D& All t$e components ma* be mo+ed into #Y#A8 tablespace&
4$ic$ statement is true about Oracle !et 0istener5 A& -t acts as t$e listening endpoint %or t$e Oracle database instance %or all local and non9local user connections& B& A single listener can ser+ice onl* one database instance and multiple remote client connections& C. Ser#ice registration with the listener is performed by the process monitor $%&E'( process of each database instance.
D& "$e listener&ora con%iguration %ile must be con%igured wit$ one or more listening protocol addresses to allow remote users to connect to a database instance& /& "$e listener&ora con%iguration %ile must be located in t$e ORAC0/_HO6/:networ.:admin directl*&
You are administering a database stored in Automatic #torage 6anagement (A#6)& You use R6A! to bac. up t$e database and t$e 6D_BAC;P command to bac. up t$e A#6 metadata regularl*& You lost an A#6 dis. group D1 due to $ardware %ailure& -n w$ic$ t$ree wa*s can *ou re9create t$e lost dis. group and restore t$e data5 A& se t$e 6D_R/#"OR/ command to restore bot$ t$e metadata and data %or t$e %ailed dis. group& B. !se the )*D' command to restore the dis+ group with the same configuration as the bac+edup dis+ group name and same set of dis+s and failure group configuration, and use &)A- to restore the data.
C& se t$e 6D_R/#"OR/ command to restore metadata %or an e2isting dis. group b* passing t$e e2isting dis. group name as an input parameter and use R6A! to restore t$e data& D& se t$e 6;D1 command to restore t$e dis. group wit$ t$e same con%iguration as t$e bac.edup dis. group and data on t$e dis. group& E. !se the )*D' command to add a new dis+ group D' with the same or different specifications for failure group and other attributes and use &)A- to restore the data. /. !se the )D0&EST1&E command to restore the dis+ group with the changed dis+ group specification, failure group specification, name, and other attributes and use &)A- to restore the data.
Your multitenant container database, CDB, is running in ARCH-3/0O1 mode and $as two pluggable databases, HR_PDB and ACCO!"#_PDB& An R6A! bac.up e2ists %or t$e database& You issue t$e command to open ACCO!"#_PDB and %ind t$at t$e #/RDA"A&DB< data %ile %or t$e de%ault permanent tablespace #/RDA"A belonging to ACCO!"#_PDB is corrupted& 4$at s$ould *ou do be%ore e2ecuting t$e commands to restore and reco+er t$e data %ile in ACCO!"#_PDB5 A& Place CDB in t$e mount stage and t$en t$e #/RDA"A tablespace o%%line in ACCO!"#_PDB& B& Place CDB in t$e mount stage and issue t$e A0"/R P011AB0/ DA"ABA#/ accounts_pdb C0O#/ -66/D-A"/ command& C& -ssue t$e A0"/R P011AB0/ DA"ABA#/ accounts_pdb R/#"R-C"/D command& D. Ta+e the !SE&DATA tablespace offline in ACC1!-TS0PDB.
4$ic$ Oracle Database component is audited b* de%ault i% t$e uni%ied Auditing option is enabled5 A& Oracle Database 3ault B& Oracle Real Application #ecurit* C& Oracle 0abel #ecurit* D. 1racle &eco#ery )anager $&)A-(
/& Oracle Data Pump
Your multitenant container (CDB) containing t$ree pluggable databases (PDBs) is running in ARCH-3/0O1 mode& You %ind t$at t$e #Y#A8 tablespace is corrupted in t$e root container& "$e steps to reco+er t$e tablespace are as %ollows 4$ic$ option identi%ies t$e correct seuence to reco+er t$e #Y#A8 tablespace5
A& ', , =, >, ? B& ', , =, >, @, , ? C& ', , >, ?, ' D. 2, 3, 4, 5
4$ic$ t$ree are direct bene%its o% t$e multiprocess, multit$readed arc$itecture o% Oracle Database =c w$en it is enabled5 A& Reduced logical -:O B. &educed #irtual memory utili6ation C. 7mpro#ed parallel E8ecution performance
D& -mpro+ed #erial /2ecution per%ormance /& Reduced p$*sical -:O /. &educed CP! utili6ation
-n order to e2ploit some new storage tiers t$at $a+e been pro+isioned b* a storage administrator, t$e partitions o% a large $eap table must be mo+ed to ot$er tablespaces in *our Oracle =c database5 Bot$ local and global partitioned B9tree -nde2es are de%ined on t$e table& A $ig$ +olume o% transactions access t$e table during t$e da* and a medium +olume o% transactions access it at nig$t and during wee.ends& 6inimal disrupt ion to a+ailabilit* is reuired& 4$ic$ t$ree statements are true about t$is reuirement5 A& 0ocal inde2es must be rebuilt manuall* a%ter mo+ing t$e partitions& B. The partitions can be compressed in the new tablespaces. C. The partitions can be mo#ed online to new tablespaces.
D& 1lobal inde2es must be rebuilt manuall* a%ter mo+ing t$e partitions& E. The partitions can be compressed in the same tablespaces.
4$ic$ t$ree are true about t$e large pool %or an Oracle database instance t$at supports s$ared ser+er connections5 A. Allocates memory for &)A- bac+up and restore operations B. Allocates memory for shared and pri#ate S9% areas C. Contains a cursor area for storing runtime information about cursors
D& Contains stac. space /& Contains a $as$ area per%orming $as$ oins o% tables
4$at are t$ree purposes o% t$e R6A!
C& "o support P009based acti+e database duplication D& to support P#H9based acti+e database duplication E. To support file restores o#er the networ+ in a Data 'uard en#ironment
You notice t$at t$e per%ormance o% *our production =@:E Oracle database signi%icantl* degraded& #ometimes *ou are not able to connect to t$e instance because it $angs& You do not want to restart t$e database instance& How can *ou detect t$e cause o% t$e degraded per%ormance5 A& /nable 6emor* Access 6ode, w$ic$ reads per%ormance data %rom #1A& B. !se emergency monitoring to fetch data directly from S'A analysis.
C& Run Automatic Database Diagnostic 6onitor (ADD6) to %etc$ in%ormation %rom t$e latest Automatic 4or.load Repositor* (A4R) snaps$ots& D& se Acti+e #ession Histor* (A#H) data and $ang anal*sis in regular per%ormance monitoring& /& Run ADD6 in diagnostic mode&
You plan to use t$e -n Database Arc$i+ing %eature o% Oracle Database =c, and store rows t$at are inacti+e %or o+er t$ree mont$s, in H*brid Columnar Compressed (HCC) %ormat& 4$ic$ t$ree storage options support t$e use o% HCC5 A. Database files stored in :/S and accessed using the 1racle Direct -/S feature
B& Database %iles stored in an* %ile s*stem and accessed using t$e Oracle Direct !<# %eature C. . AS) dis+ groups with AS) dis+s consisting of %!-s on Pillar A8iom Storage arrays
D& A#6 dis. groups wit$ A#6 dis.s consisting o% an* Fero padded !<#9mounted %iles /& A#6 dis. groups wit$ A#6 dis.s consisting o% 0!# on an* #torage Area !etwor. arra* /. AS) dis+ groups with AS) dis+s consisting of E8adata 'rid Dis+s.
1& Database %iles stored in G<# and accessed using con+entional !<# mounts&
-n *our multitenant container database (CDB) containing pluggable databases (PDB), users complain about per%ormance degradation& How does real9time Automatic database Diagnostic 6onitor (ADD6) c$ec. per%ormance degradation and pro+ide solutions5 A& -t collects data %rom bot$ #1A and P1A, anal*Fes it, and pro+ides a report& B. 7t collects data from S'A, analy6es it, and pro#ides a report.
C& -t collects data %rom #1A and compares it wit$ t$e latest snaps$ot& D& -t collects data %rom #1A and compares it wit$ a preser+ed snaps$ot&
"$e tnsnames&ora %ile $as an entr* %or t$e ser+ice alias ORC0 as %ollows "$e "!# ping command e2ecutes success%ull* w$en tested wit$ ORC0 $owe+er, %rom t$e same O# user session, *ou are not able to connect to t$e database instance wit$ t$e %ollowing command #I0 J CO!!/C" scott:tigerKorcl 4$at could be t$e reason %or t$is5
A& "$e listener is running on a di%%erent port& B& "$e D/
D& "$e listener is not running on t$e database node& /& "$e "!#_AD6-! en+ironment +ariable is set to t$e wrong +alue&
/2amine t$e %ollowing steps o% pri+ilege anal*sis %or c$ec.ing and re+o.ing e2cessi+e, unused pri+ileges granted to users -denti%* t$e correct seuence o% steps&
A& , L, >, M, =, @ B& , L, >, =, M, @ C& , L, =, >, M, @ D. , ;, 2, <, 3, 4
/& , L, =, >, M, @
You database is running an ARCH-3/0O1 mode& "$e %ollowing parameter are set in *our database instance 4$ic$ statement is true about t$e arc$i+ed redo log %iles5
A. They are created only in the location specified by the %1'0A&C=7VE0DEST0 parameter.
B& "$e* are created onl* in t$e
Your multitenant container database (CDB) is running in ARCH-3/0O1 mode& You connect to t$e CDB R6A!& /2amine t$e %ollowing command and its output You e2ecute t$e %ollowing command R6A! J BAC;P DA"ABA#/ P0# ARCH-3/0O1 4$ic$ data %iles will be bac.ed up5
A& Data %iles t$at belong to onl* t$e root container B. Data files that belong to the root container and all the pluggable databases $PDBs(
C& Data %iles t$at belong to onl* t$e root container and PDB7#//D D& Data %iles t$at belong to t$e root container and all t$e PDBs e2cluding PDB7#//D
You are administering a database stored in Automatic #torage management (A#6)& "$e %iles are stored in t$e DA"A dis. group& You e2ecute t$e %ollowing command 4$at is t$e result5
A. The file >?data.<;.3452@ remains in the same location and a synonym >myfile.dbf is created.
B& "$e %ile Nm*%ile&db% is created in Ndata:prod and t$e re%erence to Ndata&=L&>@EM in t$e data dictionar* remo+ed& C& "$e %ile Ndata&=L&>@EM is p$*sicall* relocated to Ndata:prod and renamed as Nm*%ile&db%& D& "$e %ile Ndata&=L&>@EM is renamed as Nm*%ile&db%, and copied to Ndata:prod&
4$ic$ t$ree %unctions are per%ormed b* t$e #I0 "uning Ad+isor5 A. Building and implementing S9% profiles
B& Recommending t$e optimiFation o% materialiFed +iews C. Chec+ing uery obects for missing and stale statistics
D& Recommending bitmap, %unction9based, and B9tree inde2es E. &ecommending the restructuring of S9% ueries that are using bad plans
Your multitenant container database (CDB) contains t$ree pluggable database (PDBs)& You
%ind t$at t$e control %ile is damaged& You plan to use R6A! to reco+er t$e control %ile& "$ere are no startup triggers associated wit$ t$e PDBs& 4$ic$ t$ree steps s$ould *ou per%orm to reco+er t$e control %ile and ma.e t$e database %ull* operational5 A. Start the database instance in the nomount stage and restore the control file from control file auto bac+up.
B& Reco+er eac$ pluggable database& C. 1pen all the pluggable databases. D. )ount the CDB and then reco#er and open the database, with the &ESET%1'S option.
/& 6ount t$e container database (CDB) and restore t$e control %ile %rom t$e control %ile auto bac.up& <& Reco+er and open t$e CDB in !OR6A0 mode&
A new report process containing a comple2 uer* is written, wit$ $ig$ impact on t$e
database& You want to collect basic statistics about uer*, suc$ as t$e le+el o% parallelism, total database time, and t$e number o% -:O reuests&
D& se t$e DB6#_APP0-CA"-O!_-!
-denti%* two +alid options %or adding a pluggable database (PDB) to an e2isting multitenant container database (CDB)& A& se t$e CR/A"/ DA"ABA#/ & & & /!AB0/ P011AB0/ DA"ABA#/ statement to pro+ision a PDB b* cop*ing %ile %rom t$e #//D& B& se t$e DB6#_PDB pac.age to plug an Oracle g Release = (&=&'&L&') non9CDB database into an e2isting CDB& C. !se the C&EATE P%!''AB%E DATABASE statement to create a PDB using the files from the SEED.
D& se t$e DB6#_PDB pac.age to clone an e2isting PDB& E. !se the DB)S0PDB pac+age to plug an 1racle
-denti%* two +alid options %or adding a pluggable database (PDB) to an e2isting multitenant
container database (CDB)& A& se t$e CR/A"/ DA"ABA#/ & & & /!AB0/ P011AB0/ DA"ABA#/ statement to pro+ision a PDB b* cop*ing %ile %rom t$e #//D& B& se t$e DB6#_PDB pac.age to plug an Oracle g Release = (&=&'&L&') non9CDB database into an e2isting CDB& C. !se the C&EATE P%!''AB%E DATABASE statement to create a PDB using the files from the SEED.
D& se t$e DB6#_PDB pac.age to clone an e2isting PDB& E. !se the DB)S0PDB pac+age to plug an 1racle
Your database supports a D## wor.load t$at in+ol+es t$e e2ecution o% comple2 ueries Currentl*, t$e librar* cac$e contains t$e ideal wor.load %or anal*sis& You want to anal*Fe some o% t$e ueries %or an application t$at are cac$ed in t$e librar* cac$e& 4$at must *ou do to recei+e recommendations about t$e e%%icient use o% inde2es and materialiFed +iews to impro+e uer* per%ormance5 A& Create a #I0 "uning #et (#"#) t$at contains t$e ueries cac$ed in t$e librar* cac$e and run t$e #I0 "uning Ad+isor (#"A) on t$e wor.load captured in t$e #"#& B& Run t$e Automatic 4or.load Repositor* 6onitor (ADD6)& C& Create an #"# t$at contains t$e ueries cac$ed in t$e librar* cac$e and run t$e #I0 Per%ormance Anal*Fer (#PA) on t$e wor.load captured in t$e #"#& D. Create an STS that contains the ueries cached in the library cache and run the S9% Access Ad#isor on the wor+load captured in the STS.
"$e %ollowing parameter are set %or *our Oracle =c database instance You want to
manage t$e #I0 plan e+olution tas. manuall*& /2amine t$e %ollowing steps & #et t$e e+ol+e tas. parameters& =& Create t$e e+ol+e tas. b* using t$e DB6#_#P6&CR/A"/_/3O03/_"A#; %unction& L& -mplement t$e recommendations in t$e tas. b* using t$e DB6#_#P6&-6P0/6/!"_/3O03/_"A#; %unction& @& /2ecute t$e e+ol+e tas. b* using t$e DB6#_#P6&/8/C"/_/3O03/_"A#; %unction& >& Report t$e tas. outcome b* using t$e DB6#_#P6&R/POR"_/3O03/_"A#; %unction& -denti%* t$e correct seuence o% steps
A& =, @, > B. <, , 4, ;, 3
C& , =, L, @, > D& , =, @, >
-n a recent Automatic 4or.load Repositor* (A4R) report %or *our database, *ou notice a
$ig$ number o% bu%%er bus* waits& "$e database consists o% locall* managed tablespaces wit$ %ree list managed segments& On %urt$er in+estigation, *ou %ind t$at bu%%er bus* waits is caused b* contention on data bloc.s& 4$ic$ option would *ou consider %irst to decrease t$e wait e+ent immediatel*5 A& Decreasing PC"#/D B& -ncreasing db_bu%%er_cac$e based on t$e 37DB_CACH/_AD3-C/ recommendation C. !sing Automatic Segment Space )anagement $ASS)(
D& Decreasing PC"
/2amine t$is command #I0 J e2ec DB6#_#"A"#&#/"_"AB0/_PR/<# (N#H, NC#"O6/R#, NPB0-#H, N%alse) 4$ic$ t$ree statements are true about t$e e%%ect o% t$is command5 A& #tatistics collection is not done %or t$e C#"O6/R# table w$en sc$ema stats are gat$ered& B& #tatistics collection is not done %or t$e C#"O6/R# table w$en database stats are gat$ered& C. Any e8isting statistics for the C!ST1)E&S table are still a#ailable to the optimi6er at parse time. D. Statistics gathered on the C!ST1)E&S table when schema stats are gathered are stored as pending statistics. E. Statistics gathered on the C!ST1)E&S table when database stats are gathered are stored as pending statistics.
/2amine t$e %ollowing impdp command to import a database o+er t$e networ. %rom a
pre9=c Oracle database (source) 4$ic$ t$ree are prereuisites %or success%ul e2ecution o% t$e command5
A& "$e import operation must be per%ormed b* a user on t$e target database wit$ t$e DA"AP6P_-6P_<00_DA"ABA#/ role, and t$e database lin. must connect to a user on t$e source database wit$ t$e DA"AP6P_/8D_<00_DA"ABA#/ role& B& "$e impdp operation must be per%ormed b* t$e same user t$at per%ormed t$e e2pdp operation& C& "$e pat$ o% data %iles on t$e target database must be t$e same as t$at on t$e source database& D& All t$e user9de%ined tablespaces must be in read9onl* mode on t$e source database& /& "$e e2port dump %ile must be created be%ore starting t$e import on t$e target database& <& "$e source and target database must be running on t$e same plat%orm wit$ t$e same endianness&
4$ic$ two are true concerning a multitenant container database wit$ t$ree pluggable
database5 A& All administration tas.s must be done to a speci%ic pluggable database& B& "$e pluggable databases increase patc$ing time& C. The pluggable databases reduce administration effort. D. The pluggable databases are patched together.
/& Pluggable databases are onl* used %or database consolidation&
/2amine t$e current +alue %or t$e %ollowing parameters in *our database instance You issue t$e %ollowing command to increase t$e +alue o% DB_?;_CACH/_#-G/ 4$ic$ statement is true5
A& -t succeeds onl* i% memor* is a+ailable %rom t$e autotuned components i% #1A& B& -t %ails because an increase in DB_?;_CACH/_#-G/ cannot be accommodated wit$in #1A_"AR1/"& C& -t %ails because t$e DB_?;_CACH/_#-G/ parameter cannot be c$anged d*namicall*& D& -t %ails because an increase in DB_?;_CACH/_#-G/ cannot be accommodated wit$in #1A_6A8_#-G/&
4$ic$ t$ree statements are true concerning unplugging a pluggable database (PDB)5
A& "$e PDB must be open in read onl* mode& B. The PDB must be dosed.
C& "$e unplugged PDB becomes a non9CDB& D. The unplugged PDB can be plugged into the same multitenant container database $CDB( E. The unplugged PDB can be plugged into another CDB.
<& "$e PDB data %iles are automaticall* remo+ed %rom dis.&
/2amine t$e %ollowing command 4$ic$ t$ree statements are true about using an in+isible column in t$e PRODC"# table5
A& Re%erential integrit* constraint cannot be set on t$e in+isible column& B& "$e in+isible column cannot be made +isible and can onl* be mar.ed as unused& C. The &1FTPE attribute declarations in P%GS9% to access a row will not display the in#isible column in the output. D. The DESC&7BE commands in S9% HPlus will not display the in#isible column in the output. E. A primary +ey constraint can be added on the in#isible column.
You wis$ to enable an audit polic* %or all database users, e2cept #Y#, #Y#"/6, and #CO""& You issue t$e %ollowing statements
now acti+e5
A& All users e2cept #Y# B& All users e2cept #CO"" C& All users e2cept s*s and #CO"" D& All users e2cept s*s, s*stem, and #CO""
On *our Oracle =c database, *ou in+o.ed #I0 Q0oader to load data into t$e /6P0OY//# table in t$e HR sc$ema b* issuing t$e %ollowing command 7J slldr $r:$rKpdb tableemplo*ees 4$ic$ two statements are true regarding t$e command5 A& -t %ails because no #I0 Q0oader control %ile location is speci%ied& B. 7t succeeds with default settings if the E)P%1EES table belonging to =& is already defined in the database.
C& -t %ails because no #I0 Q0oader data %ile location is speci%ied& D. 7t fails if the =& user does not ha#e the C&EATE A- D7&ECT1& pri#ilege.
A%ter implementing %ull Oracle Data Redaction, *ou c$ange t$e de%ault +alue %or t$e !6B/R data t*pe as %ollows A%ter c$anging t$e +alue, *ou notice t$at <00 redaction
continues to redact numeric data wit$ Fero& 4$at must *ou do to acti+ate t$e new de%ault +alue %or numeric %ull redaction5
A. &estart the database instance.
B&
You must trac. all transactions t$at modi%* certain tables in t$e sales sc$ema %or at least t$ree *ears& Automatic undo management is enabled %or t$e database wit$ a retention o%
one da*& 4$ic$ two must *ou do to trac. t$e transactions5 A& /nable supplemental logging %or t$e database& B& #peci%* undo retention guarantee %or t$e database& C& Create a
Your are t$e DBA supporting an Oracle g Release = database and wis$ to mo+e a table containing se+eral DA"/, CHAR, 3ARCHAR=, and !6B/R data t*pes, and t$e tables inde2es, to anot$er tablespace& "$e table does not $a+e a primar* .e* and is used b* an O0"P application& 4$ic$ tec$niue will mo+e t$e table and inde2es w$ile maintaining t$e $ig$est le+el o% a+ailabilit* to t$e application5 A& /dition9Based "able Rede%inition& B. 1nline Table &edefinition.
C& An A0"/R "AB0/ 6O3/ to mo+e t$e table and A0"/R -!D/8 R/B-0D to mo+e t$e inde2es& D& Oracle Data Pump& /& An A0"/R "AB0/ 6O3/ to mo+e t$e table and A0"/R -!D/8 R/B-0D O!0-!/ to mo+e t$e inde2es&
"o implement Automatic 6anagement (A66), *ou set t$e %ollowing parameters 4$en *ou tr* to start t$e database instance wit$ t$ese parameter settings, *ou recei+e t$e %ollowing
error message #I0 J startup ORA9''?=@ cannot set #1A_"AR1/" or 6/6ORY_"AR1/" due to e2isting internal settings, see alert log %or more in%ormation& -denti%* t$e reason t$e instance %ailed to start&
A& "$e P1A_A11R/1A"/_"AR1/" parameter is set to Fero& B& "$e #"A"-#"-C#_0/3/0 parameter is set to BA#-C& C& Bot$ t$e #1A_"AR1/" and 6/6ORY_"AR1/" parameters are set& D& "$e #1A_6A8_#-G/ and #1A_"AR1/" parameter +alues are not eual&
4$at are two bene%its o% installing 1rid -n%rastructure so%tware %or a stand9alone ser+er be%ore installing and creating an Oracle database5 A. Effecti#ely implements role separation
B& /nables *ou to ta.e ad+antage o% Oracle 6anaged
D& Helps *ou to easil* upgrade t$e database %rom a prior release& /& /nables t$e -nstallation o% 1rid -n%rastructure %iles on bloc. or raw de+ices& -denti%* two correct statements about multitenant arc$itectures&
A& 6ultitenant arc$itecture can be deplo*ed onl* in a Real Application Clusters (RAC) con%iguration& B& A PDB can $a+e a pri+ate undo tablespace& C. Patches are always applied at the CDB le#el.
D& 6ultiple non9RAC CDB instances can mount t$e same PDB as long as t$e* are on t$e same ser+er& E. )ultiple pluggable databases $PDBs( share certain multitenant container database $CDB( resources.
<& 6ultiple CDBs s$are certain PDB resources&
You upgrade *our Oracle database in a multiprocessor en+ironment& As a recommended *ou e2ecute t$e %ollowing script #I0 J Kutlrp&sl 4$ic$ two actions does t$e script per%orm5 A& #euential recompilation o% Sa+a code B& Parallel compilation o% onl* t$e stored P0:#I0 code C& #euential recompilation o% onl* t$e stored P0:#I0 code D. Parallel recompilation of any stored P%GS9% code
/& #euential recompilation o% an* stored P0:#I0 code /. Parallel recompilation of Ia#a code
4$ic$ two statement is true concerning dropping a pluggable database (PDB)5
A& A dropped PDB can ne+er be plugged bac. into a multitenant container database (CDB)& B. The PDB data files are always remo#ed from dis+.
C& "$e PDB must be open in read9onl* mode& D& "$e PDB must be in mount state& E. The PDB must be unplugged.
You notice a $ig$ number o% waits %or t$e db %ile scattered read and db %ile seuential read e+ents in t$e recent Automatic Database Diagnostic 6onitor (ADD6) report& A%ter %urt$er in+estigation, *ou %ind t$at ueries are per%orming too man* %ull table scans and inde2es are not being used e+en t$oug$ t$e %ilter columns are inde2ed& -denti%* t$ree possible reasons %or t$is& A. )issing or stale histogram statistics
B& ndersiFed s$ared pool C. =igh clustering factor for the inde8es D. =igh #alue for the DB0/7%E0)!%T7B%1C*0&EAD0C1!-T parameter
/& O+ersiFed bu%%er cac$e
4$ic$ t$ree %eatures wor. toget$er, to allow a #I0 statement to $a+e di%%erent cursors %or
t$e same statement based on di%%erent selecti+it* ranges5 A. Adapti#e Cursor Sharing B. Bind #ariable used in a S9% statement
C& #I0 Plan Baselines D. Bind Variable Pee+ing
/& 0iterals in a #I0 statement
You notice a per%ormance c$ange in *our production Oracle =c database& You want to .now w$ic$ c$ange caused t$is per%ormance di%%erence& A. Compare Period ADD) report
B& A4R Compare Period report C& Acti+e #ession Histor* (A#H) report D& "a.ing a new snaps$ot and comparing it wit$ a preser+ed snaps$ot
You want to capture column group usage and gat$er e2tended statistics %or better
cardinalit* estimates %or t$e C#"O6/R# table in t$e #H sc$ema& /2amine t$e %ollowing steps & -ssue t$e #/0/C" DB6#_#"A"#&CR/A"/_/8"/!D/D_#"A"# (N#H, NC#"O6/R#) '') procedure& L& /2ecute t$e reuired ueries on t$e C#"O6/R# table& @& -ssue t$e #/0/C" DB6#_#"A"#&R/POR"_CO0_#A1/ (N#H, NC#"O6/R#)
D& @, , L, =
4$ic$ t$ree statements are true about Automatic 4or.load Repositor* (A4R)5 A& A4R contains s*stem wide tracing and logging in%ormation& B& A4R computes time model statistics based on time usage %or acti+ities, w$ic$ are displa*ed in t$e +7#Y# time model and 37#/##_"-6/_6OD/0 +iews& C& All A4R tables belong to t$e #Y#"/6 sc$ema& D& "$e snaps$ots collected b* A4R are used b* t$e sel%9tuning components in t$e database /& "$e A4R data is stored in memor* and in t$e database&
You upgraded *our database %rom pre9=c to a multitenant container database (CDB)
containing pluggable databases (PDBs)& /2amine t$e uer* and its output 4$ic$ two tas.s must *ou per%orm to add users wit$ #Y#BAC;P, #Y#D1, and #Y#;6 pri+ilege to t$e password %ile5
A& Assign t$e appropriate operating s*stem groups to #Y#BAC;P, #Y#D1, #Y#;6& B& 1rant #Y#BAC;P, #Y#D1, and #Y#;6 pri+ileges to t$e intended users& C& Re9create t$e password %ile wit$ #Y#BAC;P, #Y#D1, and #Y#;6 pri+ilege and t$e
An application accesses a small loo.up table %reuentl*& You notice t$at t$e reuired data bloc.s are getting aged out o% t$e de%ault bu%%er cac$e& How would *ou guarantee t$at t$e bloc.s %or t$e table ne+er age out5 A& Con%igure Automata #$ared 6emor* 6anagement& B& Con%igure Automatic 6emor* 6anagementC& Con%igure t$e R/CYC0/ bu%%er pool and alter t$e table wit$ t$e corresponding storage clause& D& -ncrease t$e database bu%%er cac$e siFe& /& Con%igure t$e ;//P bu%%er pool and alter t$e table wit$ t$e corresponding storage clause&
You conned using #I0 Plus to t$e root container o% a multitenant container database (CDB) wit$ #Y#DBA pri+ilege& "$e CDB $as se+eral pluggable databases (PDBs) open in t$e read:write mode& "$ere are ongoing transactions in bot$ t$e CDB and PDBs& 4$at $appens alter issuing t$e #H"DO4! "RA!#AC"-O!A0 statement5 A& "$e s$utdown proceeds as soon as all transactions in t$e CDB are eit$er committed or rolled bac.& B& "$e s$utdown proceeds as soon as all transactions in bot$ t$e CDB and PDBs are eit$er committed or rolled bac.& C& "$e statement results in an error because t$ere are open PDBs& D& "$e s$utdown proceeds immediatel*& "$e s$utdown proceeds as soon as all transactions in t$e PDBs are eit$er committed or rolled $ac.&
You are planning t$e creation o% a new multitenant container database (CDB) and want to store t$e ROO" and #//D container data %iles in separate directories& You plan to create t$e database using #I0 statements& 4$ic$ t$ree tec$niues can *ou use to ac$ie+e t$is5 A& #peci%* all %iles in t$e CR/A"/ DA"ABA#/ statement wit$out using Oracle managed
You are about to plug a multi9terab*te non9CDB into an e2isting multitenant container database (CDB)& "$e c$aracteristics o% t$e non9CDB are as %ollows T 3ersion Oracle Database g Release = (&=&'&=&') M@9bit T C$aracter set A0L="
Your database supports an online transaction processing (O0"P) application& "$e application is undergoing some maor sc$ema c$anges, suc$ as addition o% new inde2es and materialiFed +iews& You want to c$ec. t$e impact o% t$ese c$anges on wor.load per%ormance& 4$at s$ould *ou use to ac$ie+e t$is5 A& Database repla* B& #I0 "uning Ad+isor C& #I0 Access Ad+isor D& #I0 Per%ormance Anal*Fer /& Automatic 4or.load Repositor* compare reports
An administrator account is granted t$e CR/A"/ #/##-O! and #/" CO!"A-!/R s*stem pri+ileges& A multitenant container database (CDB) instant $as t$e %ollowing parameter set "HR/AD/D_/8/C"-O!
A& All database operations per%ormed b* t$e impdp command are logged& B& Onl* CR/A"/ -!D/8 and CR/A"/ "AB0/ statements generated b* t$e import are logged& C& Onl* CR/A"/ "AB0/ and A0"/R "AB0/ statements generated b* t$e import are logged& D& !one o% t$e operations against t$e master table used b* Oracle Data Pump to coordinate its acti+ities are logged&
You notice a per%ormance c$ange in *our production Oracle database and *ou want to .now w$ic$ c$ange $as made t$is per%ormance di%%erence& You generate t$e Compare Period Automatic Database Diagnostic 6onitor (ADD6) report to %urt$er in+estigation& 4$ic$ t$ree %indings would *ou get %rom t$e report5 A& -t detects t$e top wait e+ents causing per%ormance degradation& B& -t gi+es in%ormation about statistics collection in bot$ time periods& C& -t s$ows t$e resource usage %or CP, memor*, and -:O in bot$ time periods& D& -t detects an* con%iguration c$ange t$at caused a per%ormance di%%erence in bot$ time periods& /& -t identi%ies an* wor.load c$ange t$at caused a per%ormance di%%erence in bot$ time periods& <& -t s$ows t$e di%%erence in t$e siFe o% memor* pools in bot$ time periods&
/2amine t$e parameter %or *our database instance You generated t$e e2ecution plan %or t$e %ollowing uer* in t$e plan table and noticed t$at t$e nested loop oin was done& A%ter actual e2ecution o% t$e uer*, *ou notice t$at t$e $as$ oin was done in t$e e2ecution plan -denti%* t$e reason w$* t$e optimiFer c$ose di%%erent e2ecution plans&
A& "$e optimiFer used a d*namic plan %or t$e uer*& B& "$e optimiFer c$ose di%%erent plans because automatic d*namic sampling was enabled& C& "$e optimiFer used re9optimiFation cardinalit* %eedbac. %or t$e uer*& D& "$e optimiFer c$ose di%%erent plan because e2tended statistics were created %or t$e columns used&
4$ic$ t$ree statements are true about adapti+e #I0 plan management5 A& -t automaticall* per%orms +eri%ication or e+ol+es non9accepted plans, in CO6PR/H/!#-3/ mode w$en t$e* per%orm better t$an e2isting accepted plans& B& "$e optimiFer alwa*s uses t$e %i2ed plan, i% t$e %i2ed plan e2ists in t$e plan baseline& C& -t adds new, bettor plans automaticall* as %i2ed plans to t$e baseline& D& "$e non9accepted plans are automaticall* accepted and become usable b* t$e optimiFer i% t$e* per%orm better t$an t$e e2isting accepted plans& /& "$e non9accepted plans in a #I0 plan baseline are automaticall* e+ol+ed, in CO6PR/H/!#-3/ mode, during t$e nig$tl* maintenance window and a persistent +eri%ication report is generated&
You create a new pluggable database, HR_PDB, %rom t$e seed database& 4$ic$ t$ree tablespaces are created b* de%ault in HR_PDB5 A& #Y#"/6 B& #/R# C& "/6P D& !DO /& #Y#A8 <& /8A6P0/
4$ic$ two statements are true about +ariable e2tent siFe support %or large A#6 %iles5 A& "$e metadata used to trac. e2tents in #1A is reduced& B& Rebalance operations are completed %aster t$an wit$ a %i2ed e2tent siFe C& An A#6 -nstance automaticall* allocates an appropriate e2tent siFe& D& Res*nc operations are completed %aster w$en a dis. comes online a%ter being ta.en o%%line& /& Per%ormance impro+es in a stretc$ cluster con%iguration b* reading %rom a local cop* o% an e2tent&
You e2ecuted a DROP #/R CA#CAD/ on an Oracle g release database and immediatel* realiFed t$at *ou %orgot to cop* t$e OCA&/8A6_R/#0"# table to t$e OCP sc$ema& "$e R/CYC0/_B-! enabled be%ore t$e DROP #/R was e2ecuted and t$e OCP user $as been granted t$e <0A#HBAC; A!Y "AB0/ s*stem pri+ilege& 4$at is t$e uic.est wa* to reco+er t$e contents o% t$e OCA&/8A6_R/#0"# table to t$e OCP sc$ema5 A& /2ecute <0A#HBAC; "AB0/ OCA&/8A6_R/#0"# "O B/
-n *our multitenant container database (CDB) containing pluggable database (PDBs), t$e HR user e2ecutes t$e %ollowing commands to create and grant pri+ileges on a procedure CR/A"/ OR R/P0AC/ PROC/DR/ create_test_+ (+_emp_id !6B/R, +_ename 3ARCHAR=, +_#A0ARY !6B/R, +_dept_id !6B/R) B/1-! -!#/R" -!"O $r&test 3A0/# (3_emp_id, 3_ename, 3_salar*, 3_dept_id) /!D : 1RA!" /8/C"/ O! CR/A"/_"/#" "O o$n, im, smit$, .ing How can *ou pre+ent users $a+ing t$e /8/C"/ pri+ilege on t$e CR/A"/_"/#" procedure %rom inserting +alues into tables on w$ic$ t$e* do not $a+e an* pri+ileges5 A& Create t$e CR/A"/_"/#" procedure wit$ de%iners rig$ts& B& 1rant t$e /8/C"/ pri+ilege to users wit$ 1RA!" OP"-O! on t$e CR/A"/_"/#" procedure& C& Create t$e CR/A"/_"/#" procedure wit$ in+o.ers rig$ts& D& Create t$e CR/A"/_"/#" procedure as part o% a pac.age and grant users t$e /8/C"/ pri+ilege t$e pac.age&
You created a new database using t$e create database statement wit$out speci%*ing t$e /!AB0/ P011AB0/ clause& 4$at are two e%%ects o% not using t$e /!AB0/ P011AB0/ database clause5 A& "$e database is created as a non9CDB but will become a CDB w$ene+er t$e %irst PDB is plugged in& B& "$e database is created as a non9CDB and can ne+er contain a PDB& C& "$e database is treated as a PDB and must be plugged into an e2isting multitenant container database (CDB)& D& "$e database is created as a non9CDB and can ne+er be plugged into a CDB& /& "$e database is created as a non9CDB but can be plugged into an e2isting CDB&
4$at is t$e e%%ect o% speci%*ing t$e /!AB0/ P011AB0/ DA"ABA#/ clause in a CR/A"/ DA"ABA#/ statement5 A& -t will create a CDB wit$ root opened and seed mounted& B& -t will create a CDB t$at must be plugged into an e2isting CDB& C& -t will create a CDB wit$ root and seed opened and one PDB mounted& D& -t will create a multitenant container database (CDB) wit$ onl* t$e root opened& /& -t will create a CDB wit$ root opened and seed read onl*&
You $a+e installed two M@1 %las$ de+ices to support t$e Database #mart
/2amine t$e %ollowing parameters %or a database instance 4$ic$ t$ree initialiFation parameters are not controlled b* Automatic #$ared 6emor* 6anagement (A#66)5
A& 0O1_B<
/2amine t$e contents o% #I0 loader control %ile 4$ic$ t$ree statements are true regarding t$e #I0Q 0oader operation per%ormed using t$e control %ile5 A& An /6P table is created i% a table does not e2ist& Ot$erwise, i% t$e /6P table is appended wit$ t$e loaded data& B& "$e #I0Q 0oader data %ile m*%ile&dat $as t$e column names %or t$e /6P table& C& "$e #I0Q 0oader operation %ails because no record terminators are speci%ied& D&
-n *our multitenant container database (CDB) containing pluggable database (PDBs), *ou granted t$e CR/A"/ "AB0/ pri+ilege to t$e common user C U U A_AD6-! in root and all PDBs& You e2ecute t$e %ollowing command %rom t$e root container #I0 J R/3O;/ create table
4$ic$ two statements are true concerning t$e Resource 6anager plans %or indi+idual pluggable databases (PDB plans) in a multitenant container database (CDB)5 A& -% no PDB plan is enabled %or a pluggable database, t$en all sessions %or t$at PDB are treated to an eual degree o% t$e resource s$are o% t$at PDB& B& -n a PDB plan, subplans ma* be used wit$ up to eig$t consumer groups& C& -% a PDB plan is enabled %or a pluggable database, t$en resources are allocated to consumer groups across all PDBs in t$e CDB& D& -% no PDB plan is enabled %or a pluggable database, t$en t$e PDB s$are in t$e CDB plan is d*namicall* calculated& /& -% a PDB plan is enabled %or a pluggable database, t$en resources are allocated to consumer groups based on t$e s$ares pro+ided to t$e PDB in t$e CDB plan and t$e s$ares pro+ided to t$e consumer groups in t$e PDB plan&
You use a reco+er* catalog %or maintaining *our database bac.ups& You e2ecute t$e %ollowing command 4$ic$ two statements are true5
A& C$ec.s are per%ormed to con%irm w$et$er all database %iles e2ist in correct locations B& Bac.up sets containing bot$ data %iles and arc$i+e logs are created& C& C$ec.s are per%ormed %or p$*sical corruptions& D& Corrupted bloc.s, i% an*, are repaired& /& C$ec.s are per%ormed %or logical corruptions&
4$ic$ t$ree statements are true concerning t$e multitenant arc$itecture5 A& A PDB can $a+e a pri+ate temp tablespace& B& PDBs can s$are t$e s*sau2 tablespace& C& 0og switc$es occur onl* at t$e multitenant container database (CDB) le+el& D& Di%%erent PDBs can $a+e di%%erent de%ault bloc. siFes& /& PDBs s$are a common s*stem tablespace& <& -nstance reco+er* is alwa*s per%ormed at t$e CDB le+el& 1& /ac$ pluggable database (PDB) $as its own set o% bac.ground processes&
You notice t$at t$e elapsed time %or an important database sc$eduler Sob is unacceptabl* long& "$e ob belongs to a sc$eduler ob class and window& 4$ic$ two actions would reduce t$e obs elapsed time5 A& -ncreasing t$e obs relati+e priorit* wit$in t$e Sob class to w$ic$ it belongs B& -ncreasing t$e priorit* o% t$e sc$eduler window to w$ic$ t$e ob belongs C& -ncreasing t$e +alue o% t$e SOB_I//_PROC/##/# parameter D& -ncreasing t$e resource allocation %or t$e consumer group mapped to t$e sc$eduler obs ob class wit$in t$e plan mapped to t$e sc$eduler window /& -ncreasing t$e priorit* o% t$e ob class to w$ic$ t$e ob belongs <& 6o+ing t$e ob to an e2isting $ig$er priorit* sc$eduler window wit$ t$e same sc$edule and duration
You plan to migrate *our database %rom a
You run a script t$at completes success%ull* using #I0QPlus t$at per%orms t$ese actions &Creates a multitenant container database (CDB) =& Plugs in t$ree pluggable databases (PDBs) L& #$uts down t$e CDB instance @& #tarts up t$e CDB instance using #"AR"P OP/! R/AD 4R-"/ 4$ic$ two statements are true about t$e outcome a%ter running t$e script5 A& "$e PDBs will be opened read:write& B& "$e seed will be in mount state& C& "$e seed will be opened read9onl*& D& "$e seed will be opened read:write& /& "$e ot$er PDBs will be opened read9onl*& <& "$e ot$er PDBs will be in mount state&
You e2ecute t$e %ollowing piece o% code wit$ appropriate pri+ileges ser #CO"" $as been granted t$e CR/A"/ #/##-O! pri+ilege and t$e 61R role& 4$ic$ two statements are true w$en a session logged in as #CO"" ueries t$e #A0 column in t$e +iew and t$e table5
A& Data is redacted %or t$e /6P&#A0 column onl* i% t$e #CO"" session does not $a+e t$e 61R role set& B& Data is redacted %or /6P&#A0 column onl* i% t$e #CO"" session $as t$e 61R role set& C& Data is ne+er redacted %or t$e /6P_3&#A0 column& D& Data is redacted %or t$e /6P_3&#A0 column onl* i% t$e #CO"" session $as t$e 61R role set& /& Data is redacted %or t$e /6P_3&#A0 column onl* i% t$e #CO"" session does not $a+e t$e 61R role set&
Your database is open and t$e 0-#"/!/R listener running& You stopped t$e wrong listener 0-#"/!/R b* issuing t$e %ollowing command snrctl J #"OP 4$at $appens to t$e sessions t$at are presentl* connected to t$e database -nstance5 A& "$e* are not allowed to per%orm an* operations until t$e listener 0-#"/!/R is started& B& "$e* are able to per%orm onl* ueries& C& "$e* are not a%%ected and continue to %unction normall*& D& "$e* are terminated and t$e acti+e transactions are rolled bac.&
4$ic$ t$ree statements are true about using %las$bac. database in a multitenant container database (CDB)5 A& A CDB can be %las$ed bac. speci%*ing t$e desired target point in time or an #C!, but not a restore point& B& "$e DB_<0A#HBAC; R/"/!"-O!_"AR1/" parameter must be set to enable %las$bac. o% t$e CDB& C& -ndi+idual PDBs can be %las$ed bac. wit$out %las$ing bac. t$e entire CDB& D& "$e root container can be %las$ed bac. wit$out %las$ing bac. t$e pluggable databases (PDBs)& /& "o enable %las$bac. database, t$e CDB must be mounted&
You e2ecute t$e %ollowing P0:#I0 4$ic$ two statements are true5
A&
You e2ecute t$e %ollowing commands to audit database acti+ities 4$ic$ statement is true about t$e audit record t$at generated w$en auditing a%ter instance restarts5
A& One audit record is created %or t$e w$ole session i% o$n success%ull* e2ecutes a #/0/C", -!#/R", or D/0/"/ command on a table, and contains t$e e2ecution plan, #I0 te2t, and bind +ariables used& B& One audit record is created %or t$e w$ole session i% SOH! success%ull* e2ecutes a select command, and contains t$e #I0 te2t and bind +ariables used& C& One audit record is created %or e+er* success%ul e2ecution o% a #/0/C", -!#/R" OR D/0/"/ command, and contains t$e e2ecution plan %or t$e #I0 statements& D& One audit record is created %or e+er* success%ul e2ecution o% a #/0/C", -!#/R" OR D/0/"/ command on a table, and contains t$e #I0 te2t %or t$e #I0 #tatements& /& One audit record is created %or t$e w$ole session i% o$n success%ull* e2ecutes a #/0/C", -!#/R", or D/0/"/ command, and contains t$e e2ecution plan %or t$e #I0 statements&
You support Oracle Database =c Oracle Database g, and Oracle Database log on t$e same ser+er& All databases o% all +ersions use Automatic #torage 6anagement (A#6)& 4$ic$ t$ree statements are true about t$e A#6 dis. group compatibilit* attributes t$at are set %or a dis. group5 A& RDB6# compatibilit* toget$er wit$ t$e database +ersion determines w$et$er a database -nstance can mount t$e A#6 dis. group& B& "$e RDB6# compatibilit* setting allows onl* databases set to t$e same +ersion as t$e compatibilit* +alue, to mount t$e A#6 dis. group& C& "$e A#6 compatibilit* attribute determines some o% t$e A#6 %eatures t$at ma* be used b* t$e Oracle dis. group& D& "$e AD36 compatibilit* attribute determines t$e AC<# %eatures t$at ma* be used b* t$e Oracle ' g database& /& "$e A#6 compatibilit* attribute controls t$e %ormat o% t$e dis. group metadata&
"o enable t$e Database #mart
A& -t results in an error because t$ese parameter settings are in+alid& B& One M@1 %las$ cac$e %ile will be used& C& "wo M@1 %las$ cac$e %iles will be used& D& "wo L=1 %las$ cac$e %iles will be used&
You e2ecuted t$is command to create a password %ile 7 orapwd %ile orapworcl entries ' ignorecase ! 4$ic$ two statements are true about t$e password %ile5 A& -t will permit t$e use o% uppercase passwords %or database users w$o $a+e been granted t$e #Y#OP/R role& B& -t will not permit t$e use o% mi2ed case passwords %or t$e database users w$o $a+e been granted t$e #Y#DBA role& C& -t will permit t$e use o% lowercase passwords %or database users w$o $a+e granted t$e #Y#DBA role& D& -t contains username and passwords o% database users w$o are members o% t$e O#OP/R operating s*stem group& /& -t contains usernames and passwords o% database users w$o are members o% t$e O#DBA operating s*stem group&
-denti%* t$ree +alid met$ods o% opening, pluggable databases (PDBs)& A& A0"/R P011AB0/ DA"ABA#/ OP/! A00 -##/D %rom t$e root B& A0"/R P011AB0/ DA"ABA#/ OP/! A00 -##/D %rom a PDB C& A0"/R P011AB0/ DA"ABA#/ PDB OP/! issued %rom t$e seed D& A0"/R DA"ABA#/ PDB OP/! issued %rom t$e root /& A0"/R DA"ABA#/ OP/! issued %rom t$at PDB <& A0"/R P011AB0/ DA"ABA#/ PDB OP/! issued %rom anot$er PDB 1& A0"/R P011AB0/ DA"ABA#/ OP/! issued %rom t$at PDB
You administer an online transaction processing (O0"P) s*stem w$ose database is stored in Automatic #torage 6anagement (A#6) and w$ose dis. group use normal redundanc*& One o% t$e A#6 dis.s goes o%%line, and is t$en dropped because it was not broug$t online be%ore D-#;_R/PA-R_"-6/ elapsed& 4$en t$e dis. is replaced and added bac. to t$e dis. group, t$e ensuing rebalance operation is too slow& 4$ic$ two recommendations s$ould *ou ma.e to speed up t$e rebalance operation i% t$is t*pe o% %ailure $appens again5 A& #et t$e D-#;_R/PA-R_"-6/ dis. attribute to a lower +alue& B& -ncrease t$e number o% DB4R_-O_#0A3/# in t$e A#6 instance& C& -ncrease t$e number o% A#6B processes& D& -ncrease t$e +alue o% t$e A#6_PO4/R_0-6-" parameter& /& #peci%* t$e statement t$at adds t$e dis. bac. to t$e dis. group&
You are administering a database and *ou recei+e a reuirement to appl* t$e %ollowing restrictions & A connection must be terminated a%ter %our unsuccess%ul login attempts b* user& =& A user s$ould not be able to create more t$an %our simultaneous sessions& L& ser session must be terminated a%ter > minutes o% inacti+it*& @& sers must be prompted to c$ange t$eir passwords e+er* > da*s& How would *ou accomplis$ t$ese reuirements5 A& b* granting a secure application role to t$e users B& b* creating and assigning a pro%ile to t$e users and setting t$e R/6O"/_O#_A"H/!" parameter to
A senior DBA as.ed *ou to e2ecute t$e %ollowing command to impro+e per%ormance #I0J A0"/R "AB0/ subscribe log #"ORA1/ (B<
4$ic$ t$ree tas.s can be automaticall* per%ormed b* t$e Automatic Data OptimiFation %eature o% -n%ormation li%ec*cle 6anagement (-06)5 A& "rac.ing t$e most recent read time %or a table segment in a user tablespace B& "rac.ing t$e most recent write time %or a table segment in a user tablespace C& "rac.ing insert time b* row %or table rows D& "rac.ing t$e most recent write time %or a table bloc. /& "rac.ing t$e most recent read time %or a table segment in t$e #Y#A8 tablespace <& "rac.ing t$e most recent write time %or a table segment in t$e #Y#A8 tablespace
4$ic$ two partitioned table maintenance operations support as*nc$ronous 1lobal -nde2 6aintenance in Oracle database =c5 A& A0"/R "AB0/ DROP PAR"-"-O! B& A0"/R "AB0/ ADD PAR"-"-O! C& A0"/R "AB0/ 6O3/ PAR"-"-O! D& A0"/R "AB0/ 6/R1/ PAR"-"-O! /& A0"/R "AB0/ #P0-" PAR"-"-O! <& A0"/R "AB0/ "R!CA"/ PAR"-"-O!
You con%igure *our database -nstance to support s$ared ser+er connections& 4$ic$ two memor* areas t$at are part o% P1A are stored in #1A instead, %or s$ared ser+er connection5 A& 0ocation o% a part o% t$e runtime area %or #/0/C" statements B& ser session data C& #tac. space D& Pri+ate #I0 area /& 0ocation o% t$e runtime area %or D60 and DD0 #tatements
4$ic$ two statements are true about Oracle 6anaged
4$ic$ t$ree actions are possible during an Online Data %ile 6o+e operation5 A& Per%orming Bloc. 6edia Reco+er* %or a data bloc. in t$e data %ile being mo+ed B&
Your multitenant container database (CDB) contains a pluggable database, HR_PDB& "$e de%ault permanent tablespace in HR_PDB is #/RDA"A& "$e container database (CDB) is open and *ou connect R6A!& You want to issue t$e %ollowing R6A! command R6A! J BAC;P "AB0/#PAC/ $r_pdbuserdata 4$ic$ tas. s$ould *ou per%orm be%ore issuing t$e command5 A& Place t$e root container in ARHCH-3/0O1 mode& B& "a.e t$e user data tablespace o%%line& C& Place t$e root container in t$e nomount stage& D& /nsure t$at HR_PDB is open&
-denti%* t$ree scenarios in w$ic$ *ou would recommend t$e use o% #I0 Per%ormance Anal*Fer to anal*Fe impact on t$e per%ormance o% #I0 statements& A& C$ange in t$e Oracle Database +ersion B& Database and operating s*stem upgrade C& 6igration o% database storage %rom non9A#6 to A#6 storage D& C$ange in *our networ. in%rastructure /& C$ange in t$e $ardware con%iguration o% t$e database ser+er
4$ic$ two statements are true about t$e R6A! +alidate database command5 A& -t c$ec.s t$e database %or intrabloc. corruptions& B& -t can detect corrupt p%iles& C& -t can detect corrupt sp%iles& D& -t c$ec.s t$e database %or interbloc. corruptions& /& -t can detect corrupt bloc. c$ange trac.ing %iles&
You install a non9RAC Oracle Database& During -nstallation, t$e Oracle ni+ersal -nstaller (O-) prompts *ou to enter t$e pat$ o% t$e -n+entor* director* and also to speci%* an operating s*stem group name& 4$ic$ statement is true5 A& "$e operating s*stem group t$at is speci%ied must $a+e permission to write to t$e in+entor* director*& B& "$e ORAC0/_BA#/ base parameter is not set& C& "$e installation is being per%ormed b* t$e root user& D& "$e operating s*stem group t$at is speci%ied s$ould $a+e t$e root user as its member&
You are reuired to migrate *our &=&'&L database as a pluggable database (PDB) to a multitenant container database (CDB)& "$e %ollowing are t$e possible steps to accomplis$ t$is tas. & Place all t$e user9de%ined tablespace in read9onl* mode on t$e source database& =& pgrade t$e source database to a =c +ersion& L& Create a new PDB in t$e target container database& @& Per%orm a %ull transportable e2port on t$e source database wit$ t$e 3/R#-O! parameter set to = using t$e e2pdp utilit*& >& Cop* t$e associated data %iles and e2port t$e dump %ile to t$e desired location in t$e target database& M& -n+o.e t$e Data Pump import utilit* on t$e new PDB database as a user wit$ t$e DA"AP6P_-6P_<00_DA"ABA#/ role and speci%* t$e %ull transportable import options& E& #*nc$roniFe t$e PDB on t$e target container database b* using t$e DB6#_PD#&#Y!C_ODB %unction& -denti%* t$e correct order o% t$e reuired steps& A& , >, M, @, L, = B& =, , L, @, >, M, E C& , @, L, >, M, E D& =, , L, @, >, M /& , L, @, >, M, E
-n *our multitenant container database (CDB) wit$ two pluggable database (PDBs)& You want to create a new PDB b* using #I0 De+eloper& 4$ic$ statement is true5 A& "$e CDB must be open& B& "$e CDB must be in t$e mount stage& C& "$e CDB must be in t$e nomount stage& D& Alt e2isting PDBs must be closed&
4$ic$ two statements are true about t$e Oracle Direct !etwor.
/2amine t$e parameters %or *our database instance 4$ic$ t$ree statements are true about t$e process o% automatic optimiFation b* using cardinalit* %eedbac.5
A& A%ter t$e optimiFer identi%ies a uer* as a re9optimiFation candidate, statistics collected b* t$e collectors are submitted to t$e optimiFer& B& "$e optimiFer automaticall* c$anges a plan during subseuent e2ecution o% a #I0 statement i% t$ere is a $uge di%%erence in optimiFer estimates and e2ecution statistics& C& "$e optimiFer can re optimiFe a uer* onl* once using cardinalit* %eedbac.& D& "$e optimiFer enables monitoring %or cardinalit* %eedbac. a%ter t$e %irst e2ecution o% a uer*& /& "$e optimiFer does not monitor cardinalit* %eedbac. i% d*namic sampling and multicolumn statistics are enabled&
4$ic$ t$ree statements are true w$en t$e listener $andles connection reuests to an Oracle =c database instance wit$ multit$readed arc$itecture enabled -n !-85 A& /ac$ multit$readed Oracle process $as an #C6! t$read& B& /ac$ Oracle process runs an #C6! t$read& C& "$read creation must be routed t$roug$ a dispatc$er process D& "$e local listener ma* pass t$e reuest to an e2isting process w$ic$ in turn will create a t$read& /& "$e local listener ma* spawn a now process and $a+e t$at new process create a t$read
4$ic$ t$ree operations can be per%ormed as multipartition operations in Oracle5 A& 6o+e partitions o% a range9partitioned table B& Rename partitions o% a range partitioned table C& 6erge partitions o% a re%erence partitioned inde2 D& Coalesce partitions o% a $as$9partitioned global inde2& /& 6erge partitions o% a list partitioned table <& Drop partitions o% a list partitioned table
You are connected using #I0Q Plus to a multitenant container database (CDB) wit$ #Y#DBA pri+ileges and e2ecute t$e %ollowing seuence statements 4$at is t$e result o% t$e last #/" CO!"A-!/R statement and w$* is it so5
A& -t succeeds because t$e PDB_AD6-! user $as t$e reuired pri+ileges& B& -t %ails because common users are unable to use t$e #/" CO!"A-!/R statement& C& -t %ails because local users are unable to use t$e #/" CO!"A-!/R statement& D& -% %ails because t$e #/" CO!"A-!/R statement cannot be used wit$ PDB7#//D as t$e target pluggable database (PDB)&
/2amine t$e details o% t$e "op > "imed /+ents in t$e %ollowing Automatic 4or.loads Repositor* (A4R) report 4$at are t$ree possible causes %or t$e latc$9related wait e+ents5
A& "$e siFe o% t$e s$ared pool is too small& B& "$e bu%%ers are being read into t$e bu%%er cac$e, but some ot$er session is c$anging t$e bu%%ers& C& "$ere are %reuent logons and logo%%s& D& Cursors are not being s$ared& /& A large number CO66-"# are being per%ormed&
You enabled an audit polic* b* issuing t$e %ollowing statements
A& #Y#, #Y#"/6 B& #CO"" C& Onl* %or success%ul e2ecutions D& Onl* %or %ailed e2ecutions /& Bot$ success%ul and %ailed e2ecutions
A redaction polic* was added to t$e #A0 column o% t$e #CO""&/6P table All users $a+e t$eir de%ault set o% s*stem pri+ileges&
A& #CO"" sessions, because $e is t$e owner o% t$e table B& #Y#"/6 session, onl* i% t$e 61R role is set in t$e session C& #CO"" sessions, onl* i% t$e 61R role is granted to #CO"" D& #CO"" sessions, onl* i% t$e 61R role is set in t$e session /& #Y#"/6 sessions, regardless o% t$e roles t$at are set in t$e session <& #Y# sessions, regardless o% t$e roles t$at are set in t$e session
4$at is t$e result o% e2ecuting a "R!CA"/ "AB0/ command on a table t$at $as M' -n+alid DD0 statement on $istor*9trac.ed message
4$ic$ t$ree acti+ities are supported b* t$e Data Reco+er* Ad+isor5 A& Ad+ising on in+alid bloc. $eader %ield +alues B& Ad+ising on bloc. c$ec.sum %ailures C& Ad+ising on inaccessible control %iles D& Ad+ising on inaccessible bloc. c$ange trac.ing %iles /& Ad+ising on empt* password %iles
You create a table wit$ t$e P/R-OD
A& #etting t$e session +alid time using DB6#_<0A#HBAC;_ARCH-3/&/!AB0/_A"_3A0-D_"-6/ sets t$e +isibilit* %or data manipulation language (D60), data de%inition language (DD0), and ueries per%ormed b* t$e session& B& "$e +alid time columns are +isible b* de%ault w$en t$e table is described& C& "$e +alid time columns emplo*ee_time_start and emplo*ee_time_end are automaticall* created& D& "$e same statement ma* %ilter on bot$ transaction time and +alid temporal time b* using t$e A# O< "-6/#"A6P and P/R-OD
4$ic$ t$ree statements are true regarding t$e use o% t$e Database 6igration Assistant %or nicode (D6)5 A& A DBA can c$ec. speci%ic tables wit$ t$e D6 B& "$e database to be migrated must be opened read9onl*& C& "$e release o% t$e database to be con+erted can be an* release since &=&'&?& D& "$e D6 can report columns t$at are too long in t$e con+erted c$aracterset& /& "$e D6 can report columns t$at are not represented in t$e con+erted c$aracterset&
Oracle 1rid -n%rastructure %or a stand9alone ser+er is installed on *our production $ost be%ore installing t$e Oracle Database ser+er& "$e database and listener are con%igured b* using Oracle Restart& /2amine t$e %ollowing command and its output 7 crsctl con%ig $as CR#9@M== Oracle Hig$ A+ailabilit* #er+ices auto start is enabled& 4$at does t$is impl*5 A& 4$en a database instance is started b* using t$e #R3C"0 utilit* and listener startup %ails, t$e instance is still started& B& 4$en a database is created b* using #I0Q Plus, it is automaticall* added to t$e Oracle Restart con%iguration& C& 4$en *ou start an instance on a $ig$ wit$ #I0 QPlus dependent listeners and A#6 dis. groups are automaticall* started& D& 4$en *ou create a database ser+ice b* modi%*ing t$e #/R3-C/_!A6/# initialiFation parameter, it is automaticall* added to t$e Oracle Restart con%iguration&
Your multitenant container database (CDB) contains some pluggable databases (PDBs), *ou e2ecute t$e %ollowing command in t$e root container 4$ic$ two statements are true5
A& #c$ema obects owned b* t$e CU U A_AD6-! common user can be s$ared across all PDBs& B& "$e C U U A_AD6-! user will be able to use t$e "/6P_"# temporar* tablespace onl* in root& C& "$e command will, create a common user w$ose description is contained in t$e root and eac$ PDB& D& "$e sc$ema %or t$e common user C U U A_AD6-! can be di%%erent in eac$ container& /& "$e command will create a user in t$e root container onl* because t$e container clause is not used&
You per%ormed an incremental le+el ' bac.up o% a database "o enable bloc. c$ange trac.ing a%ter t$e incremental le+el ' bac.up, *ou issued t$is command "o per%orm an incremental le+el cumulati+e bac.up, *ou issued t$is command 4$ic$ t$ree statements are true5
A& Bac.up c$ange trac.ing will sometimes reduce -:O per%ormed during cumulati+e incremental bac.ups& B& "$e incremental le+el bac.up t$at immediatel* %ollows t$e enabling o% bloc. c$ange trac.ing will not read t$e c$ange trac.ing %ile to disco+er c$anged bloc.s& C& 6ore t$an one database bloc. ma* be read b* an incremental bac.up %or a c$ange made to a single bloc.& D& "$e c$ange trac.ing %ile must alwa*s be bac.ed up w$en *ou per%orm a %ull database bac.up& /& Bloc. c$ange trac.ing will alwa*s reduce -:O per%ormed during cumulati+e incremental bac.ups&
You %ind t$is uer* being used in *our Oracle =c database 4$ic$ met$od a used b* t$e optimiFer to limit t$e rows being returned5
A& A %ilter is added to t$e table uer* d*namicall* using RO4!6 to limit t$e rows to =' percent o% t$e total rows B& All t$e rows are returned to t$e client or middle tier but onl* t$e %irst =' percent are returned to t$e screen or t$e application& C& A +iew is created during e2ecution and a %ilter on t$e +iew limits t$e rows to =' percent o% t$e total rows& D& A "OP9! uer* is created to limit t$e rows to =' percent o% t$e total rows
4$ic$ t$ree resources mig$t be prioritiFed between competing pluggable databases w$en creating a multitenant container database plan (CDB plan) using Oracle Database Resource 6anager5 A& 0ocal %ile s*stem -:O B& 6a2imum ndo per consumer group C& 6a2imum -dle time D& Parallel ser+er limit /& CP <& /2adata -:O
You created an encr*pted tablespace You t$en closed t$e encr*ption wallet because *ou were ad+ised t$at t$is is secure& 0ater in t$e da*, *ou attempt to create t$e /6P0OY//# table in t$e #/CR/#PAC/ table space wit$ t$e #A0" option on t$e /6P0OY// column& 4$ic$ is true about t$e result5
A& -t generates error w$en creating t$e table, because t$e salt option cannot be used wit$ encr*pted tablespaces& B& -t creates t$e table success%ull*, and encr*pts an* inserted data in t$e /6P!A6/ column because t$e wallet needs to be open onl* %or tablespace creation& C& -t creates t$e table success%ull* but does not encr*pt an* inserted data in t$e /6P!A6/ column because t$e wallet must be opened to encr*pt columns wit$ #A0"& D& -t generates an error w$en creating t$e table because t$e wallet is closed&
You created an encr*pted tablespace You t$en closed t$e encr*ption wallet because *ou were ad+ised t$at t$is is secure& 0ater in t$e da*, *ou attempt to create t$e /6P0OY//# table in t$e #/CR/#PAC/ table space wit$ t$e #A0" option on t$e /6P0OY// column& 4$ic$ is true about t$e result5
A& -t generates error w$en creating t$e table, because t$e salt option cannot be used wit$ encr*pted tablespaces& B& -t creates t$e table success%ull*, and encr*pts an* inserted data in t$e /6P!A6/ column because t$e wallet needs to be open onl* %or tablespace creation& C& -t creates t$e table success%ull* but does not encr*pt an* inserted data in t$e /6P!A6/ column because t$e wallet must be opened to encr*pt columns wit$ #A0"& D& -t generates an error w$en creating t$e table because t$e wallet is closed&
On *our Oracle Database, *ou issue t$e %ollowing commands to create inde2es 4$ic$ two statements are true5
A& Onl* t$e ORD_C#"O6/R_-8 inde2 created& B& Bot$ t$e inde2es are updated w$en a row is inserted, updated, or deleted in t$e ORD/R# table& C& Bot$ t$e inde2es are created $owe+er, onl* ORD_C#"O6/R#_-8 is used b* t$e optimiFer %or ueries on t$e ORD/R# table& D& "$e ORD_C#"O6/R_-8 inde2 is not used b* t$e optimiFer e+en w$en t$e OP"-6-G/R_#/_-!3-#-B0/_-!D/8/# parameters is set to true& /& Bot$ t$e inde2es are created and used b* t$e optimiFer %or ueries on t$e ORD/R# table& <& Bot$ t$e inde2es are created $owe+er, onl* ORD_C#"O6/R#_-8= is used b* t$e optimiFer %or ueries on t$e ORD/R# table&
4$ic$ two statements are true w$en row arc$i+al management is enabled5 A& "$e ORA_ARCH-3/_#"A"/ column is +isible i% re%erenced in t$e select list o% a uer*& B& "$e ORA_ARCH-3/_#"A"/ column is updated automaticall* b* t$e Oracle #er+er based on acti+it* trac.ing columns, to -ndicate t$at a row is no longer considered acti+e& C& "$e ORA_ARCH-3/_#"A"/ column +isibilit* is controlled b* t$e RO4 ARCH-3A0 3-#-B-0-"Y session parameter& D& "$e RO4 ARCH-3A0 3-#-B-0-"Y session parameter de%aults to acti+e rows onl*& /& "$e ORA_ARCH-3/_#"A"/ column is updated manuall* or b* a program t$at could re%erence acti+it* trac.ing columns, to indicate t$at a row is no longer considered acti+e&
A ware$ouse %act table in *our Oracle =c Database is range9partitioned b* mont$ and accessed %reuentl* wit$ ueries t$at span multiple partitions "$e table $as a local pre%i2ed, range partitioned inde2& #ome o% t$ese ueries access +er* %ew rows in some partitions and all t$e rows in ot$er partitions, but t$ese ueries still per%orm a %ull scan %or all accessed partitions& "$is commonl* occurs w$en t$e range o% dates begins at t$e end o% a mont$ or ends close to t$e start o% a mont$& You want an e2ecution plan to be generated t$at uses inde2ed access w$en onl* a %ew rows are accessed %rom a segment, w$ile still allowing %ull scans %or segments w$ere man* rows are returned& 4$ic$ t$ree met$ods could transparentl* $elp to ac$ie+e t$is result5 A& sing a partial local -nde2 on t$e ware$ouse %act table mont$ column wit$ inde2ing disabled to t$e table partitions t$at return most o% t$eir rows to t$e ueries& B& sing a partial local -nde2 on t$e ware$ouse %act table mont$ column wit$ inde2ing disabled %or t$e table partitions t$at return a %ew rows to t$e ueries& C& sing a partitioned +iew t$at does a !-O! A00 uer* on t$e partitions o% t$e ware$ouse %act table, w$ic$ retains t$e e2isting local partitioned column& D& Con+erting t$e partitioned table to a partitioned +iew t$at does a !-O! A00 uer* on t$e mont$l* tables, w$ic$ retains t$e e2isting local partitioned column& /& sing a partial global inde2 on t$e ware$ouse %act table mont$ column wit$ inde2ing disabling %or t$e table partitions t$at return most o% t$eir rows to t$e ueries& <& sing a partial global inde2 on t$e ware$ouse %act table mont$ column wit$ inde2ing disabled %or t$e table partitions t$at return a %ew rows to t$e ueries&
You use t$e segment ad+isor to $elp determine obects %or w$ic$ space ma* be reclaimed& 4$ic$ t$ree statements are true about t$e ad+isor gi+en b* t$e segment ad+isor5 A& -t ma* ad+ise t$e use o% online table rede%inition %or tables in dictionar* managed tablespace& B& -t ma* ad+ise t$e use o% segment s$rin. %or %ree list managed tables& C& -t will detect and ad+ise about c$ained rows& D& -t ma* ad+ise t$e use o% segment s$rin. %or tables in dictionar* managed tablespaces it t$e no c$ained rows& /& -t ma* ad+ise t$e use o% online table rede%inition %or tables in locall* managed tablespaces
You $a+e altered a non9uniue inde2 to be in+isible to determine i% ueries e2ecute wit$in an acceptable response time wit$out using t$is inde2& 4$ic$ two are possible i% table updates are per%ormed w$ic$ a%%ect t$e in+isible inde2 columns5 A& "$e inde2 remains in+isible& B& "$e inde2 is not updated b* t$e D60 statements on t$e inde2ed table& C& "$e inde2 automaticall* becomes +isible in order to $a+e it updated b* D60 on t$e table& D& "$e inde2 becomes unusable but t$e table is updated b* t$e D60& /& "$e inde2 is updated b* t$e D60 on t$e table&
-n *our multitenant container database (CDB) containing same pluggable databases (PDBs), *ou e2ecute t$e %ollowing commands in t$e root container 4$ic$ two statements are true5
A& "$e statement %or granting a role to a user %ails because t$e CO!"A-!/R clause is not used& B& Pri+ileges are granted to t$e CUUA_AD6-! user in t$e root database and all PDBs& C& "$e C U U RO0/ role is created onl* in t$e root database because t$e container clause is not used& D& "$e C U U RO0/ role is created in t$e root database and all t$e PDBs& /& Pri+ileges are granted to t$e CUUA_AD6-! user onl* in t$e root database&
"$e persistent con%iguration settings %or R6A! $a+e de%ault %or all parameters& -denti%* %our R6A! commands t$at produce a multi9section bac.up& A& BAC;P "AB0/#PAC/ #Y#"/6 #/C"-O! #-G/ ''6 B& BAC;P A# COPY "AB0/#PAC/ #Y#"/6 #/C"-O! #-G/ ''6 C& BAC;P ARCH-3/0O1 A00 #/C"-O! #-G/ =>6 D& BAC;P "AB0/#PAC/ "/6P #/C"-O! #-G/ '6 /& BAC;P "AB0/#PAC/ !DO -!C0D/ CRR/!" CO!"RO0<-0/ #/C"-O! #-G/ ''6 <& BAC;P #P<-0/ #/C"-O! #-G/ 6 1& BAC;P -!CR/6/!"A0 0/3/0 ' "AB0/#PAC/ #Y#A8 #/C"-O! #-G/ ''6
A& Onl* B& and = C& L and D& Onl* = /& Onl* L
/2amine t$e commands e2ecuted to monitor database operations 4$ic$ two statements are true5
A& Database operations will be monitored onl* w$en t$e* consume a signi%icant amount o% resource& B& Database operations %or all sessions will be monitored& C& Database operations will be monitored onl* i% t$e #"A"-#"-C#_0/3/0 parameter is set to "YP-CA0 and CO!"RO0_6A!A1/6/!"_PAC;_ACC/## is set D-A1!-#"-C "!-!1& D& Onl* D60 and DD0 statements will be monitored %or t$e session& /& All subseuent statements in t$e session will be treated as one database operation and will be monitored&
4$ic$ two statements are true about t$e wor.ing o% s*stem pri+ileges in a multitenant control database (CDB) t$at $as pluggable databases (PDBs)5 A& Common users connected to a PDB can e2ercise pri+ileges across ot$er PDBs& B& #*stem pri+ileges wit$ t$e wit$ grant option container all clause must be granted to a common user be%ore t$e common user can grant pri+ileges to ot$er users& C& 0ocal users cannot use local s*stem pri+ileges on t$e sc$ema o% a common user& D& #*stem pri+ileges appl* onl* to t$e PDB in w$ic$ t$e* are used& /& "$e granter o% s*stem pri+ileges must possess t$e set container pri+ilege&
You are about to plug a multi9terab*te non9CDB into an e2isting multitenant container database (CDB) as a pluggable database (PDB)& T "$e c$aracteristics o% t$e non9CDB are as %ollows T 3ersion Oracle Database =c Releases M@9bit T C$aracter set 4/?-#O??>P> T !ational c$aracter set A0M"<M T O:# Oracle 0inu2 M M@9bit "$e c$aracteristics o% t$e CDB are as %ollows T 3ersion Oracle Database =c Release M@9bit T C$aracter set A0L="
Your database $as t$e #R3 ser+ice con%igured %or an application t$at runs on middle9tier application ser+er& "$e application $as multiple modules& You enable tracing at t$e ser+ice le+el b* e2ecuting t$e %ollowing command #I0 J e2ec DB6#_6O!-"OR&#/R3_6OD_AC"_"RAC/_/!AB0/ (N#R3) "$e possible outcome and actions to aggregate t$e trace %iles are as %ollows & "$e command %ails because a module name is not speci%ied& =& A trace %ile is created %or eac$ session t$at is running t$e #R3 ser+ice& L& An aggregated trace %ile is created %or all t$e sessions t$at are running t$e #R3 ser+ice& @& "$e trace %iles ma* be aggregated b* using t$e trcess utilit*& >& "$e trace %iles be aggregated b* using t$e t.pro% utilit*& -denti%* t$e correct outcome and t$e step to aggregate b* using t.pro% utilit*5 A& L and > B& C& = and @ D& = and > /& L and @
Your multitenant container database (CDB) contains pluggable databases (PDBs), *ou are connected to t$e HR_PDB& You e2ecute t$e %ollowing command #I0 J CR/A"/ !DO "AB0/#PAC/ undotb' DA"A<-0/ Nu':oracle:rddb:undotbs'&db% #-G/ M'6 A"O/8"/!D O! 4$at is t$e result5 A& -t e2ecutes success%ull* but neit$er tablespace nor t$e data %ile is created& B& -t %ails and reports an error because t$e CO!"A-!/RCRR/!" clause is not speci%ied in t$e command& C& -t %ails and reports an error because t$e CO!"A-!/RA00 clause is not speci%ied in t$e command& D& -t e2ecutes success%ull* and creates an !DO tablespace in HR_PDB& /& -t %alls and reports an error because t$ere can be onl* one undo tablespace in a CDB&
4$ic$ t$ree statements are true about #I0 plan directi+es5 A& "$e* are tied to a speci%ic statement or #I0 -D& B& "$e* instruct t$e maintenance ob to collect missing statistics or per%orm d*namic sampling to generate a more optimal plan& C& "$e* are used to gat$er onl* missing statistics& D& "$e* are created %or a uer* e2pression w$ere statistics are missing or t$e cardinalit* estimates b* t$e optimiFer are incorrect& /& "$e* instruct t$e optimiFer to create onl* column group statistics& <& -mpro+e plan accurac* b* persisting bot$ compilation and e2ecution statistics in t$e #Y#A8 tablespace&
You want to %las$ bac. a test database b* %i+e $ours& You issue t$is command #I0 J <0A#HBAC; DA"ABA#/ "O "-6/#"A6P (#Y#DA"/ T >:=@) 4$ic$ two statements are true about t$is %las$bac. scenario5 A& "$e database must $a+e multiple2ed redo logs %or t$e %las$bac. to succeed& B& "$e database must be opened in read9onl* mode to c$ec. i% t$e database $as been %las$ed bac. to t$e correct #C!& C& "$e database must be opened wit$ t$e R/#/"0O1# option a%ter t$e %las$bac. is complete& D& "$e database must be 6O!"/D %or t$e %las$bac. to succeed& /& "$e database must use bloc. c$ange trac.ing %or t$e %las$bac. to succeed& <& "$e database must be opened in restricted mode %or t$e %las$bac. to succeed&
/2amine t$ese two statements 4$ic$ t$ree are true about t$e 6R;" tablespace5
A& "$e 6R;" tablespace is created as a small %ile tablespace, because t$e %ile siFe is less t$an t$e minimum reuired %or big %ile %iles& B& "$e 6R;" tablespace ma* be dropped i% it $as no contents& C& sers w$o were using t$e old de%ault tablespace will $a+e t$eir de%ault tablespaces c$anged to t$e 6R;" tablespace& D& !o more data %iles can be added to t$e tablespace& /& "$e relati+e %ile number o% t$e tablespace is not stored in rowids %or t$e table rows t$at are stored in t$e 6R;" tablespace&
-n *our database, *ou want to ensure t$at idle sessions t$at are bloc.ing acti+e are automaticall* terminated a%ter a speci%ied period o% time& How would *ou accomplis$ t$is5 A& Decreasing t$e +alue o% t$e -D0/_"-6/ resource limit in t$e de%ault pro%ile B& #etting a metric t$res$old C& -mplementing Database Resource 6anager D& /nabling resumable timeout %or user sessions
You /2ecute t$e ignorecase ! %ormat = 4$ic$ two statements are true about t$e password %ile5 A& -t supports t$e #Y#BAC;P, #Y#D1, and #Y#;6 s*stem pri+ileges& B& -t records t$e usernames and passwords o% all users w$en t$e* are added to t$e O#DBA or O#OP/R operating s*stem groups& C& -s used b* Oracle to aut$enticate users %or remote database administration& D& -t records t$e usernames and passwords o% users w$en granted t$e DBA role& /& -t contains t$e usernames and passwords o% users %or w$om auditing is enabled&
-denti%* two situations in w$ic$ t$e alert log %ile is updated& A& Rebuilding an inde2 using A0"/R -!D/8 & & & R/B-0D %ails wit$ an ORA9'>E? ORAC0/ data bloc. corrupted (%ile U @, bloc. U >') error& B& Running a uer* on a table returns ORA9M'' -nternal /rror& C& -nserting a +alue into a table returns ORA9'E== in+alid number& D& Creating a table returns ORA9''>> name us alread* in used b* an e2isting obects& /& -nserting a +alue into a table returns ORA9'''' uniue constraint (#Y#&O;_"/CHP) +iolated&
4$ic$ two statements are true about Oracle Data Pump e2port and import operations5 A& You can detac$ %rom a data pump import ob and reattac$ later& B& "$e master table is t$e last obect to be e2ported b* t$e data pump& C& You can detac$ %rom a data pump e2port ob and reattac$ later& D& Data pump uses parallel e2ecution ser+er processes to implement parallel import& /& Data pump import reuires t$e import %ile to be in a director* owned b* t$e oracle owner&
/2amine t$e uer* and its output e2ecuted -n an RDB6# -nstance 4$ic$ t$ree statements are true about t$e users (ot$er t$an s*s) in t$e output5
A& "$e C U U B_AD6-! user can per%orm all bac.up and reco+er* operations using R6A! onl*& B& "$e C U U C_AD6-! user can per%orm t$e data guard operation wit$ Data 1uard Bro.er& C& "$e C U U A_AD6-! user can per%orm wallet operations& D& "$e C U U D_AD6-! user can per%orm bac.up and reco+er* operations %or Automatic #torage 6anagement (A#6)& /& "$e C U U B_AD6-! user can per%orm all bac.up and reco+er* operations using R6A! or #I0Q Plus&
-n *our Database, t$e "B# P/RC/!" #/D parameter is set to M' and t$e "B# P/RC/!"
