1Z0-060 Exam Dumps | You execute the following PL/SQL: (Exhibit) Which two statements are true?

Valid 1Z0-060 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-060 Exam! ExamDiscuss.com now offer the newest 1Z0-060 exam dumps, the ExamDiscuss.com 1Z0-060 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-060 dumps with Test Engine here:

Access 1Z0-060 Dumps Premium Version
(205 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 97/112

You execute the following PL/SQL:

Which two statements are true?

A. Fine-Grained Auditing (FGA) is enabled for the PRICEcolumn in the PRODUCTStable for SELECT statements only when a row with PRICE > 10000is accessed.

B. FGA is enabled for the PRODUCTS.PRICEcolumn and an audit record is written whenever a row with PRICE > 10000is accessed.

C. FGA is enabled for all DML operations by JIMon the PRODUCTS.PRICEcolumn.

D. FGA is enabled for the PRICEcolumn of the PRODUCTStable and the SQL statements is captured in the FGA audit trial.

Correct Answer: A,D

Explanation/Reference:
Explanation:
DBMS_FGA.ADD_POLICY(object_schema => 'hr',object_name => 'emp',policy_name =>
'chk_hr_emp',audit_condition => 'dept = "SALES" ',audit_column => 'salary'statement_types =>
'insert,update,delete,select');
Default value for statement_types is SELECT
Setting audit_trail to DBMS_FGA.DB sends the audit trail to the SYS.FGA_LOG$ table in the database

and omits SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.DB+EXTENDED sends the audit trail to the SYS.FGA_LOG$ table in

the database and includes SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.XML writes the audit trail in XML files sent to the operating system

and omits SQL Text and SQL Bind.
Setting audit_trail to DBMS_FGA.XML+EXTENDED writes the audit trail in XML files sent to the

operating system and includes SQL Text and SQL Bind.
Default value fo audit_trail parameter in DBMS_FGA.ADD_POLICY is DB+EXTENDED

Your email address will not be published. Required fields are marked *

Comment: *

Name: *

Email: *

Rating: *

Verification: *

Question List (112q): Question 1: Which three statements are true concerning unplugging a plug...; Question 2: Your database is open and the LISTENERlistener running. You ...; Question 3: You conned using SQL Plus to the root container of a multite...; Question 4: A warehouse fact table in your Oracle 12c Database is range-...; Question 5: Examine the current values for the following parameters in y...; Question 6: Which three features work together, to allow a SQL statement...; Question 7: Which three statements are true about using flashback databa...; Question 8: Your database supports an online transaction processing (OLT...; Question 9: Which statement is true concerning dropping a pluggable data...; Question 10: To implement Automatic Management (AMM), you set the followi...; Question 11: Identify two situations in which the alert log file is updat...; Question 12: Identify two correct statements about multitenant architectu...; Question 13: You must track all transactions that modify certain tables i...; Question 14: The following parameters are set for your Oracle 12c databas...; Question 15: You notice a performance change in your production Oracle 12...; Question 16: Which two statements are true about Enterprise Manager (EM) ...; Question 17: Identify two valid options for adding a pluggable database (...; Question 18: Examine the query and its output executed In an RDBMS Instan...; Question 19: Your multitenant container database (CDB) contains a pluggab...; Question 20: Which two statements are true about Oracle Managed Files (OM...; Question 21: You are the DBA supporting an Oracle 11g Release 2 database ...; Question 22: Your multitenant container database (CDB) contains three plu...; Question 23: You notice that the elapsed time for an important database s...; Question 24: In your Database, the TBS PERCENT USEDparameter is set to 60...; Question 25: Examine the contents of SQL loader control file: (Exhibit) W...; Question 26: Identify three valid methods of opening, pluggable databases...; Question 27: Identify three scenarios in which you would recommend the us...; Question 28: Examine the parameter for your database instance: (Exhibit) ...; Question 29: You have altered a non-unique index to be invisible to deter...; Question 30: Which four actions are possible during an Online Data file M...; Question 31: You execute a DROP USER CASCADEon an Oracle 11g release 1 da...; Question 32: Which statement is true about Enterprise Manager (EM) expres...; Question 33: An administrator account is granted the CREATE SESSIONand SE...; Question 34: Which two are prerequisites for performing a flashback trans...; Question 35: You upgraded your database from pre-12c to a multitenant con...; Question 36: Your database supports a DSS workload that involves the exec...; Question 37: An application accesses a small lookup table frequently. You...; Question 38: You create a new pluggable database, HR_PDB, from the seed d...; Question 39: A database is stored in an Automatic Storage Management (ASM...; Question 40: Your database has the SRV1 service configured for an applica...; Question 41: To enable the Database Smart Flash Cache, you configure the ...; Question 42: You are about to plug a multi-terabyte non-CDB into an exist...; Question 43: Which three statements are true about SQL plan directives?...; Question 44: You execute the following piece of code with appropriate pri...; Question 45: In your Oracle 12c database, you create two roles: AUDITORan...; Question 46: Examine the following command: ALTER SYSTEM SET enable_ddl_l...; Question 47: Which three statements are true about Flashback Database? (C...; Question 48: You administer an online transaction processing (OLTP) syste...; Question 49: You install a non-RAC Oracle Database. During Installation, ...; Question 50: You are administering a database stored in Automatic Storage...; Question 51: A senior DBA asked you to execute the following command to i...; Question 52: You run a script that completes successfully using SQL*Plus ...; Question 53: Examine these two statements: (Exhibit) Which three are true...; Question 54: Your multitenant container database (CDB) is running in ARCH...; Question 55: You plan to migrate your database from a File system to Auto...; Question 56: Examine the following command: (Exhibit) Which three stateme...; Question 57: Your multitenant container database (CDB) contains pluggable...; Question 58: Which three functions are performed by the SQL Tuning Adviso...; Question 59: Which three statements are true about Automatic Workload Rep...; Question 60: You want to capture column group usage and gather extended s...; Question 61: What are two benefits of installing Grid Infrastructure soft...; Question 62: You configure your database Instance to support shared serve...; Question 63: You executed this command to create a password file: $ orapw...; Question 64: Your database is running an ARCHIVELOGmode. The following pa...; Question 65: You notice a high number of waits for the db file scattered ...; Question 66: You Execute the Following command to create a password file ...; Question 67: You must configure Oracle Data Redaction for the EMP table t...; Question 68: You have installed two 64G flash devices to support the Data...; Question 69: In your multitenant container database (CDB) that contains p...; Question 70: A new report process containing a complex query is written, ...; Question 71: In a recent Automatic Workload Repository (AWR) report for y...; Question 72: You are administering a database and you receive a requireme...; Question 73: You created a new database using the "create database" state...; Question 74: In your database, you want to ensure that idle sessions that...; Question 75: You upgraded from a previous Oracle database version to Orac...; Question 76: Which two statements are true concerning the Resource Manage...; Question 77: You are connected to a pluggable database (PDB) as a common ...; Question 78: Which three tasks can be automatically performed by the Auto...; Question 79: Flashback is enabled for your multitenant container database...; Question 80: Which two are true concerning a multitenant container databa...; Question 81: In which two scenarios do you use SQL* Loader to load data?...; Question 82: Which two statements are true about the RMAN VALIDATE DATABA...; Question 83: Which two partitioned table maintenance operations support a...; Question 84: You use the segment advisor to help determine objects for wh...; Question 85: On your Oracle 12c database, you invoked SQL*Loader to load ...; Question 86: In your multitenant container database (CDB) containing same...; Question 87: Which two statements are true about variable extent size sup...; Question 88: Which three statements are true about the working of system ...; Question 89: In your multitenant container database (CDB) containing plug...; Question 90: You want to flash back a test database by five hours. You is...; Question 91: Examine the following query output: (Exhibit) You issue the ...; Question 92: Which three statements are true about adaptive SQL plan mana...; Question 93: Which three statements are true about Oracle Data Pump expor...; Question 94: Examine the following command: ALTER SYSTEM SET enable_ddl_l...; Question 95: Examine the following parameters for a database instance: (E...; Question 96: You are planning the creation of a new multitenant container...; Question 97: You execute the following PL/SQL: (Exhibit) Which two statem...; Question 98: Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PRE...; Question 99: Which two statements are true when row archival management i...; Question 100: Examine the following impdp command to import a database ove...; Question 101: You upgrade your Oracle database in a multiprocessor environ...; Question 102: After implementing full Oracle Data Redaction, you change th...; Question 103: You use a recovery catalog for maintaining your database bac...; Question 104: You notice a performance change in your production Oracle da...; Question 105: The persistent configuration settings for RMAN have default ...; Question 106: You wish to enable an audit policy for all database users, e...; Question 107: You execute the following commands to audit database activit...; Question 108: Your multitenant container database has three pluggable data...; Question 109: Examine the commands executed to monitor database operations...; Question 110: Which three statements are true concerning the multitenant a...; Question 111: What is the effect of specifying the "ENABLE PLUGGABLE DATAB...; Question 112: Identify three benefits of Unified Auditing....

Question 97/112

LEAVE A REPLY

Download PDF File