You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Oneoftheusersessionswasterminatedabnormallyinthemiddleofatransaction.WhatdoesOracledatabasedotorecoverit？（）

A.Uses undo data for roll forward
B.Uses Flashback Log for recovery
C.Uses online redo logs to roll back
D.Uses undo data to roll back the transaction
E.Uses Recovery Manager （RMAN） to roll back
F.Uses the System Monitor （SMON） background process to perform instance recovery

多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Yourlistenerprocess，L1，iscurrentlylisteningtothreedatabases：CertKINDB04，SupportCenterDB05andSupportCenterDB06.UsingDatabaseConfigurationAssistant（DBCA）youcreateonemoredatabase，SupportCenterDB07，andenabledynamicregistration.WhichtwocommandsofListenerControlUtility（lsnrct1）wouldyouusetodeterminewhetherthedynamicregistrationoccurredforthedatabase，SupportCenterDB07，withtheL1listenerprocess？（）

A.SHOW L1
B.SPAWN L1
C.STATUS L1
D.SERVICES L1
E.STATUS LISTENER
F.SERVICES LISTENER
G.SHOWcurrent_listener

单项选择题YouworkasadatabaseadministratorforSupportcenter.cn.YouareusingRecoveryManager（RMAN）forbackupandrecoveryofyourdatabase.YouexecutedthedeletecommandinRMANtodeleteabackupofatablespace.Whichstatementistrueinthisscenario？（）

A.The backup status will be marked expired in RMAN recovery catalog.
B.The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
C.The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
D.The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
E.The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

多项选择题YouworkasadatabaseadministratorforSupportcenter.cn.Oneofthedatabaseusersaccidentallydeletedalltherowsofacriticaltableandcommittedthedeleteat1：30p.m.Youseniordatabaseadministrator，SupportCenter，asksyoutoretrievethelostdata.Whichtwoactionswouldyouusetoensurethatthereisnoimpactonotherconnecteduserswhileretrievingthedeletedrows？（）

A.Use a flashback query to retrieve the rows that were deleted
B.Useconventialincremental export and then import the affected object
C.Shutdown the database inNORMALmode and restart the database instance
D.Use DBMS_META package to reconstruct the object using undo segments
E.UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data
F.Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

单项选择题You work as a database administrator for Supportcenter.cn. When you tried to connect to the database， you received the following error：   ERROR：   ORA-12541：TNS：no_listener   You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.   lsnrctl>START   What statement is true？（）

A.It would attempt to start the default listener
B.It would start the most recently created listener.
C.It would display an error with a message asking for the listener name to be specified.
D.It would show you a list of listeners and prompts for the listener name that you want to start.