单项选择题

Which is the correct description of the significance of the ORACLE_HOME environmental variable？（）

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.

单项选择题Becauseofapoweroutage，instancefailurehasoccurred.Fromwhatpointintheredologdoesrecoverybeginandwheredoesitend？（）

A.current redo log and inactive redo log
B.checkpoint position to end of redo log
C.beginning of redo log to end of redo log
D.all redo logs before the point of last commit
E.beginning of redo log to checkpoint position

单项选择题WhichstepdoyouneedtoperformtoenableauserwiththeSYSDBAprivilegetologinasSYSDBAiniSQL*Plus？（）

A.The user must be granted the database administrator （DBA） privilege.
B.The user must be listed in the password file for the authentication.
C.No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
D.Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.