Oracle Database 18c: New Features for Administrators Ed 1 Quiz Questions and Answers
Answer :
- A set of tables sharded in the same way
- Only a single root table (table with no parent) per family
Answer :
- Connect to the CDB root of another CDB.
- Use a common user identical to the common user used in the lead CDB
- Set the LEAD_CDB_URI database property to the name of the database link to the CDB lead
Answer :
- CREATE PLUGGABLE DATABASE pdb1 …snapshot mode manual;
- ALTER PLUGGABLE DATABASE pdb1 SNAPSHOT MODE EVERY 24 HOURS
Answer :
- ALTER PLUGGABLE DATABASE pdb1 SNAPSHOT MODE NONE;
Answer :
- CREATE LOCKDOWN PROFILE dynamic_op_prof INCLUDING app_root_prof;
Answer :
- Oracle supplied objects in queries
- All query shapes supported
- Multi-column sharding keys supported
- SET operators supported
Answer :
- CREATE DUPLICATED TABLE Products(stockno number primary key,Description varchar2(20),Price NUMBER(6,2));
- Are nonsharded tables that duplicate data on all shards
- Are created in the shard catalog
- Use materialized view replication
Answer :
- Each partition of a sharded table is stored in a separate tablespace
- Guaranteed when the tables in a table family are created in the same tablespace set
- The child tables of a table family can be stored in separate tablespace sets.
Answer :
- 1. Remember all datafile names on the standby. 2. Restart standby in nomount. 3. Restore controlfile from primary. 4. Mount standby database.5. Rename datafiles from stored standby names.6. Restore new datafiles to new names.7. Recover standby.
