多选题You want to enforce a company’s business policy on several objects by using a singlepolicy function.  Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective?()ADBMS_RLS.STATICBDBMS_RLS.DYNAMICCDBMS_RLS.SHARED_STATICDDBMS_RLS.CONTEXT_SENSITIVEEDBMS_RLS.SHARED_CONTEXT_SENSITIVE

多选题
You want to enforce a company’s business policy on several objects by using a singlepolicy function.  Which two types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the above objective?()
A

DBMS_RLS.STATIC

B

DBMS_RLS.DYNAMIC

C

DBMS_RLS.SHARED_STATIC

D

DBMS_RLS.CONTEXT_SENSITIVE

E

DBMS_RLS.SHARED_CONTEXT_SENSITIVE


参考解析

解析: 暂无解析

相关考题:

单选题When you try to open your database, you receive the following error:  ORA-00205: error in identifying controlfile  Where would you find the details required to resolve this error?()Aaudit trailBalert log fileCuser trace fileDonline trace fileEbackground trace fileFoperating system event viewer

多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configuring mean time to recover (MTTR) to a lower valueEBy setting the UNDO_RETENTION parameter to a higher value

多选题You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, Certkiller, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows?()AUse a flashback query to retrieve the rows that were deletedBUseconventialincremental export and then import the affected objectCShutdown the database inNORMALmode and restart the database instanceDUse DBMS_META package to reconstruct the object using undo segmentsEUseTablespacePoint in Time Recovery (TSPITR) method to recover the table and the dataFUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.

单选题Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes and the collection level is set to Typical in your production database.  You have been using the Memory Advisor for the last three months to generate recommendations for tuning memory components. However, when you observe the Memory Advisor on a Friday, you find that the statistics are available only for two days, Thursday and Friday, of that week.  What would have caused the statistics to be removed?()AOn Wednesday, the statistics have been purged.BOn Wednesday, the retention period has been set to zero.COn Wednesday, the collection interval has been set to zero.DOn Wednesday, the collection level has been changed to All.EOn Wednesday, the retention period has been set to one day.FOn Wednesday, the retention period has been set to two days.GOn Wednesday, the collection level has been changed to Typical.HOn Wednesday, the collection interval has been set to 1440 minutes.

多选题The following are the details of your database:   Instance name:test   Host name:tech1.us.oracle.com   IP address:145.33.230.186  Enterprise Manager Console HTTP Port number:5500   You started the database instance and you want to manage your database remotely with Enterprise Manager through a Web browser. Which two URLs would you use to access the Database Control?()Ahttp://145.33.230.186:5500/emBhttp://www.145.33.230.186:5500/emChttp://tech1.us.oracle.com:5500/emDhttp://test.145.33.230.186:5500/emEhttp://test.tech1.us.oracle.com:5500Fhttp://www.tech1.us.oracle.com:5500/emGhttp://test.tech1.us.oracle.com:5500/em