Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
By default, EM express is available for a database after database creation.
You can use EM express to manage multiple databases running on the same server.
You can perform basic administrative tasks for pluggable databases by using the EM express interface.
You cannot start up or shut down a database Instance by using EM express.
You can create and configure pluggable databases by using EM express.
M Express is built inside the database. Note:
Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basic database administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?
Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
All DDL commands are logged in the alert log file.
All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
Only DDL commands that resulted in the creation of new segments are logged.
All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Once DDL logging is turned on, every DDL command will be logged in the alert log file and also the log.xml file.
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
Once it is turned on, every DDL command will be logged in the alert log file and also the log.xml file.
In which two scenarios do you use SQL* Loader to load data?
Transform the data while it is being loaded into the database.
Use transparent parallel processing without having to split the external data first.
Load data into multiple tables during the same load statement.
Generate unique sequential key values in specified columns.
You can use SQL*Loader to do the following:
/ (A) Manipulate the data before loading it, using SQL functions.
/ (D) Generate unique sequential key values in specified columns. etc:
/ Load data into multiple tables during the same load session.
/ Load data across a network. This means that you can run the SQL*Loader client on a different system from the one that is running the SQL*Loader server.
/ Load data from multiple datafiles during the same load session.
/Specify the character set of the data.
/ Selectively load data (you can load records based on the records' values).
/Use the operating system's file system to access the datafiles.
/ Load data from disk, tape, or named pipe.
/ Generate sophisticated error reports, which greatly aid troubleshooting.
/ Load arbitrarily complex object-relational data.
/ Use secondary datafiles for loading LOBs and collections.
/ Use either conventional or direct path loading. While conventional path loading is very flexible, direct path loading provides superior loading performance.
SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.
You are connected to a pluggable database (PDB) as a common user with DBA privileges. The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following: SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = ‘*’ SCOPE = SPFILE; Which is true about the result of this command?
The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database
(CDB) is restarted.
Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
In a container architecture, the parameters for PDB will inherit from the root database. That means if statistics_level=all in the root that will cascade to the PDB databases.
You can over ride this by using Alter system set, if that parameter is pdb modifiable, there is a new column in v$system_parameter for the same.
Which two are prerequisites for performing a flashback transaction?
Flashback Database must be enabled.
Undo retention guarantee for the database must be configured.
EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Supplemental logging must be enabled.
Recycle bin must be enabled for the database.
Block change tracking must be enabled tor the database.
Oracle Database Advanced Application Developer's Guide 11g, Using Oracle Flashback Technology
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
CREATE DISKGROUP NORMAL REDUNDANCY
For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).
On your Oracle 12c database, you Issue the following commands to create indexes SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statement are correct?
Both the indexes are created; however, only the ORD_COSTOMER index is visible.
The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
Only the ORD_CUSTOMER_IX1 index is created.
Only the ORD_CUSTOMER_IX2 index is created.
Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.
11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3. Which two RMAN commands may be; used to back up only the PDB1 pluggable database?
BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
BACKUP DATABASE while connected to the PDB1 container
BACKUP DATABASE while connected to the boot container
BACKUP PLUGGABLE database PDB1 while connected to PDB2
To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
(A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.
(C)If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.
Oracle Database Backup and Recovery User's Guide 12c, About Backup and Recovery of CDBs
Identify three benefits of Unified Auditing.
Decreased use of storage to store audit trail rows in the database.
It improves overall auditing performance.
It guarantees zero-loss auditing.
The audit trail cannot be easily modified because it is read-only.
It automatically audits Recovery Manager (RMAN) events.
A: Starting with 12c, Oracle has unified all of the auditing types into one single unit
called Unified auditing. You don’t have to turn on or off all of the different auidting types individually and as a matter of fact auditing is enabled by default right out of the box. The AUD$ and FGA$ tables have been replaced with one single audit trail table. All of the audit data is now stored in Secure Files table thus improving the overall management aspects of audit data itself. B: Further the audit data can also be buffered solving most of the common performance related problems seen on busy environments.
E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label
Security, Database Vault and Real Application Security operations. Note:
Benefits of the Unified Audit Trail
The benefits of a unified audit trail are many:
/ (B) Overall auditing performance is greatly improved. The default mode that unified audit works is Queued Write mode. In this mode, the audit records are batched in SGA queue and is persisted in a periodic way. Because the audit records are written to SGA queue, there is a significant performance improvement.
/ The unified auditing functionality is always enabled and does not depend on the initialization parameters that were used in previous releases
/ (A) The audit records, including records from the SYS audit trail, for all the audited components of your Oracle Database installation are placed in one location and in one format, rather than your having to look in different places to find audit trails in varying formats. This consolidated view enables auditors to co-relate audit information from different components. For example, if an error occurred during an INSERT statement, standard auditing can indicate the error number and the
SQL that was executed. Oracle Database Vault-specific information can indicate whether this error happened because of a command rule violation or realm violation. Note that there will be two audit records with a distinct AUDIT_TYPE. With this unification in place, SYS audit records appear with AUDIT_TYPE set to Standard Audit.
/ The management and security of the audit trail is also improved by having it in single audit trail.
/ You can create named audit policies that enable you to audit the supported components listed at the beginning of this section, as well as SYS administrative users. Furthermore, you can build conditions and exclusions into your policies.
Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database using policies and conditions. The new policy based syntax simplifies management of auditing within the database and provides the ability to accelerate auditing based on conditions.
The new architecture unifies the existing audit trails into a single audit trail, enabling simplified management and increasing the security of audit data generated by the database.
You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.
After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs. How do you accomplish this?
Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.
Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.
Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.
Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the
DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.
Monitoring database operations
Real-Time Database Operations Monitoring enables you to monitor long running database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation, and Loading (ETL) jobs as a composite business operation. This feature tracks the progress of SQL and PL/SQL queries associated with the business operation being monitored. As a DBA or developer, you can define business operations for monitoring by explicitly specifying the start and end of the operation or implicitly with tags that identify the operation.
If you are an OCP in any release, then you can become a 12c OCP with this exam — but it won't be easy. Upgrade to Oracle Database 12c has teeth.
">1Z0-060: Upgrade to Oracle Database 12c
Reviewer's SummaryThis test is not the creampuff that New Features exams have been for earlier releases. The Core DBA Skills section on this exam adds a twist that is going to bite some test takers.
Time Limit120 minutes
Number of questions 51 34
Counts towardOracle Database 12c Administrator Certified Professional
Exam Objectives">1Z0-060 Exam Objectives
">1Z0-060: Upgrade to Oracle Database 12c is the exam required for Oracle Certified Database Administrators from earlier releases to recertify for Oracle 12c. Unlike previous upgrade exams offered by Oracle University, ">1Z0-060 has no restriction on which release the exam candidate must be certified in. Oracle professionals who last earned their OCP as far back as release 7.3 of the Oracle database can perform a single-step upgrade to being 12c-certified. Of course doing so will not certify candidates in the releases that were bypassed. For DBAs holding 7.3 and 8i certifications who are not interested in taking multiple exams, this is an excellent opportunity to blow the dust off their credentials by taking a single test.
Cynics (or realists) might wonder if there is a catch involved. There is. Previous "Upgrade" exams have always been called "New Features" exams. The only topics contained on these exams have revolved around the new bells and whistles that were added in the release of the database they were for. The ">1Z0-060 exam is different in that it has two sections with different goals. The first section covers the new features of Oracle 12c. The second section is for "Core DBA" skills. The two are separately scored and candidates must have a passing score in both to receive credit for the exam.
Many of the topics of the Core skills are extremely broad. One example is, "Perform daily administration tasks," which can cover a huge range of potential questions. It is difficult to study for topics that have no clearly defined limits. For test-takers who have worked as a DBA, much of what is on that section will be information that was accumulated through job performance. Candidates who have never worked as a DBA (or have not done so recently) may find this section to be a significant challenge.
The exam has 49 topics on new features and 34 on Core DBA skills. As with all of Oracle University’s New Features exams, the topics are all over the map, so grouping them into a small number of related categories is not feasible. The single biggest selling point of Oracle 12c is the Multitenant capability, and a significant number of topics are related to it. Beyond that, the other topics have little in common. To demonstrate just how diverse the material covered by this exam is — while performing my research, I had to reference 20 separate Oracle manuals:
I have always found the New Features exams of the Oracle Certification Program to be fairly easy, something I noted last year on a GoCertify review about 1Z0-050. My preparation for these exams has always been a routine process. Perhaps the Oracle University test development team read my review and took it as a personal challenge. Whatever the case, ">1Z0-060 is a more difficult test than I have seen in earlier releases. Part of the problem is with the vague Core Skills topics as noted above. However, I also believe that Oracle University reduced the percentage of "learner-level" questions in this exam in comparison to previous releases.
At 85 seconds per question, the time pressure was not really bad, but it was close enough to require some budgeting. My exam had absolutely no exhibits, which was a little surprising, but nice from a time standpoint. The last several exams I have taken have been notably free of them. I don’t know if this is coincidence or if OU is moving away from using exhibits as often as they have in the past.
This is easily the hardest of the exams I have taken to upgrade my Oracle DBA certification. I suspect that was a conscious decision on the part of Oracle University because of the multi-step upgrade it provides. However, it may be part of a larger strategy to increase the difficulty of the Oracle DBA certification. I noted in my GoCertify review of the 1Z0-062 test that it was markedly more difficult than OCA exams typically are. Oracle University may be looking to raise the bar on what it takes to become an OCP. Whatever the reason, do not underestimate ">1Z0-060. Good luck on the exam.
About the Matthew Morris is an experienced DBA and developer. He holds Oracle DBA Certifications for releases 7, 8i, 9i, 10G and 11G; is an Oracle Advanced PLSQL Developer Certified Professional; and holds Oracle Expert Certifications for SQL, SQL Tuning, and Application Express. He is the author of several Oracle certification guides. His Web site, .oraclecertificationprepm, is dedicated to providing links to resources for Oracle certification preparation.
Get Unlimited Access to all ExamCollection's PREMIUM files!
Enter Your Email Address to Receive Your 30% Off Discount Code
Please enter a correct email to Get your Discount Code
Download Free Demo of VCEExam Simulator
Experience Avanset VCE Exam Simulator for yourself.
Simply submit your e-mail address below to get started with our interactive software demo of your free trial.
With Oracle Database 12c, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.
Article by ArticleForge
New Features of Oracle Database 12c
CDBs and PDBs Creation and ConfigurationThe creation and configuration of CDBs and PDBs Creation as well as migration of a non-CDB to a PDB database is expected from the candidate who take this exam.Managing CDBs and PDBsThe skills to establish a connection between the CDBs to PDBs as well as start up and shut down a CDB and PDB are measured and verified by the exam.CDBPDB Backup, Recovery and FlashbackPerforming the recovery, backup of CDB and PDB is expected from a candidate moreover performing the flashback of a CDB is expected from a candidate who takes this exam.Information Lifecycle Management and Storage EnhancementsThe knowledge about the use of ILM features and moving a data file online is required from the candidates taking this exam.In-Database Archiving and Valid-Time TemporalThe ability required for differentiating between the ILM and valid- time temporal is measured and validated by the Oracle ">1Z0-060 exam.AuditingThe ability of enabling and configuring the Unified Audit Data Trail and creation of audit policies is measured and validated by the exam.PrivilegesThe ability of using administrative privileges, creating, using and enabling the privileges is measured and validated by the Oracle ">1Z0-060 exam.SQL TuningThe ability of using adaptive execution plans and enhanced features of statistic gatherings is checked and validated by the exam.Resource Management and Other Performance EnhancementsThe ability of using Flash cache explanation of multi-process multi threaded Oracle architecture is measured and validated by the exam.Index and Table EnhancementsThe knowledge about the use of index and table enhancements as well as the use of online operation enhancements is measured and validated by the exam.Partioning and SQL EnhancementsThe ability required for explaining the partioning statements and explaining the index enhancements for portioned tables is measured and validated by the Oracle ">1Z0-060 exam.
Key DBA Skills Key DBA skills includePerformance ManagementThe ability required for designing the database layout for optional performance, analyzing and identifying the performance issues is measured and validated by the Oracle ">1Z0-060 exam.Storage & SecurityThe management of database structures, administration of ASM, management of VLDB, and ASM Disk and diskgroups is measured and validated by the exam. The ability required for development and implementation of a security policy, creation of the password files and implementation of column and tablespace encryption is measured and validated by the Oracle ">1Z0-060 exam.
How you should prepare the Oracle ">1Z0-060The candidates are advised to prepare the exam by keeping in mind the given points
1. Follow the topic guideline2. Prepare all the topics thoroughly3. Get relevant hands on experience4. Get help of the ">1Z0-060 practice test
Quick and Authentic Oracle ">1Z0-060 Exam PreparationIf you want to do the quick and authentic preparation of the Oracle ">1Z0-060 exam you need to get help of the ">1Z0-060 braindumps. The practice test is a useful aid prepared by the industry experts for saving your time and enabling you to prepare for the exam even with your hectic schedule. The main features embedded in the practice exam are simulation of real exam scenario, self-assessment features, best examples of real exam questions and multiple learning methods.
Trying a free demo is helpful to take the right decision to purchase or not the ">1Z0-060 practice exam!