搜索答案
登录 注册
首页  /  试题详情

单选题 Unified auditing is enabled in your database. The HR_ADMIN andOE_ADMIN roles exist and are granted system privileges. You execute thecommand: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANYTABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement istrue?

A、 It succeeds and needs to be enabled to capture all SQL statements thatrequire either the specified privileges or any privilege granted to the HR_ADMINor OE_ADMIN role.
B、 It fails because the command does not specify when the unified audit policyshould be enforced.
C、 It succeeds and starts capturing only successful SQL statements for all userswho have either the specified privileges or roles granted to them.
D、 It fails because system privileges cannot be granted with roles in the sameaudit policy.
查看答案

微信扫一扫
扫一扫下载APP
微信小程序答题 下载APP答题
由4l***wy提供 分享 举报 纠错
相关题库推荐
t3he
2024-10-22
共282道
19C083_101-200
2022-07-04
共100道
083 1-120
2024-06-30
共120道
1Z0-083（277题）更新版
2023-02-22
共277道
1Z0-083（277题）更新版更
2023-02-15
共277道
083
2024-04-28
共277道

相关试题

单选题 Examine the statements that use flashback technologies: -1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS'); -2. SELECT ∗ FROM customers AS OF SCN 123456; -3. FLASHBACK TABLE customers TO BEFORE DROP; -4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-0409:30:00', 'YYYY-MM-DD HH:MI:SS'); -5. SELECT ∗ FROM customers VERSIONS BETWEEN SCN 123456 AND 123999; -6. ALTER TABLE customers FLASHBACK ARCHIVE;Which set of statements depends on the availability of relevant undo data in theundo tablespace?

A、 1,3,6
B、 1,2,5
C、 3,4,5
D、 2,3,5,6

单选题 Your production database is running in archivelog mode. You useRMAN with a recovery catalog to back up your database to media and thedatabase is uniquely identified in the recovery catalog. You want to create atest database from the production database and allow the productiondatabase to remain open during the duplicate process. You restore thedatabase backups to a new host with the same directory structure as theproduction database and want to use the recovery catalog for futurebackups after the database is successfully restored to the new host. Howwould you achieve this?

A、 by using the RMAN switch command to set the new location for the data files
B、 by using the RMAN duplicate command with nofilenamecheck to recover thedatabase to the new host
C、 by using the RMAN duplicate command with dbid and set new name fortablespace to recover the database to the new host
D、 by creating a new database in the new host, and then using the RMAN recovercommand

单选题 Examine the RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?

A、 The password for the encryption must be set up.
B、 Oracle wallet for the encryption must be set up.
C、 All the tablespaces in the database must be encrypted
D、 Oracle Database Vault must be enabled.

单选题 Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PRODdatabase uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command:RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE;What is a prerequisite for the successful execution of this command

A、 RMAN must be connected to the target database instance and the auxiliaryinstance.
B、 A most recent backup set of the PROD database must exist.
C、 Flashback must be enabled for the PROD database.
D、 The target database must be in MOUNT state.

单选题 A user complains about poor database performance. You want to verifyif the user’s session has waited for certain types of I/O activity. Which viewdisplays all waits waited on by a session at least once?

A、 V$SESSION_EVENT
B、 V$SESSTAT
C、 V$SESSION_WAIT
D、 V$SESSION_WAIT_CLASS
E、 V$SESSION

单选题 You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications: Applications will connectto the database via a middle tier. The number of concurrent userconnections will be high. The database will have mixed workload, with theexecution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

A、 a General Purpose database template with default memory allocation
B、 a Data Warehouse database template, with t he dedicated server mode optionand AMM enabled
C、 a General Purpose database template, with t he shared server mode optionand Automatic Memory Management (AMM) enabled
D、 a default database configuration

单选题 choose one You enable Flashback Data Archive for a table for which youwant to track and save all transactions for four years. After some time, therequirement changes for keeping transactions from four to two years. You execute the following command to change the requirement:SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;What is the outcome?

A、 All historical data older than two years, if any, is purged from the flashbackarchive FDA1.
B、 An error is returned because the retention period cannot be reduced.
C、 All the flashback data archives are purged and the subsequently createdflashback archives are maintained for two years.
D、 All historical data older than two years, if any, is archived to flashback logs andthe flashback archive is set to new retention time.

单选题 Automatic Shared Memory Management is disabled for one of yourdatabase instances. Some SQL statements perform poorly due to excessivehard parse activity, thereby degrading performance. What would be yournext step?

A、 Run the SQL Access Advisor.
B、 Run the Memory Advisor for the shared pool.
C、 Run the SQL Tuning Advisor.
D、 Run the Memory Advisor for the Program Global Area.
E、 Run the Memory Advisor for the System Global Area.