NEW QUESTION NO: 6
Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
A. password-mode encryption
B. dual-mode encryption
C. transparent encryption
D. default encryption
Answer: A
Explanation/Reference:
References:

NEW QUESTION NO: 7
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true?
A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
B. All database listeners running from the database home are automatically added to the OracleRestart configuration.
C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restartconfiguration.
D. The crsct1 start has command must be used to start software services for Oracle AutomaticStorage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
Answer: C,E
Explanation/Reference:
Explanation:
https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

NEW QUESTION NO: 8
Which three statements are true about Consolidated Database Replay?
A. The workload capture and replay systems must have the same operating system (OS).
B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
C. A subset of the captured workload can be replayed.
D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
Answer: B,C,E
Explanation/Reference:
Explanation:

NEW QUESTION NO: 9
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
A. All the read-only tablespaces should be taken offline.
B. All the read-only tablespaces should be restored separately.
C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
D. All the read-only tablespaces should be made online with logging disabled.
Answer: B
Explanation/Reference:
Explanation:

NEW QUESTION NO: 10
On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?
A. It succeeds with default settings if the employees table exists in the hr schema.
B. It fails because no SQL*Loader data file location is specified.
C. It fails if the hr user does not have the create any directory privilege.
D. It fails because no SQL*Loader control file location is specified.
E. It succeeds and creates the employees table in the HR schema.
Answer: A,C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 11
Which two statements are true about tablespaces in multitenant container databases (CDBs)?
A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
C. Each PDB can have its own default temporary tablespace.
D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
E. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB level.
Answer: B,C
Explanation/Reference:
Explanation:

NEW QUESTION NO: 12
You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.
A. by using the connect statement as a local user having only the set container privilege
B. by using easy connect
C. by using external authentication
D. as a common user with the set container privilege
E. by executing the alter session set container command as a local user
Answer: A,D
Explanation/Reference:
Explanation:

NEW QUESTION NO: 13
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
A. A base recovery catalog should exist.
B. The owner of VPC cannot own recovery catalog.
C. At least one target database should be registered in the recovery catalog.
D. The register database privilege should be granted to the virtual catalog owner.
E. The recovery_catalog_owner role should be granted to the virtual catalog owner.
Answer: C,D,E
Explanation/Reference:
References:

NEW QUESTION NO: 14
In a database supporting an OLTP workload, tables are frequently updated on both key and non- keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
A. heap table with a primary key index
B. external table
C. hash clustered table
D. global temporary table
E. index clustered table
Answer: E
Explanation/Reference:
Explanation:

NEW QUESTION NO: 15
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?
A. The current online redo log file is missing.
B. A data file belonging to a noncritical tablespace is missing.
C. All the control files are missing.
D. The database backup is older than the control file backup.
E. All the data files are missing.
Answer: A,C
Explanation/Reference:
Explanation:
http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel

NEW QUESTION NO: 16
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?
A. Oracle wallet for the encryption must be set up.
B. The password for the encryption must be set up.
C. Oracle Database Vault must be enabled.
D. All the tablespaces in the database must be encrypted.
Answer: A