网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
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
参考答案
参考解析
解析:
暂无解析
更多 “多选题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” 相关考题
考题
单选题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?()A
audit trailB
alert log fileC
user trace fileD
online trace fileE
background trace fileF
operating 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?()A
On Wednesday, the statistics have been purged.B
On Wednesday, the retention period has been set to zero.C
On Wednesday, the collection interval has been set to zero.D
On Wednesday, the collection level has been changed to All.E
On Wednesday, the retention period has been set to one day.F
On Wednesday, the retention period has been set to two days.G
On Wednesday, the collection level has been changed to Typical.H
On 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
热门标签
最新试卷