Upgrade to Oracle Database 12c
Question No: 81
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
A DBA can check specific tables with the DMU
The database to be migrated must be opened read-only.
The release of the database to be converted can be any release since 184.108.40.206.
The DMU can report columns that are too long in the converted characterset.
The DMU can report columns that are not represented in the converted characterset.
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.
Not C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 220.127.116.11, 18.104.22.168, or later.
Question No: 82
You enabled an audit policy by issuing the following statements:
SQLgt; AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQLgt; AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.
Only for successful executions
Only for failed executions
Both successful and failed executions
Explanation: * The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.
Question No: 83
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.
Answer: C,D Explanation:
To configure your database for the Flashback Transaction feature, you or your database administrator must:
With the database mounted but not open, enable ARCHIVELOG: ALTER DATABASE ARCHIVELOG;
Open at least one archive log:
ALTER SYSTEM ARCHIVE LOG CURRENT;
If not done, enable minimal and primary key supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
If you want to track foreign key dependencies, enable foreign key supplemental logging:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;
Reference: Oracle Database Advanced Application Developer#39;s Guide 11g, Using Oracle Flashback Technology
Question No: 84
Which three actions are possible during an Online Data file Move operation?
Creating and dropping tables in the data file being moved
Performing file shrink of the data file being moved
Querying tables in the data file being moved
Performing Block Media Recovery for a data block in the data file being moved
Flashing back the database
Executing DML statements on objects stored in the data file being moved
Explanation: An Online Move data file operation is not compatible when:鈥?The data file is an OFFLINE data file鈥?A concurrent flashback database operation is executing鈥?A media recovery is completing鈥?A file shrink operation or tablespace offline/drop operation involving the same file is performing
Question No: 85
On your Oracle 12c database, you Issue the following commands to create indexes
SQL gt; CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQLgt; 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.
Explanation: 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.
Question No: 86
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:
Which two statements are true?
The C # # ROLE1 role is created in the root database and all the PDBs.
The C # # ROLE1 role is created only in the root database because the container clause is not used.
Privileges are granted to the C##A_ADMIN user only in the root database.
Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
The statement for granting a role to a user fails because the CONTAINER clause is not used.
Explanation: * You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER
* CREATE ROLE with CONTAINER (optional) clause
/ CONTAINER = ALL
Creates a common role.
/ CONTAINER = CURRENT
Creates a local role in the current PDB.
Question No: 87
You want to flash back a test database by five hours. You issue this command:
SQL gt; FLASHBACK DATABASE TO TIMESTAMP (SYSDATE – 5/24);
Which two statements are true about this flashback scenario?
The database must have multiplexed redo logs for the flashback to succeed.
The database must be MOUNTED for the flashback to succeed.
The database must use block change tracking for the flashback to succeed.
The database must be opened in restricted mode for the flashback to succeed.
The database must be opened with the RESETLOGS option after the flashback is complete.
The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
Answer: B,E Explanation:
Question No: 88
Which two statements are true when row archival management is enabled?
The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
Explanation: http://gavinsoorma.com/2013/08/oracle-12c-new-feature-in-database- archiving/
Question No: 89
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?
The size of the shared pool is too small.
Cursors are not being shared.
A large number COMMITS are being performed.
There are frequent logons and logoffs.
The buffers are being read into the buffer cache, but some other session is changing the buffers.
Question No: 90
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
Oracle Data Pump.
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
Online Table Redefinition.
Edition-Based Table Redefinition.
Explanation: * Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.
To redefine a table online:
Choose the redefinition method: by key or by rowid
By key-Select a primary key or pseudo-primary key to use for the redefinition. Pseudo- primary keys are unique keys with all component columns having NOT NULL constraints. For this method, the versions of the tables before and after redefinition should have the same primary key columns. This is the preferred and default method of redefinition.
By rowid-Use this method if no key is available. In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. If COMPATIBLE is set to 10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE … DROP UNUSED COLUMNS statement to drop it.
You cannot use this method on index-organized tables.
When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a new tablespace. Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance.
Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.
100% Ensurepass Free Download!
–Download Free Demo:1z0-060 Demo PDF
100% Ensurepass Free Guaranteed!
–Download 2018 EnsurePass 1z0-060 Full Exam PDF and VCE
EnsurePass ExamCollection Testking Lowest Price Guarantee Yes No No Up-to-Dated Yes No No Real Questions Yes No No Explanation Yes No No PDF VCE Yes No No Free VCE Simulator Yes No No Instant Download Yes No No