A.by using triggersB.by using external tablesC.by using……

单项选择题Asaresultofperformanceanalysis，youcreatedanindexontheprod_namecolumnoftheprod_dettable，whichcontainsabouttenthousandrows.Later，youupdatedaproductnameinthetable.Howdoesthischangeaffecttheindex？（）

A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates.

多项选择题WhichtwostatementsaboutFlashbackQueryaretrue？（）

A.It is generated by using the redo log files. 
B.It helps in row-level recovery from user errors.
C.It can be performed to recover ALTER TABLE statements 
D.It fails when undo data pertaining to the transaction is overwritten.
E.The database has to be opened with the resetlogs option after performing Flashback Query.

单项选择题WhilesettingupanOracledatabaseforoneofyourcriticalapplications，youwanttoensurethatthedatabaseisbackedupatregularintervalswithoutyourintervention.Whatshouldyoudotoachievetheobjective？（）

A.configure the database to run in ARCHIVELOG mode
B.configure the Flash Recovery Area to enable automatic database backup
C.schedule the database backup using DBMS_JOB package after creating the database
D.schedule the database backup using Recovery Manager （RMAN）commands after creating the database
E.schedule the database backup using Database Configuration Assistant （DBCA）while creating the database

单项选择题AusercomplainsthathegetsthefollowingerrormessagerepeatedlyafterexecutingsomeSQLstatements.Theerrormessageforcestheusertologofffromandlogontothedatabasetocontinuehiswork.ORA-02392：exceededsessionlimitonCPUusage，youarebeingloggedoffWhichactionwouldyoutaketoincreasethesessionlimitonCPUusage？（）

A.Modify the profile assigned to the user.
B.Modify the roles assigned to the users.
C.Modify the object privileges assigned to the user.
D.Modify the system privileges assigned to the users.
E.Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

单项选择题YoufindthatthedatabaseperformancedegradeswhileyoubackupthePRODdatabaseusingRecoveryManager（RMAN）.ThePRODdatabaseisrunninginsharedservermode.Thedatabaseinstanceiscurrentlyusing60%oftotaloperatingsystemmemory.Yoususpectthesharedpoolfragmentationtobethereason.Whichactionwouldyouconsidertoovercometheperformancedegradation？（）

A.Configure Java Pool to cache the java objects.
B.Configure Streams Pool to enable parallel processing.
C.Increase Shared Pool size to cache more PL/SQL objects.
D.Increase Database Buffer Cache size to increase cache hits.
E.Configure Large Pool to be used by RMAN and shared server.
F.Increase the total System Global Area （SGA） size to increase memory hits.