Which type of information is included in dynamic performance views?
1 - System and session parameters
2 - Memory usage and allocation
3 - File states (including RMAN backup files)
4 - Progress of jobs and tasks
5 - SQL execution
6 - Statistics and metrics
http://docs.oracle.com/cd/E16655_01/server.121/e17633/datadict.htm#CNCPT1213 (overview of dynamic performance views)
The session of user SCOTT receives the following error after executing an UPDATE command on the EMP table:
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource
You find out that a session opened by user JIM has a transaction that caused the deadlock. Which two statements are true about SCOTT's session in this scenario?
https://www.youtube.com/watch?v=JitJRb5x9vI
Which two statements are true about this common user?
In this SQL statement, what is the partitioning criteria?
CREATE TABLE books_part
PARTITION BY RANGE (cell_id) (
PARTITION p0l VALUES LESS THAN (2),
PARTITION p02 VALUES LESS THAN (3) ,
. . .
PARTITION pl4 VALUES LESS THAN (15),
PARTITION pl5 VALUES LESS THAN (16),
PARTITION pl6 VALUES LESS THAN (MAXVALUE)
)
AS SELECT * FROM books;
A DBA informs you that an Oracle instance has started. What does this imply?
What must you do to an application for it to take advantage of partitioning?
http://docs.oracle.com/cd/B19306_01/server.102/b14220/partconc.htm
You execute some DMLcommands, followed by a COMMIT Statement.
Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?
Which three statements represent the benefits of multitenant architecture for database consolidation?
By design, you can quickly plug a PDB into a CDB, unplug the PDB from the CDB, and then plug this PDB into a different CDB. The implementation technique for plugging and unplugging is similar to the transportable tablespace technique.
A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs.
Benefits of the Multitenant Architecture for Database Consolidation
URL: http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239
Your customer is looking for a solution that meets these four needs:
1 - Replicate data from source to target for reporting purposes.
2 -Replicate data from one source to multiple targets.
3 - Replicate data between two databases for instant failover.
4 - Replicate data from multiple sources to a single target for a data warehouse.
Which GoldenGate-supported topology would you recommended?
Your customer has three data centers in three different locations, location A has their production database running on Oracle Database 12c. They want to replicate the data from location A to location B. which is 50 miles away and is used for disaster protection and database rolling upgrades. They also want to create a replica database at location C, which must be open in read-write mode, while synchronizing with the primary database.
Which two solutions would you recommend to your customer?
