[Jan 15, 2022] 1Z0-060 Test Prep Training Practice Exam Questions Practice Tests

Exam Questions Answers Braindumps 1Z0-060 Exam Dumps PDF Questions

NEW QUESTION 12
In which two scenarios is an RMAN recovery catalog automatically resynchronized?

• A. when backup metadata records are aged out of the control file based on the control_file_record_keep_time parameter value
• B. when a redo log Is archived
• C. when a manual redo log switch is performed
• D. when a registered database is opened with the resetlogs option
• E. when the backup retention policy configuration is changed for a registered database

Answer: B,C

 

NEW QUESTION 13
You execute the following PL/SQL: Which two statements are true?

• A. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
• B. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
• C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
• D. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

Answer: A,D

Explanation:
DBMS_FGA.add_policy
*The DBMS_FGA package provides fine-grained security functions.
*ADD_POLICY Procedure
This procedure creates an audit policy using the supplied predicate as the audit condition.
Incorrect:
Not C: object_schema
The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.)

 

NEW QUESTION 14
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter: DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

• A. Set DB_FLASH_CACHE_ZISE = 64G, 64G
• B. Set DB_FLASH_CACHE_ZISE = 128G.
• C. Set DB_FLASH_CACHE_ZISE = 64G.
• D. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

Answer: A

Explanation:
* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in
Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB
Smart Flash cache. Now you can define many files|devices and its sizes for "Database Smart
Flash Cache" area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc
DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by "DB Smart Flash Cache"
/dev/sda - size 32G
/dev/sdb - size 32G
/dev/sdc - size 64G
New view V$FLASHFILESTAT - it's used to determine the cumulative latency and read counts of
each file|device and compute the average latency

 

NEW QUESTION 15
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, 'SH', 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE ('SH', 'CUSTOMERS') FROM dual statement.
Identify the correct sequence of steps.

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

Answer: D

Explanation:
Explanation
Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table. This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statisticsHere are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.2 - Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute ("exec") statement, Oracle extended statistics are created via a select statement.

 

NEW QUESTION 16
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?

• A. RMAN CONVERT command
• B. DBMS_FILE_TRANSFER with transportable tablespace
• C. Data Pump Export and import
• D. Conventional Export and Import
• E. The BACKUP AS COPY DATABASE . . . command of RMAN

Answer: B,E

 

NEW QUESTION 17
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service
level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE ('SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1.The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3.An aggregated trace file is created for all the sessions that are running the SRV1 service.
4.The trace files may be aggregated by using the trcess utility.
5.The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

• A. 2 and 4
• B. 3 and 5
• C. 2 and 5
• D. 0
• E. 3 and 4

Answer: A

Explanation:
Tracing information is present in multiple trace files and you must use
the trcsess tool to collect it into a single file.
Incorrect:
Not 1: Parameterservice_name
Name of the service for which tracing is enabled.
module_name
Name of the MODULE. An optional additional qualifier for the service.
Note:
* The procedure enables a trace for a given combination of Service, MODULE and ACTION name. The specification is strictly hierarchical: Service Name or Service Name/MODULE, or Service Name, MODULE, and ACTION name must be specified. Omitting a qualifier behaves like a wild-card, so that not specifying an ACTION means all ACTIONs. Using the ALL_ACTIONS constant achieves the same purpose.
*SERV_MOD_ACT_TRACE_ENABLE Procedure
This procedure will enable SQL tracing for a given combination of Service Name, MODULE
and ACTION globally unless an instance_name is specified.
*DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(
service_name IN VARCHAR2,
module_name IN VARCHAR2 DEFAULT ANY_MODULE,
action_name IN VARCHAR2 DEFAULT ANY_ACTION,
waits IN BOOLEAN DEFAULT TRUE,
binds IN BOOLEAN DEFAULT FALSE,
instance_name IN VARCHAR2 DEFAULT NULL);

 

NEW QUESTION 18
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. Place the root container in the nomount stage.
• C. Ensure that HR_PDB is open.
• D. Take the user data tablespace offline.

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 19
You execute the following PL/SQL:

Which two statements are true?

• A. FGA is enabled for the PRICEcolumn of the PRODUCTStable and the SQL statements is captured in the FGA audit trial.
• B. Fine-Grained Auditing (FGA) is enabled for the PRICEcolumn in the PRODUCTStable for SELECT statements only when 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 PRODUCTS.PRICEcolumn and an audit record is written whenever a row with PRICE > 10000is accessed.

Answer: A,B

Explanation:
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

 

NEW QUESTION 20
You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• B. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• C. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
• D. It generates an error when creating the table because the wallet is closed.

Answer: D

 

NEW QUESTION 21
Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)

• A. Move partitions of a range-partitioned table.
• B. Rename partitions of a range partitioned table.
• C. Merge partitions of a reference partitioned index.
• D. Coalesce partitions of a hash-partitioned global index.
• E. Merge partitions of a list partitioned table.
• F. Drop partitions of a list partitioned table.

Answer: C,E,F

Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A: Merge Multiple Partitions:
The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL>
Restrictions :
* You can't drop all partitions of the table.
* If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.

 

NEW QUESTION 22
An administrator account is granted the CREATE SESSIONand SET CONTAINERsystem privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode? (Choose four.)

• A. You can connect as a local user by using the CONNECTstatement.
• B. You can connect as a common user by using the CONNECTstatement.
• C. You can connect as a local user by using the SET CONTAINERstatement.
• D. You can connect by using a Net Service name.
• E. You can connect by using easy connect.
• F. You can connect by using OS authentication.

Answer: B,D,E,F

Explanation:
Explanation/Reference:
Explanation:
http://docs.oracle.com/database/121/ADMIN/cdb_admin.htm

 

NEW QUESTION 23
You execute a DROP USER CASCADEon an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTStable to the OCP schema.
RECYCLE_BINwas enabled before the DROP USERwas executed and the OCP user has been granted the FLASHBACK ANY TABLEsystem privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTStable to the OCP schema?

• A. Recovery the table using Database Point In Time Recovery.
• B. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  EXAM_RESULTS;connected as the OCPuser.
• C. Recover the table using traditional Tablespace Point In Time Recovery.
• D. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
  OCP.EXAM_RESULTS;connected as SYSTEM.

Answer: B

 

NEW QUESTION 24
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read-only mode? (Choose four.)

• A. You can connect as a local user by using the SET CONTAINER statement.
• B. You can connect as a common user by using the CONNECT statement.
• C. You can connect as a local user by using the CONNECT statement.
• D. You can connect by using a Net Service name.
• E. You can connect by using easy connect.
• F. You can connect by using OS authentication.

Answer: B,D,E,F

Explanation:
Explanation
http://docs.oracle.com/database/121/ADMIN/cdb_admin.htm

 

NEW QUESTION 25
You upgraded yourdatabase frompre-12cto a multitenantcontainer database (CDB) containingpluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

• A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• B. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• C. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to Yes.
• E. Re-create the password file in the Oracle Database 12c format.

Answer: A,C

Explanation:
*orapwd
/You can create a database password file using the password file creation utility,
ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]
[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional),
*v$PWFILE_users
/ 12c:V$PWFILE_USERS lists all users in the password file, and indicates whether the user
has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG,
and SYSKM privileges.
/ 10c:sts users who have been granted SYSDBA and SYSOPER privileges as derived from
the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file
SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges
SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges
Incorrect:
not E: The format of the v$PWFILE_users file is already in 12c format.

 

NEW QUESTION 26
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

• A. The partitions can be moved online to new tablespaces.
• B. The partitions can be compressed in the new tablespaces.
• C. Global indexes must be rebuilt manually after moving the partitions.
• D. Local indexes must be rebuilt manually after moving the partitions.
• E. The partitions can be compressed in the same tablespaces.

Answer: A,B,E

Explanation:
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.
Incorrect:
Not B, not E: Local and Global indexes can be automatically rebuild with UPDATE INDEXES when
you move the table.

 

NEW QUESTION 27
Identify two correct statements about multitenant architectures.

• A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C. Patches are always applied at the CDB level.
• D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E. Multiple CDBsshare certain PDB resources.
• F. A PDB can have a private undo tablespace.

Answer: B,C

Explanation:
B: Using 12c Resource manager you will be able control CPU, Exadata I/O, sessions and parallel servers. A new 12c CDB Resource Manager Plan will use so-called "Shares" (resource allocations) to specify how CPU is distributed between PDBs. A CDB Resource Manager Plan also can use "utilization limits" to limit the CPU usage for a PDB. With a default directive, you do not need to modify the resource plan for each PDB plug and unplug.
E: New paradigms for rapid patching and upgrades. The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version.
Incorrect:
Not A:
*The Oracle RAC documentation describes special considerations for a CDB in an Oracle RAC environment.
* Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application.
Not D: You can unplug a PDB from one CDB and plug it into a different CDB without altering your schemas or applications. A PDB can be plugged into only one CDB at a time.
not F:
*UNDO tablespace can NOT be local and stays on the CDB level.
* Redo and undo go hand in hand, and so the CDB as a whole has a single undo tablespace per RAC instance.

 

NEW QUESTION 28
DBS_IND_PARTITIONS.ORPHANED_ENTRIEScontains YESfor several index partitions.
This is due to the use of deferred index maintenance.
Which three methods will remove the orphaned keys? (Choose three.)

• A. using ALTER INDEX COALESCE PARTITION CLEANUPonce for each affected local index partition
• B. using DBMS_PART.CLEANUP_CIDXonce to clean up any orphaned keys in all global indexes on partitioned tables.
• C. using DBMS_PART.CLEANUP_GIDXonce to clean up orphaned keys in all local indexes.
• D. using ALTER INDEX REBUILD PARTITIONonce for each affected global index partition
• E. using ALTER INDEX REBUILD PARTITIONonce for each affected local index partition
• F. using ALTER INDEX COALESCE PARTITION CLEANUPonce for each affected global index partition

Answer: C,E,F

Explanation:
Explanation/Reference:

 

NEW QUESTION 29
Your multitenant container database (CDB) is running in ARCHIVELOGmode. You connect to the CDB RMAN.
Examine the following command and its output:

You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
Which data files will be backed up?

• A. Data files that belong to only the root container
• B. Data files that belong to the root container and all the PDBs excluding PDB$SEED
• C. Data files that belong to only the root container and PDB$SEED
• D. Data files that belong to the root container and all the pluggable databases (PDBs)

Answer: D

Explanation:
Explanation/Reference:
Explanation:
Backing Up a Whole CDB
Backing up a whole CDB is similar to backing up a non-CDB. When you back up a whole CDB, RMAN backs up the root, all the PDBs, and the archived redo logs. You can then recover either the whole CDB, the root only, or one or more PDBs from the CDB backup.
Note:
* You can back up and recover a whole CDB, the root only, or one or more PDBs.
* Backing Up Archived Redo Logs with RMAN
Archived redo logs are the key to successful media recovery. Back them up regularly. You can back up logs with BACKUP ARCHIVELOG, or back up logs while backing up datafiles and control files by specifying BACKUP ... PLUS ARCHIVELOG.

 

NEW QUESTION 30
Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c?
(Choose two.)

• A. You cannot start up or shut down a database instance by using EM express.
• B. By default, EM express is available for a database after database creation.
• C. Multiple databases on the same node (or host) may each be individually managed by using EM Express.
• D. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• E. You can create and configure pluggable databases by using EM express.

Answer: A,C

Explanation:
O12c is integrated in database don't have his own agent like in O11G then you cannot start up or shut down a database.

 

NEW QUESTION 31
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?

• A. Recover each pluggable database.
• B. Mount the container database (CDB) and restore the control file from the control file auto backup.
• C. Recover and open the CDB in NORMAL mode.
• D. Start the database instance in the nomount stage and restore the control file from control file auto backup.
• E. Mount the CDB and then recover and open the database, with the RESETLOGS option.
• F. Open all the pluggable databases.

Answer: D,E,F

Explanation:
Step 1: F
Step 2: D
Step 3: C: If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVERcommand, even if no data files have been restored, and open the database with the RESETLOGS option.
Note:
*RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for backup and recovery in a multitenant environment. You can back up and recover a whole multitenant container database (CDB), root only, or one or more pluggable databases (PDBs).

 

NEW QUESTION 32
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

• A. All DDL commands are logged in the alert log file.
• B. Only DDL commands that resulted in the creation of new segments are logged.
• C. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
• D. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• E. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.

Answer: C

Explanation:
* By default Oracle database does not log any DDL operations performed by any user. The default settings for auditing only logs DML operations.
*Oracle 12c DDL Logging - ENABLE_DDL_LOGGING
The first method is by using the enabling a DDL logging feature built into the database. By default it is turned off and you can turn it on by setting the value of ENABLE_DDL_LOGGING initialization parameter to true.
*We can turn it on using the following command. The parameter is dynamic and you can turn it
on/off on the go.
SQL> alter system set ENABLE_DDL_LOGGING=true;
System altered.
Elapsed: 00:00:00.05
SQL>
Once it is turned on, every DDL command will be logged in the alert log file and also the log.xml file.

 

NEW QUESTION 33
You execute the following commands to audit database activities:

Which statement is true about the audit record that generated when auditing after instance restarts?

• A. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• B. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.
• C. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
• E. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

Answer: C

Explanation:
In 12c by session no longer inserts only one audit record. It creates one record per successful asuditing conditions.

 

NEW QUESTION 34
......

The Oracle 1Z0-060 exam validates your expertise when it comes to Oracle Database.

As you are getting ready for the Oracle 1Z0-060 certification exam, it is vital that you understand all that is entailed in this test. It is important to mention this is an exam that requires you to have more practical knowledge than theoretical concepts. The majority of those who have failed it focused their attention on cramming rather than gaining the actual skills. You should take a different perspective – be more practical.

Your journey towards earning the Oracle Certified Professional (OCP) certification begins with receiving the Oracle Certified Associate (OCA) credential. With the OCA certificate, you tell the world that you are equipped with vital skills needed to provide support for Oracle products. OCP is the benchmark of your professional career and shows that you have what it takes to implement enterprise-wide databases. Earning it begins with the single step of passing your Oracle 1Z0-060 exam. The test includes 80 questions. There will be 120 minutes to complete all of them. You have to pay 245$ for the 1Z0-060 exam.

 

Download Free Oracle 1Z0-060 Real Exam Questions: https://www.dumptorrent.com/1Z0-060-braindumps-torrent.html