http://https://www.lead1pass.com/Oracle/1z0-063-practice-exam-dumps.html (175 Q&As Dumps, 30%OFF Special Discount: 30free )

NEW QUESTION NO: 10
In which situation can you use Flashback Database?
A. when undoing a shrink data file operation
B. when retrieving a dropped tablespace
C. when returning to a point in time before the restoration or re-creation of a control file
D. when returning to a point in time before the most recent open resetlogs operation
Answer: B
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm (prerequisites, third para)
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194

NEW QUESTION NO: 11
You want RMAN to make duplicate copies of data files when using the backup command.
What must you set using the RMAN configure command to achieve this?
A. MAXSETSIZE TO 2;
B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Answer: D
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/B14117_01/server.101/b10734/rcmconfg.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137

NEW QUESTION NO: 12
Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open?
A. restoring target data files to the duplicate database
B. generating a new, unique database identifier (DBID) for the duplicate database
C. copying online redo log files from the target database to the duplicate database
D. performing complete recovery by using all available backups
E. creating a control file for the duplicate database
Answer: A,D

NEW QUESTION NO: 13
Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?
A. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
B. Enable the recyclebin.
C. Enable minimal supplemental logging.
D. Enable Fast Recovery Area.
E. Enable undo retention guarantee.
Answer: B,C

NEW QUESTION NO: 14
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?
A. The PDB is closed and left in the unmount state.
B. The PDB is placed and left in the mount state.
C. The command executes only if the common user is granted the set container privilege for the PDB.
D. The command results in an error because the PDB can be shut down only by a local user.
Answer: A
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13652

NEW QUESTION NO: 15
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
A. A DBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMU can report columns that are too long in the converted characterset
E. The DMU can report columns that are not represented in the converted characterset
Answer: A,D,E
Explanation/Reference:
Explanation:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

NEW QUESTION NO: 16
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:
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH (to make password
-encrypted backups)

NEW QUESTION NO: 17
In CDB$ROOTof your multitenant container database (CDB), you create a common user, C##A_ADMIN.
and then execute the command:

Which statement is true?
A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
B. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).
C. The command fails because the CONTAINERclause is not used.
D. The command fails because system privileges cannot be granted to a common user.
Answer: C
Explanation/Reference:
Explanation:
For commonly granted privileges the grantor must be connected to the root and must specify CONTAINER=ALL in the GRANT statement.
References: https://docs.oracle.com/database/121/DBSEG/authorization.htm

NEW QUESTION NO: 18
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)?
A. Use PDB$SEEDfor creating a PDB.
B. Use the DBMS_PDBpackage to plug a non-CDB into an existing CDB.
C. Clone the existing PDB.
D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
E. Use the DBMS_PDBpackage to plug a pre-Oracle 12c database into an existing CDB.
Answer: A,B,C
Explanation/Reference:
Explanation:
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB).
This statement enables you to perform the following tasks:
* Create a PDB by using the seed as a template
Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template.
* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB
Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.
* Create a PDB by cloning an existing PDB or non-CDB
Use the create_pdb_clone clause to create a PDB by copying an existing PDB or non-CDB and then plugging the copy into the CDB.
References: https://docs.oracle.com/database/121/SQLRF/statements_6010.htm

NEW QUESTION NO: 19
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?
A. a hash cluster
B. a sorted hash cluster
C. a partitioned table
D. a heap table with a rowid column
E. an index cluster
Answer: E

NEW QUESTION NO: 20
Which two statements are true about service creation for pluggable databases (PDBs)?
A. When a PDB is created, a service with the same name as the PDB is created in the PDB.
B. Only a common user can create additional services for a PDB.
C. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.
D. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.
E. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.
Answer: B,D