The Secret Of Oracle 1Z0-063 Free Exam

NEW QUESTION 1

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 2

Which two statements are true about a common user? (Choose two.)

• A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
• B. A common user with the CREATE USER privilege can create other common users, as well as local users.
• C. A common user can be granted only a common role.
• D. A common user can have a local schema in a PDB.
• E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Answer: BD

NEW QUESTION 3

Which three statements are true about persistent lightweight jobs? (Choose three.)

• A. A user cannot set privileges on them.
• B. They generate large amounts of metadata.
• C. They may be created as fully self-contained jobs.
• D. They must reference an existing Scheduler Program.
• E. They are useful when users need to create a large number of jobs quickly.

Answer: ADE

NEW QUESTION 4

You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

• A. Drop the TEMP tablespace, and then re-create it with new temp files.
• B. Restart the database instance to create the temp file automatically.
• C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
• D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Answer: BC

Explanation:
Temp files are a special class of data files that are associated only with temporary tablespaces.
B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN does not re-create the temp file.
If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations.
C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.
References: https://docs.oracle.com/database/121/ADMIN/dfiles.htm https://docs.oracle.com/database/121/BRADV/rcmcomre.htm

NEW QUESTION 5

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? (Choose two.)

• 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 Oracle Restart configuration.
• C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
• D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation iscomplete.
• E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Answer: CE

Explanation:
https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

NEW QUESTION 6

For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

• A. It returns an error because there is no level 0 backup available for new data files.
• B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.
• C. It performs a level-0 backup of all data files including those that belong to the new tablespace.
• D. It performs an image copy backup of all data files including those that belong to the new tablespace.
• E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Answer: B

NEW QUESTION 7

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?

• A. Database Replay
• B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
• C. Active Session History (ASH) report
• D. SQL Performance Analyzer

Answer: B

NEW QUESTION 8

Examine the following set of RMAN commands:

Which statement is true about the RMAN RUN block execution?

• A. The script is executed and both DC1 and CH1 channels are used for script execution.
• B. The execution of the script fails because multiple channels cannot exist simultaneously.
• C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
• D. The new channel, CH1, is ignored because a channel has been configured already.

Answer: C

NEW QUESTION 9

Examine the output:
SQL> ARCHIVE LOG LIST
Database log modeArchive Mode Automatic archival Enabled
Archive DestinationUSE_DB_RECOVERY_FILE_DEST Oldest online log sequence376
Next log sequence to archive378 Current log sequence378
Which three types of files are automatically placed in the fast recovery area? (Choose three.)

• A. Flashback data archives (FDA)
• B. Archived redo log files
• C. Control file autobackups
• D. Server parameter file (SPFILE)
• E. Recovery Manager (RMAN) backup pieces

Answer: BCE

NEW QUESTION 10

You restore and recover your database to a new host by using an existing RMAN open database backup. Which step must you perform next?

• A. Execute catproc.sql to recompile invalid PL/SQL modules.
• B. Open the database with the RESETLOGS option.
• C. Set a new database identifier (DBID) for the newly restored database.
• D. Use the RMAN SET NEWNAME and SWITCH commands to switch to new files.

Answer: B

NEW QUESTION 11

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

NEW QUESTION 12

Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database? (Choose two.)

• A. Enable minimal supplemental logging.
• B. 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.
• C. Enable the recyclebin.
• D. Enable undo retention guarantee.
• E. Enable Fast Recovery Area.

Answer: BE

NEW QUESTION 13

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 14

You execute the commands to configure settings in RMAN:

Then, you issue the following command to take a backup:

Which statement is true about the execution of these commands?

• A. The backup terminates because the backup destination for disk is not specified in the BACKUP command.
• B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
• C. It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.
• D. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

Answer: D

NEW QUESTION 15

Examine the RMAN command:

Which statement is true about the command?

• A. It creates compressed backup sets.
• B. It uses asynchronous I/O for the backup.
• C. It uses parallelization for the backup set.
• D. It uses multisection backup.

Answer: C

Explanation:
SBT stands for Serial Backup Tape.
Configuring Parallel Channels for Disk and SBT Devices
The number of channels available for a device type when you run a command determines whether RMAN reads or writes in parallel. As a rule, the number of channels used in executing a command should match the number of devices accessed.
For tape backups, allocate one channel for each tape drive.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 5-6

NEW QUESTION 16

Which two operations are NOT performed by the DUPLICATE command in RMAN while duplicating a database that is open? (Choose two.)

• A. creating a control file for the duplicate database
• B. restoring target data files to the duplicate database
• C. performing complete recovery by using all available backups
• D. generating a new, unique database identifier (DBID) for the duplicate database
• E. copying online redo log files from the target database to the duplicate database

Answer: CE

NEW QUESTION 17

Which three statements are true about Oracle Restart? (Choose three.)

• A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
• B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
• C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
• D. It can be used to only start Oracle components.
• E. It runs periodic check operations to monitor the health of Oracle components.

Answer: ABE

NEW QUESTION 18

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A. Compare Period ADDM report
• B. AWR Compare Period report
• C. Active Session History (ASH) report
• D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: B

Explanation:
The awrddrpt.sql report is the Automated Workload Repository Compare Period Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin directory.

NEW QUESTION 19

Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

• A. loss of a non-critical data file
• B. loss of a control file
• C. physical data block corruption
• D. logical data block corruption
• E. loss of an archived redo log file

Answer: BCE

NEW QUESTION 20

Consider the following scenario for your database: Backup optimization is enabled in RMAN.
The recovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1, 2013. The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk. Which statement is true about the backup of the tools tablespace?

• A. The RMAN backup fails because the tools tablespace is read-only.
• B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
• C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
• D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

Answer: D

NEW QUESTION 21

Which two statements are true when row-archival management is enabled? (Choose two.)

• A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
• B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• C. The row archival visibility session parameter defaults to all rows.
• D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Answer: BD

NEW QUESTION 22

Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.

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

Answer: A

Explanation:
The storage selector act as a layer between RMAN, which accesses the database, and the Oracle Secure Backup software, which manages the backup media.
For backups, Oracle Secure Backup stores metadata about RMAN backup pieces in the Oracle Secure Backup catalog.
The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm

NEW QUESTION 23

Which three statements are true about the database instance startup after an instance failure? (Choose three.)

• A. The RECO process recovers the uncommitted transactions at the next instance startup.
• B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.
• C. Uncommitted changes are rolled back to ensure transactional consistency.
• D. The SMON process coordinates the database recovery.
• E. Media recovery is required to complete the database recovery.
• F. Changes committed before the failure, which were not written to the data files, are re-applied.

Answer: ACD

Explanation:
A: Occasionally a database closes abnormally with one or more distributed transactions in doubt (neither committed nor rolled back). When you reopen the database and recovery is complete, the RECO background process automatically, immediately, and consistently resolves any in-doubt distributed transactions.
C: Crash and instance recovery involve two distinct operations: rolling forward the current, online datafiles by applying both committed and uncommitted transactions contained in online redo records, and then rolling back changes made in uncommitted transactions to their original state.
D: The SMON background process performs instance recovery, applying online redo automatically. No user intervention is required.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm https://docs.oracle.com/database/121/CNCPT/startup.htm

NEW QUESTION 24

Your database is running in archivelog mode. Examine the parameters for your database instance: LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

• A. The database instance hangs and the redo log files are not overwritten.
• B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
• C. The database instance is shutdown immediately.
• D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

NEW QUESTION 25
......