Welcome to TestSimulate

Pass Your Next Certification Exam Fast!

Everything you need to prepare, learn & pass your certification exam easily.

365 days free updates. First attempt guaranteed success.

  • Home
  • Blogs
  • Get ready to pass the 1Z0-060 Exam right now using our Oracle Database Exam Package [Q99-Q124]

Get ready to pass the 1Z0-060 Exam right now using our Oracle Database Exam Package [Q99-Q124]

Share

 Get ready to pass the 1Z0-060 Exam right now using our Oracle Database  Exam Package

A fully updated 2021 1Z0-060 Exam Dumps exam guide from training expert TestSimulate

NEW QUESTION 99
Examine the query and its output executed In an RDBMS Instance: Which three statements are true about the users (other than sys) in the output?

  • A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
  • B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
  • C. The C # # A_ADMIN user can perform wallet operations.
  • D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
  • E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.

Answer: A,B,D

Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup
E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in
privilege to allow the DBA full control over the database
Incorrect:
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption
wallet operations.
Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative
privileges.

 

NEW QUESTION 100
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

  • A. The DMU can report columns that are too long in the converted characterset.
  • B. The release of the database to be converted can be any release since 9.2.0.8.
  • C. The DMU can report columns that are not represented in the converted characterset.
  • D. A DBA can check specific tables with the DMU
  • E. The database to be migrated must be opened read-only.

Answer: A,C,D

Explanation:
Explanation/Reference:
Explanation:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.
* Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.
Incorrect Answers:
C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.

 

NEW QUESTION 101
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

  • A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
  • B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
  • C. All the components may be moved from the SYSAUX tablespace.
  • D. All the components may be moved into SYSAUX tablespace.

Answer: B,C

Explanation:
V$SYSAUX_OCCUPANTS displays SYSAUX tablespace occupant information. MOVE_PROCEDURE:Name of the move procedure; null if not applicable
For example, the tables and indexes that were previously owned by the system user can now be specified for a SYSAUX tablespace. You can query the v$sysaux_occupants view to find the exact components stored within the SYSAUX tablespace.

 

NEW QUESTION 102
Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOGmode. An RMAN backup exists for the databases.
You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available.

  • A. 1,2,5,6,7,8
  • B. 1,2,10,5,6,9
  • C. 10,3,4,8,9
  • D. 1,2,3,4,7,8

Answer: A,B

 

NEW QUESTION 103
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

  • A. Place the root container in ARHCHIVELOG mode.
  • B. Take the user data tablespace offline.
  • C. Ensure that HR_PDB is open.
  • D. Place the root container in the nomount stage.

Answer: C

Explanation:
* Because tablespaces in different PDBs can have the same name, to eliminate ambiguity you must connect directly to a PDB to back up one or more of its tablespaces.
* To back up tablespaces or data files:
Start RMAN and connect to a target database and a recovery catalog (if used).
If the database instance is not started, then either mount or open the database.
Run the BACKUP TABLESPACE command or BACKUP DATAFILE command at the RMAN prompt.

 

NEW QUESTION 104
You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advice given by the segment advisor? (Choose three.)

  • A. It may advise the use of segment shrink for tables in dictionary-managed tablespaces it the no chained rows.
  • B. It may advise the use of online table redefinition for tables in locally managed tablespaces.
  • C. It may advise the use of online table redefinition for tables in dictionary-managed tablespaces.
  • D. It may advise the use of segment shrink for freelist managed tables.
  • E. It will detect and advise about chained rows.

Answer: B,C,E

Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/schema.htm#CBBBIADA

 

NEW QUESTION 105
Examine the contents of a SQL*Loader control file:

Which three statements are true regarding the SQL*Loader operation performed by using the control file?
(Choose three.)

  • A. The SQL*Loader operation fails because no record terminators are specified.
  • B. The SQL*Loader data file myfile1.dat has the column names for the EMP table.
  • C. The SQL*Loader operation assumes that the data files are stream record format files with a normal carriage return string as the record terminator.
  • D. Field names should be on the first line in both the SQL*Loader data files.
  • E. An EMP table is created if a table does not exist. Otherwise, the EMP table is appended with the loaded data.

Answer: B,C,E

Explanation:
Explanation
A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with.
B (not D):
Note:
* SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE directive could not be processed.
Action: Check the listed data file and fix it. Then retry the operation E:
* A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.
* Fields with embedded commas must be quoted.
Example:
1997,Ford,E350,"Super, luxurious truck"
Note:
* SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.

 

NEW QUESTION 106
You create a table with the PERIOD FORclause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEEStable?

  • A. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  • B. The validtimecolumns are not populated by the Oracle Server automatically.
  • C. The valid time columns employee_time_start and employee_time_end are automatically created.
  • D. The validtimecolumns arevisible by default when the table is described.
  • E. Setting the session valid time using
    DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for datamanipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: A,C,E

Explanation:
http://docs.oracle.com/database/121/ADFNS/adfns_design.htm#ADFNS1424

 

NEW QUESTION 107
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)

  • A. All the components may be moved from the SYSAUX tablespace.
  • B. The procedures may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
  • C. The procedures may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
  • D. All the components may be moved into the SYSAUX tablespace.

Answer: B,C

Explanation:
Explanation
References:
http://www.dba-oracle.com/t_v_sysaux_contents_tips.htm

 

NEW QUESTION 108
Your database is running an ARCHIVELOG mode.
The following parameters are set in your database instance:

Which statement is true about the archived redo log files?

  • A. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the location specified by the DB_RECOVERY_FILE_DEST parameter.
  • B. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
  • C. They are created only in the Fast Recovery Area because configuring the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters automatically enables flashback for the database.
  • D. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.

Answer: D

Explanation:
Explanation
You can choose to archive redo logs to a single destination or to multiple destinations.
Destinations can be local-within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group-or remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is written to each destination. These redundant copies help ensure that archived logs are always available in the event of a failure at one of the destinations.
To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.
ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.

 

NEW QUESTION 109
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

  • A. Reduced physical I/O
  • B. Reduced CPU utilization
  • C. Improved Serial Execution performance
  • D. Reduced logical I/O
  • E. Improved parallel Execution performance
  • F. Reduced virtual memory utilization

Answer: B,E,F

Explanation:
* Multiprocess and Multithreaded Oracle Database Systems
Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users-either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously.
Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.
* In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.

 

NEW QUESTION 110
Which two statements are true when row archival management is enabled?

  • A. The ROW ARCHIVAL VISIBILITYsession parameter defaults to active rows only.
  • B. The ORA_ARCHIVE_STATEcolumn is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
  • C. The ORA_ARCHIVE_STATEcolumn visibility is controlled by the ROW ARCHIVAL VISIBILITYsession parameter.
  • D. The ORA_ARCHIVE_STATEcolumn is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
  • E. The ORA_ARCHIVE_STATEcolumn is visible if referenced in the select list of a query.

Answer: D,E

Explanation:
Explanation/Reference:
Explanation:
http://gavinsoorma.com/2013/08/oracle-12c-new-feature-in-database-archiving/

 

NEW QUESTION 111
Which two statements are true about the RMAN validate database command?

  • A. It checks the database for intrablock corruptions.
  • B. It can detect corruptspfiles.
  • C. It checks the database for interblock corruptions.
  • D. It can detect corrupt block change tracking files.
  • E. It can detect corruptpfiles.

Answer: A,B

Explanation:
Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption. the corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption.
(key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY and the ANALYZE statement detect Interblock corruption.
VALIDATE Command Output >> List of Control File and SPFILE.
File TYPE >> SPFILE or Control File.
Status >> OK if no corruption, or FAILED If block corruption is found.
Blocks Failing >> The number of blocks that fail the corruption check. These blocks are newly corrupt.
Blocks Examined >> Total number of blocks in the file.
Oracle' Database Backup and Recovery User's Guide 12c Release 1 (12.1) - 16 Validating Database Files and Backups

 

NEW QUESTION 112
Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0 MEMORY_TARGET=0 SGA_TARGET=0 PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?

  • A. DB_KEEP_CACHE_SIZE
  • B. JAVA_POOL_SIZE
  • C. DB_16K_CACHE_SZIE
  • D. SORT_AREA_SIZE
  • E. LOG_BUFFER
  • F. STREAMS_POOL_SIZE

Answer: A,C,E

Explanation:
Manually Sized SGA Components that Use SGA_TARGET Space SGA Component, Initialization Parameter / The log buffer LOG_BUFFER / The keep and recycle buffer caches DB_KEEP_CACHE_SIZE DB_RECYCLE_CACHE_SIZE / Nonstandard block size buffer caches DB_nK_CACHE_SIZE
Note:
*In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.
*Table, Automatically Sized SGA Components and Corresponding Parameters

 

NEW QUESTION 113
Which three statements are true about Oracle Data Pump export and import operations?

  • A. Data pump import requires the import file to be in a directory owned by the oracle owner.
  • B. You can detach from a data pump export job and reattach later.
  • C. Data pump uses parallel execution server processes to implement parallel import.
  • D. You can detach from a data pump import job and reattach later.
  • E. The master table is the last object to be exported by the data pump.

Answer: B,C,E

Explanation:
B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.
D: For export jobs, the master table records the location of database objects within a dump file set.
/ Export builds and maintains the master table for the duration of the job. At the end of an export
job, the content of the master table is written to a file in the dump file set.
/ For import jobs, the master table is loaded from the dump file set and is used to control the
sequence of operations for locating objects that need to be imported into the target database.

 

NEW QUESTION 114
The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1.Set the evolve task parameters.
2.Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3.Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps:

  • A. 1, 2, 3, 4, 5
  • B. 2, 1, 4, 3, 5
  • C. 1, 2, 4, 5
  • D. 2, 4, 5

Answer: B

Explanation:
* Evolving SQL Plan Baselines

*2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
This function creates an advisor task to prepare the plan evolution of one or more plans for a
specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan
names, time limit, task name, and description.
1. Set the evolve task parameters.
SET_EVOLVE_TASK_PARAMETER
This function updates the value of an evolve task parameter. In this release, the only valid
parameter is TIME_LIMIT.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.
3: IMPLEMENT_EVOLVE_TASK
This function implements all recommendations for an evolve task. Essentially, this function is
equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input
parameters include task name, plan name, owner name, and execution name.
5. Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function.
This function displays the results of an evolve task as a CLOB. Input parameters include the task
name and section of the report to include.
Reference: Oracle Database SQL Tuning Guide 12c, Managing SQL Plan Baselines

 

NEW QUESTION 115
Which statement is true about Oracle Net Listener?

  • A. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.
  • B. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
  • C. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
  • D. Service registration with the listener is performed by the listener registration process monitor (LREG) process of each database instance.
  • E. A single listener can service only one database instance and multiple remote client connections.

Answer: D

Explanation:
http://docs.oracle.com/database/121/NETAG/listenercfg.htm

 

NEW QUESTION 116
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?

  • A. There are frequent logons and logoffs.
  • B. A large number COMMITSare being performed.
  • C. The size of the shared pool is too small.
  • D. The buffers are being read into the buffer cache, but some other session is changing the buffers.
  • E. Cursors are not being shared.

Answer: C,D,E

 

NEW QUESTION 117
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)

  • A. The database must have multiplexed redo logs for the flashback to succeed.
  • B. The database must use block change tracking for the flashback to succeed.
  • C. The database must be MOUNTED for the flashback to succeed.
  • D. The database must be opened with the RESETLOGS option after the flashback is complete.
  • E. The database must be opened in restricted mode for the flashback to succeed.
  • F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

Answer: C,D

Explanation:
Explanation
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmflash.htm#BRADV80055

 

NEW QUESTION 118
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

  • A. The index remains invisible.
  • B. The index becomes unusable but the table is updated by the DML.
  • C. The index automatically becomes visible in order to have it updated by DML on the table.
  • D. The index is not updated by the DML statements on the indexed table.
  • E. The index is updated by the DML on the table.

Answer: A,E

Explanation:
Unlike unusable indexes, an invisible index is maintained during DML statements.
Note: *Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command.

 

NEW QUESTION 119
You upgrade your Oracle database in a multiprocessor environment. As a recommended
you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

  • A. Parallel compilation of only the stored PL/SQL code
  • B. Sequential recompilation of only the stored PL/SQL code
  • C. Sequential recompilation of Java code
  • D. Sequential recompilation of any stored PL/SQL code
  • E. Parallel recompilation of Java code
  • F. Parallel recompilation of any stored PL/SQL code

Answer: E,F

Explanation:
utlrp.sql and utlprp.sql
The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in
the database. They are typically run after major database changes such as upgrades or
patches. They are located in the $ORACLE_HOME/rdbms/admin directory and provide a
wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql
script with a command line parameter of "0". The utlprp.sql accepts a single integer
parameter that indicates the level of parallelism as follows.
0 - The level of parallelism is derived based on the CPU_COUNT parameter.
1 - The recompilation is run serially, one object at a time.
N - The recompilation is run in parallel with "N" number of threads.
Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly.
Reference:Recompiling Invalid Schema Objects

 

NEW QUESTION 120
Examine the memory-related parameters of an Oracle database instance:

Which statement is true?

  • A. Only the components of SGA are managed automatically.
  • B. Memory is dynamically re-allocated between SGA and PGA as needed.
  • C. PGA size can grow automatically beyond 500 MB.
  • D. The value of the memory_target parameter cannot be changed dynamically.

Answer: C

 

NEW QUESTION 121
Which two statements are true about Oracle Managed Files (OMF)?

  • A. OMF may affect the location of the redo log files and archived log files.
  • B. OMF automatically creates unique file names for table spaces and control files.
  • C. OMF cannot be used in a database that already has data files created with user-specified directions.
  • D. The file system directions that are specified by OMF parameters are created automatically.
  • E. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

Answer: B,D

Explanation:
B: Through initialization parameters, you specify the file system directory to be used
for a particular type of file. The database then ensures that a unique file, an Oracle-managed file,
is created and deleted when no longer needed.
D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
Tablespaces Redo log files Control files Archived logs Block change tracking files Flashback logs RMAN backups
Note: * Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause.
Reference: What Are Oracle-Managed Files?

 

NEW QUESTION 122
Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

  • A. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.
  • B. All database operations performed by the impdp command are logged.
  • C. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.
  • D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

Answer: A

Explanation:
Oracle Data Pump disable redo logging when loading data into tables and when creating indexes. The new TRANSFORM option introduced in data pumps import provides the flexibility to turn off the redo generation for the objects during the course of import. The Master Table is used to track the detailed progress information of a Data Pump job. The Master Table is created in the schema of the current user running the Pump Dump export or import, and it keeps tracks of lots of detailed information.

 

NEW QUESTION 123
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

  • A. All users except SYS, SYSTEM, and SCOTT
  • B. All users except SYS
  • C. All users except SCOTT
  • D. All users except SYS and SCOTT

Answer: C

Explanation:
Explanation
If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY
... EXCEPT statement.
Note:
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings.
By default, this policy is not enabled.
* You can use the keyword ALL to audit all actions. The following example shows how to audit all actions on the HR.EMPLOYEES table, except actions by user pmulligan.
Example Auditing All Actions on a Table
CREATE AUDIT POLICY all_actions_on_hr_emp_pol
ACTIONS ALL ON HR.EMPLOYEES;
AUDIT POLICY all_actions_on_hr_emp_pol EXCEPT pmulligan;

 

NEW QUESTION 124
......

Master 2021 Latest The Questions Oracle Database and Pass 1Z0-060  Real Exam!: https://www.testsimulate.com/1Z0-060-study-materials.html

Related Blogs

more
Go To 1Z0-060 Questions

Copyright © 2026 TESTSIMULATE.COM. All rights reserved. All trademarks are the property of their respective owners and we don't provide actual questions from any vendor.