单项选择题
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?()
A.Monitor thealert.logfile
B.Enable server-side SQL tracing for user sessions
C.Enable fine-grained auditing for the customer table
D.Enable Fine-Grained Access Control (FGAC) for the customer table
E.Write a database trigger on the customer table on the SELECT event
相关考题
-
单项选择题
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).
