One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status？（）

单项选择题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

多项选择题UserScotthasupdatedthesalaryofoneoftheemployeesintheEMPLOYEEStableandhasnotcommittedthetransaction.Whatarethetwotypesoflocksthatthisscenariowouldleadto？（）

A.null lock on the row being updated
B.null lock on the table containing the row
C.ROW SHARE lock for the row being updated
D.ROW EXCLUSIVE lock for the row being updated
E.shared row-exclusive lock for the row being updated
F.a shareable table lock for the table containing the row
G.exclusive table-level lock for the table containing the row

多项选择题When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed： TZ set to America New_york OC4J Configuration issue.  u01 app oracle product 10.1.0 db_1 oc4j j2ee OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors，and start the Database Control successfully？（）

A.NLS_LANG
B.ORACLE_SID
C.ORACLE_HOME
D.ORACLE_BASE
E.LD_LIBRARY_PATH

单项选择题You need to rename a data file of a tablespace. How would you perform this？（）

A.A
B.B
C.C
D.D

单项选择题You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）

A.START
B.RELOAD
C.RESTART
D.REFRESH
E.START L1
F.RELOAD L1
G.RESTART L1
H.REFRESH L1