QUESTION NO: 1
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?
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?
Correct Answer: A,D
Vote an answer
QUESTION NO: 2
Which four items exist in the root of a CDB, but not in the PDBs?
Which four items exist in the root of a CDB, but not in the PDBs?
Correct Answer: C,D,E,F
Vote an answer
QUESTION NO: 3
Which three DBA operations can be performed by using Oracle SQL Developer?
Which three DBA operations can be performed by using Oracle SQL Developer?
Correct Answer: C,D,E
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 4
Examine the statements:
SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;
SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )
PARTITION BY RANGE(id) (
partition pi values loss than (100000) tablespacemytbs storage (initial lm),
partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)
);
When inserting data, you get the error:
ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS
Which three operations would allow you to insert data without getting the error message?
Examine the statements:
SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;
SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) )
PARTITION BY RANGE(id) (
partition pi values loss than (100000) tablespacemytbs storage (initial lm),
partition p2 values less than (MAXVALUE) tablespacemytbs storage (initial 1m)
);
When inserting data, you get the error:
ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS
Which three operations would allow you to insert data without getting the error message?
Correct Answer: A,B,C
Vote an answer
QUESTION NO: 5
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
You are about to install Oracle Database 12c Enterprise Edition. Which statement is true?
Correct Answer: A
Vote an answer
QUESTION NO: 6
You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?
You create a CDB with four containers: the loot, the seed, and two pluggable databases PDB1 and PDB2. Which four items can reside In PDB1, but not in the root?
Correct Answer: A,B,G,H
Vote an answer