单项选择题
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）
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. -
单项选择题
WhichisthecorrectdescriptionofthesignificanceoftheORACLE_HOMEenvironmentalvariable？（）
A.It specifies the directory containing the Oracle software.
B.It specifies the directory containing the Oracle-Managed Files.
C.It specifies the directory for database files， if not specified explicitly.
D.It specifies the base directory of Optimal Flexible Architecture （OFA） .
