1z0-060 Upgrade to Oracle Database 12c - Practice Questions

Question 10

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?

Select an option, then click Submit answer.

○
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.

Question 11

You are administering a database and you receive a requirement to apply the following restrictions:

1. A connection must be terminated after four unsuccessful login attempts by a user.

2. A user should not be able to create more than four simultaneous sessions.

3. A user session must be terminated after 15 minutes of inactivity.

4. Users must be prompted to change their passwords every 15 days.

How would you accomplish these requirements?

Select an option, then click Submit answer.

○
by granting a secure application role to the users
○
by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
○
By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
○
By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
○
By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Question 12

You 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?

Select an option, then click Submit answer.

○
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

Reference / correct answer:

Online Table Redefinition

* 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 inavailability 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 afterredefinition 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 iscomplete. 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.

Note:

* 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 removesintra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance.

Incorrect Answers:

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.

1z0-060 – Upgrade to Oracle Database 12c