單項選擇題

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

你可能感興趣的試題

單項選擇題

You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）

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

多項選擇題

You work as a database administrator for Supportcenter.cn. Your listener process， L1， is currently listening to three databases： CertK INDB04， SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant （DBCA） you create one more database， SupportCenter DB07， and enable dynamic registration. Which two commands of Listener Control Utility （lsnrct1） would you use to determine whether the dynamic registration occurred for the database， SupportCenter DB07， with the L1 listener process？（）

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

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？（）

你可能感興趣的試題

You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）

You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）