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

NEW QUESTION NO: 7
Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).
How would you achieve this?
A. by using a transportable database
B. by using the Database Upgrade Assistant (DBUA)
C. by using Data Pump
D. by using RMAN
Answer: D
Explanation/Reference:
References: http://docs.oracle.com/cd/E11882_01/server.112/e18951.pdf (p.184)

NEW QUESTION NO: 8
Your database instance has started using an SPFILE.
Examine the RMAN configuration settings:

You execute the command:
RMAN> BACKUP AS COPY TABLESPACE TEST;
Which three types of files are backed up by using this command?
A. online redo log files
B. control file
C. SPFILE
D. archived redo log files
E. data file(s)
F. PFILE
Answer: B,C,E
Explanation/Reference:
References: http://www.juliandyke.com/Research/RMAN/BackupCommand.php

NEW QUESTION NO: 9
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
Answer: B
Explanation/Reference:
Explanation:
CREATE DISKGROUP NORMAL REDUNDANCY
* For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).

NEW QUESTION NO: 10
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE 'u01/oracle/rddb1/undotbs01.dbf' SIZE 60M AUTOEXTEND ON;
What is the result?
A. It executes successfully and creates an UNDO tablespace in HR_PDB.
B. It falls and reports an error because there can be only one undo tablespace in a CDB.
C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
E. It executes successfully but neither tablespace nor the data file is created.
Answer: E
Explanation/Reference:
Explanation:
Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.
When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.

NEW QUESTION NO: 11
You execute this command:

Which two statements are true about segment space management for segments in this tablespace?
A. The PCTFREEstorage parameter has no effect on segments created in this tablespace.
B. The PCTUSEDstorage parameter has no effect on segments created in this tablespace.
C. Space utilization inside segments is mapped by bitmaps.
D. Segments are automatically shrunk and compressed when rows are deleted.
Answer: B,C

NEW QUESTION NO: 12
You use multiple temporary tables frequently in your database. Which two are benefits of configuring temporary undo?
A. Performance improves because less redo is written to the redo log.
B. Temporary undo reduces the amount of undo stored in undo tablespaces.
C. Performance improves because data manipulation language (DML) operations performed on temporary tables do not use the buffer cache.
D. Performance improves because no redo and undo are generated for the temporary tables.
Answer: B,D
Explanation/Reference:
References: https://oracle-base.com/articles/12c/temporary-undo-12cr1

NEW QUESTION NO: 13
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?
A. Use Oracle Managed Files (OMF).
B. Specify the SEED FILE_NAME_CONVERT clause.
C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.
D. Specify the DB_FILE_NAMECONVERT initialization parameter.
E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).
Answer: A,B,C
Explanation/Reference:
Explanation:
You must specify the names and locations of the seed's files in one of the following ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter

NEW QUESTION NO: 14
In your database, USERSis the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true?
A. The MYTAB table is created in the USERStablespace but no rows can be inserted into the table by USER02.
B. The MYTABtable is owned by the SYSuser.
C. The MYTABtable is created in the SYSTEMtablespace and rows can be inserted into the table by USER02.
D. The MYTABtable is created in the SYSTEMtablespace but no rows can be inserted into the table by USER02.
E. The CREATE TABLE statement generates an error because the SYSDBAprivilege does not provide any space quota on the SYSTEMtablespace by default.
Answer: B,C

NEW QUESTION NO: 15
Which three statements are true about space usage alerts?
A. Alerts are issued only when the critical threshold for space available in a tablespace is breached.
B. The sum of active extents and allocated user quotas is considered to compute space usage for an undo tablespace.
C. Database alerts can provide warnings about low space availability at both tablespace and segment levels.
D. Alerts are not issued for locally managed tablespaces that are offline or in read-only mode.
E. A newly created locally managed tablespace is automatically assigned the default threshold values defined for a database.
Answer: A,D,E
Explanation/Reference:
References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#ADMIN10120

NEW QUESTION NO: 16
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?
A. RMAN CONVERT command
B. Data Pump Export and import
C. Conventional Export and Import
D. The BACKUP AS COPY DATABASE . . . command of RMAN
E. DBMS_FILE_TRANSFER with transportable tablespace
Answer: A,D
Explanation/Reference:
Explanation:
A:
1. Get the list of all datafiles.
Note: RMAN Backup of ASM Storage
There is often a need to move the files from the file system to the ASM storage and vice versa. This may come in handy when one of the file systems is corrupted by some means and then the file may need to be moved to the other file system.
D: Migrating a Database into ASM
* To take advantage of Automatic Storage Management with an existing database you must migrate that database into ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your primary backup and recovery strategy.
* Example:
Back up your database files as copies to the ASM disk group.
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE
FORMAT '+DISK' TAG 'ORA_ASM_MIGRATION';
References:

NEW QUESTION NO: 17
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
- Applications will connect to the database via a middle tier.
- The number of concurrent user connections will be high.
- The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
A. a General Purpose database template with default memory allocation
B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled
C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
D. a default database configuration
Answer: C
Explanation/Reference:
References: