Oracle Database 12c: Advanced Administration - 1z1-063 模擬練習
Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?
正解: A
Which three statements are true about Flashback Data Archive? (Choose three.)
正解: A,C,D
RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)
正解: D,E
解説: (PassTest メンバーにのみ表示されます)
You created a database with DBCA by using one of the Oracle supplied templates.
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
正解: B
What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?
正解: C
The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:
Which two tasks are performed as part of the import? (Choose two.)
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:
Which two tasks are performed as part of the import? (Choose two.)
正解: D,E
Which three conditions must be met before you create a Virtual Private Catalog (VPC)? (Choose three.)
正解: A,C,E
Examine this command:
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
正解: B,D
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)
正解: A,C
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
正解: A
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user?
SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;
SQL> GRANT CREATE SESSION TO c##scott;
Which statement is true about the C##SCOTT user?
正解: A