Certified 1Z0-063 Exam Dumps 2021

NEW QUESTION 1
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)

• A. DATE
• B. TIMESTAMP
• C. INTERVAL YEAR TO MONTH
• D. INTERVAL DAY TO SECOND
• E. TIMESTAMP WITH LOCAL TIME ZONE

Answer: BE

NEW QUESTION 2
Your database is running in ARCHIVELOG mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1. Restore the corrupted redo log group.
2. Restore the database from the most recent database backup.
3. Perform an incomplete recovery.
4. Relocate the member of the damaged online redo log group to a new location.
5. Open the database with the RESETLOGS option.
6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.

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

Answer: C

NEW QUESTION 3
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

• A. Oracle Data Pump
• B. Oracle Recovery Manager (RMAN)
• C. Oracle Label Security
• D. Oracle Database Vault
• E. Oracle Real Application Security

Answer: B

NEW QUESTION 4
In a database supporting an OLTP workload, tables are frequently updated on both key and non-key columns. 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

NEW QUESTION 5
A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2. Issue ALTER SYSTEM SET CONTROL_FILES= ‘/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,
/u01/app/oracle/oradata/cdb1/disk2/control02, ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’ SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
‘/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’;.
4. Copy the control file from the existing location to ‘/u01/app/oracle/oradata/cdb1/disk3/control03.ctl’.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.

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

Answer: B

NEW QUESTION 6
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.)

• A. maximum undo per consumer group
• B. maximum idle time for a session in a PDB
• C. parallel server limit
• D. CPU
• E. maximum number of sessions for a PDB

Answer: CD

NEW QUESTION 7
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

• A. Use PDB$SEED for creating a PDB.
• B. Use the DBMS_PDB package 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_PDB package to plug a pre-Oracle 12c database into an existing CDB.

Answer: BCD

NEW QUESTION 8
Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

• A. Database Resident Connection Pooling
• B. Oracle Suggested Backup Strategy
• C. Database Vault in ORACLE_HOME
• D. Non default block size tablespaces
• E. Configure Label Security

Answer: CE

NEW QUESTION 9
You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema. Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS (‘SH’, 'CUSTOMERS') from dual
statement.
2. Execute the dbms_stats.seed_col_usage (null, ‘SH’, 500) procedure.
3. Execute the required queries on the customers table.
4. Issue the select dbms_stats.reportwcol_usage (‘SH’, 'customers') from dual statement. Identify the correct sequence of steps.

• A. 3, 2, 1, 4
• B. 2, 3, 4, 1
• C. 4, 1, 3, 2
• D. 3, 2, 4, 1

Answer: B

Explanation: Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns
within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statistics
Here are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.
2 – Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute (“exec”) statement, Oracle extended statistics are created via a select statement.

NEW QUESTION 10
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.)

• A. Only the used blocks in the data files are backed up.
• B. It backs up all the data files and deletes obsolete backups after the backup is complete.
• C. It backs up only those archived log files that are not backed up at least once.
• D. It backs up all the archived log files and deletes the ones that were just backed up.
• E. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete.

Answer: BD

Explanation: You can use BACKUP ... DELETE to back up archived redo logs, data file copies, or backup sets and then delete the input files after successfully backing them up.
The BACKUP ARCHIVELOG ... DELETE INPUT command deletes archived log files after they are backed up. This command eliminates the separate step of manually deleting archived redo logs.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2021), page 9-31

NEW QUESTION 11
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition: create table employees
(empno number, salary number, deptid number, name varchar2(100), period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

• A. The valid time columns employee_time_start and employee_time_end are automatically created.
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIODFOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is described.
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABC

Explanation: A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table’s definition in the case of which, the Period For clause would be creating them internally.

NEW QUESTION 12
For which two requirements would you use the Database Resource Manager? (Choose two.)

• A. limiting the CPU used per database call
• B. specifying the maximum number of concurrent sessions allowed for a user
• C. specifying the amount of private space a session can allocate in the shared pool of the SGA
• D. limiting the degree of parallelism of operations performed by a user or group of users
• E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Answer: DE

NEW QUESTION 13
Which three statements are true about Oracle Secure Backup (OSB)? (Choose three.)

• A. It can encrypt client data written to tape.
• B. It can be used to take image copy backups to tape.
• C. It can be used to manage tape backup and restore operations for multiple databases.
• D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.
• E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

Answer: ACE

NEW QUESTION 14
Which four actions are possible during an Online Datafile Move operation? (Choose four.)

• A. Creating and dropping tables in the datafile being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the datafile being moved
• D. Performing Block Media Recovery for a data block in the datafile being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the datafile being moved

Answer: ACDF

NEW QUESTION 15
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 16
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

• A. Set the backup_tape_io_slaves parameter to true.
• B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
• C. Configure large pool if not already done.
• D. Remove the rate parameter, if specified, in the allocate channel command.
• E. Always use RMAN compression for tape backups rather than the compression provided by media manager.
• F. Always use synchronous I/O for the database.

Answer: BCD

NEW QUESTION 17
Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost.
You want to recover the data file as quickly as possible while maximizing availability for the database. Examine the possible steps involved in the recovery process:
1. Mount the database.
2. Take the data file offline.
3. Bring the tablespace online.
4. Use the RMAN SWITCH command to switch to the image copy.
5. Recover the tablespace.
6. Open the database.
7. Use the RMAN RESTORE command to switch to the image copy. Identify the correct sequence of the required steps.

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

Answer: B

NEW QUESTION 18
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used? (Choose two.)

• A. RMAN recovery catalog
• B. RMAN Media Management Library
• C. Enterprise Manager Cloud Control
• D. Enterprise Manager Database Express
• E. Oracle Secure Backup

Answer: AC

NEW QUESTION 19
Which two statements are true regarding SecureFile lobs? (Choose two.)

• A. The amount of undo retained is user controlled.
• B. They can be used only for nonpartitioned tables.
• C. Fragmentation is minimized by using variable-sized chunks.
• D. They support random reads and writes of encrypted LOB data.

Answer: CD

NEW QUESTION 20
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