Oracle 1Z0-063 Free Practice Questions 2021

NEW QUESTION 1
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)

• A. Tables or table partitions can be recovered by using an auxiliary instance only.
• B. Tables or table partitions with a foreign key cannot be recovered.
• C. Tables or table partitions can be recovered only when the database is in MOUNT state.
• D. Tables or table partitions from the SYSTEM and SYSAUX tablespaces cannot be recovered.
• E. Tables with NOT NULL constraints cannot be recovered.

Answer: AD

NEW QUESTION 2
You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

• A. all users except sys
• B. all users except scott
• C. all users except sys and scott
• D. all users except sys, system, and scott

Answer: B

NEW QUESTION 3
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC? (Choose three.)

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

Explanation: HCC requires the use of Oracle Storage – Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition
11.2.1.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

NEW QUESTION 4
Which two are prerequisites for creating a backup-based duplicate database? (Choose two.)

• A. connecting to the target database and a recovery catalog to execute the DUPLICATE command
• B. creating a password file for an auxiliary instance
• C. connecting to an auxiliary instance
• D. matching the database identifier (DBID) of the source database and the duplicate database
• E. creating an SPFILE for the target database

Answer: AB

NEW QUESTION 5
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: A

NEW QUESTION 6
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

• A. The minimum size for the standard buffer cache is 100 MB.
• B. The maximum size for the standard buffer cache is 100 MB.
• C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
• D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
• E. The minimum size for all buffer caches is 100 MB.

Answer: A

NEW QUESTION 7
You created a tablespace with this statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this? (Choose two.)

• A. ALTER TABLESPACE adtbs RESI2E 20G;
• B. ALTER TABLESPACE adtbs ADD DATAFILE;
• C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
• D. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
• E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;

Answer: AC

Explanation: http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php

NEW QUESTION 8
You are administering a multitenant container database (CDB) that contains two pluggable databases (PDBs), PDB1 and PDB2. You are connected to PDB2 as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB modifiable. As the user SYS, execute the following command on PDB2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

• A. The STATISTICS_LEVEL parameter is set to ALL when any of the PDBs is reopened.
• B. The STATISTICS_LEVEL parameter is set to ALL only for PDB2 when it is reopened.
• C. The STATISTICS_LEVEL parameter is set to ALL when the root database is restarted.
• D. The statement is ignored because there is no SPFILE for a PDB.

Answer: B

NEW QUESTION 9
Which two statements are true about RMAN duplexed backups? (Choose two.)

• A. It is only supported for backups to tape via media management interface.
• B. It is not supported for image copies.
• C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
• D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
• E. Duplex backups can contain only data files and control files.

Answer: BD

NEW QUESTION 10
Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN.
Identify the minimum requirement for accomplishing the task.

• A. An RMAN channel must be configured to device-type disk.
• B. The database must be configured in ARCHIVELOG mode.
• C. Redo log groups must have at least two members each.
• D. All tablespaces in the database must be locally managed.

Answer: B

NEW QUESTION 11
user_data is a non-encrypted tablespace containing tables with data. You must encrypt all data in this tablespace.
Which three methods can do this? (Choose three.)

• A. Use Data Pump.
• B. Use ALTERTABL
• C. . .MOVE
• D. Use CREATE TABLE AS SELECT
• E. Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space
• F. Use altertablespace to encrypt the tablespace.

Answer: ABC

NEW QUESTION 12
Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

• A. Transparent encryption of backups uses an encryption wallet.
• B. A database uses the same encryption key for every encrypted backup.
• C. A password encryption of backups uses the password while creating and restoring backups.
• D. Image copy backups can be created by using password encryption.
• E. Encrypted backups can only be written to disk.

Answer: AC

NEW QUESTION 13
Which two statements are true about Flashback Version Query? (Choose two.)

• A. The result of a query can be used as part of a DML statement.
• B. It can be used to create views.
• C. It can be used only if Flashback Data Archive is enabled for a table.
• D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
• E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer: DE

NEW QUESTION 14
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database. Identify the required steps in the correct order.

• A. 2, 4, and 3
• B. 2, 4, 3, and 5
• C. 1, 5, 2, 4, 3, and 6
• D. 1, 2, 4, 3, and 6

Answer: D

Explanation: Step 1 (1): To copy tablespaces from one database to another using transportable tablespace, the source tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source database to target database (using any available methods like scp, sftp, rcp, etc).
Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of the tablespaces that needs to transported using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that needs to be transported, we need to copy the Export Dump file as well as all the datafiles belonging to the tablespaces to be transported to the target database server.
References:
http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/

NEW QUESTION 15
You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?

• A. A custom database template
• B. AData Warehouse database template
• C. Automatic Storage Management (ASM) for storage of data files
• D. A file system for storage of data files

Answer: A

NEW QUESTION 16
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

• A. configuration of unified auditing mode
• B. execution of SQL statements by users connected with the SYSDBA privilege
• C. usage of the AUDIT statement
• D. creation of a fine grained audit policy

Answer: C

NEW QUESTION 17
A database is running in ARCHIVELOG mode. The database contains locally managed tablespaces. Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET SECTION SIZE 1024M DATABASE;
Which statement is true about the execution of the command?

• A. The backup succeeds only if all the tablespaces are locally managed.
• B. The backup succeeds only if the RMAN default device for backup is set to disk.
• C. The backup fails because you cannot specify section size for a compressed backup.
• D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Answer: D

NEW QUESTION 18
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. The password for the encryption must be set up.
• B. Oracle wallet for the encryption must be set up.
• C. All the tablespaces in the database must be encrypted.
• D. Oracle Database Vault must be enabled.

Answer: B