单项选择题

A.Modify the profile assigned to the user.B.Modify the ……

A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage， you are being logged off Which action would you take to increase the session limit on CPU usage？（）

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） .

多项选择题YourdatabaseisconfiguredinNOARCHIVELOGmode.Allthecontrolfileshavebeenlostduetoaharddiskfailurebutthedatafilesarenotlost.Youhavetheclosedwholedatabasebackupavailabletoyou.Whichtwostatementsaretrueinthisscenario？（）

A.The instance aborts.
B.The database cannot be recovered.
C.The database can be recovered by restoring the control files from the backup.
D.The database remains opened and you have to shut it down with the ABORT option.
E.The database can be restored till the point of the last closed whole database backup.

多项选择题Whichtwooperationsrequireundodata？（）

A.committing a transaction
B.rolling back a transaction
C.recovering from failed transactions
D.recording a transaction to redo log files
E.rolling forward during instance recovery

多项选择题WhichtwostatementsaretrueregardingthedatabaseinARCHIVELOGmode？（）

A.You have to shut down the database to perform the backups.
B.Archiving information is written to the data files and redo log files.
C.You can perform complete database backups without closing the database.
D.Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.
E.All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.