[Dec-2021] Pass Oracle 1z0-063 Exam in First Attempt Guaranteed!
Full 1z0-063 Practice Test and 278 unique questions with explanations waiting just for you, get it now!
NEW QUESTION 74
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1.Place all the user-defined tablespace in read-only mode on the source database.
2.Upgrade the source database to a 12c version.
3.Create a new PDB in the target container database.
4.Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility.
5.Copy the associated data files and export the dump file to the desired location in the target database.
6.Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7.Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.
- A. 1, 3, 4, 5, 6, 7
- B. 1, 5, 6, 4, 3, 2
- C. 1, 4, 3, 5, 6, 7
- D. 2, 1, 3, 4, 5, 6, 7
- E. 2, 1, 3, 4, 5, 6
Answer: C
NEW QUESTION 75
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 maximum size for the standard buffer cache is 100 MB.
- B. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
- C. The minimum size for the standard buffer cache is 100 MB.
- D. The minimum size for all buffer caches is 100 MB.
- E. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
Answer: C
NEW QUESTION 76
Which three statements are true about Oracle Restart?
- A. It runs periodic check operations to monitor the health of Oracle components.
- B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
- C. It can be configured to automatically attempt to restart various components after a hardware or software failure.
- D. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
- E. It can be used to only start Oracle components.
Answer: A,B,C
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm
NEW QUESTION 77
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true? (Choose two.)
- A. A suspended statement will report an error if no corrective action has taken place during a timeout period.
- B. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
- C. A resumable statement can be suspended and resumed only once during execution.
- D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
- E. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
Answer: A,D
Explanation:
Explanation/Reference:
NEW QUESTION 78
Examine the command used to perform an incremental level-0 backup:
RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation? (Choose two.)
- A. The block change tracking data is used for the next incremental level 1 backup only after the next level
0 backup. - B. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
- C. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
- D. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
- E. The block change tracking data is used only from the next incremental backup.
Answer: A,D
NEW QUESTION 79
You want to back up a database such that only formatted blocks are backed up. Which statement is true
about this backup operation?
- A. The database must be backed up as an image copy.
- B. The tablespace must be taken offline.
- C. The backup must be performed in mount state.
- D. All files must be backed up as backup sets.
Answer: D
NEW QUESTION 80
Which two statements are true about making RMAN image copies of a database? (Choose two.)
- A. They consist of all used an unused blocks in the data files.
- B. The can be made only when the database is running in NOARCHIVELOG mode.
- C. The can only be written to disk.
- D. They can be made only when the database is in MOUNT state.
- E. They can be made only when the database is running in ARCHIVELOG mode.
Answer: A,C
Explanation:
Explanation
An image copy can be written only to disk.
An image copy is the same as datafiles. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks.
http://www.dba-oracle.com/t_rman_10_image_copies.htm
NEW QUESTION 81
View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start?
- A. because pga_aggregate_target is not set
- B. because statistics_level is set to basic
- C. because sga_target and memory_target are both set
- D. because memory_target and memory_max_target cannot be equal
Answer: B
NEW QUESTION 82
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)
- A. PDB data files are automatically removed from disk.
- B. A PDB must have been opened at least once after creation.
- C. A PDB must be in closed state before it can be unplugged.
- D. A PDB must be in MOUNT state before it can be unplugged.
- E. An unplugged PDB can be plugged into the same or another container database (CDB).
Answer: B,C,E
Explanation:
Explanation
A: To unplug a PDB, you first close it.
E: You can disassociate or unplug a PDB from a CDB and reassociate or plug the PDB into the same CDB or into another CDB.
NEW QUESTION 83
Which two statements are true about unified auditing?
- A. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
- B. Audit records are created only for the DML and DDL operations performed on database objects.
- C. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
- D. A unified audit trail captures audit information from unified audit policies and audit settings.
- E. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
- F. Audit records are created for all users except sys.
Answer: C,D
NEW QUESTION 84
Your database has a table customer that contains the columns cust_name, amt_due, and old_status.
Examine the commands executed and their output:
Why is it that only one update is listed by the Flashback Version Query?
- A. Supplemental logging is not enabled for the database.
- B. Flashback Data Archive is full after the first update statement.
- C. The db_flashback_retention_target parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
- D. The undo data that existed for versions of rows before the change to the table structure is invalidated.
- E. Undo retention guarantee is not enabled.
Answer: C
NEW QUESTION 85
Your database is on ARCHIVELOG mode and an incremental backup exists.
A media failure in the loss of a data file and an online redo log.
Examine these commands:
1. STARTUP NOMOUNT
2. STARTUP MOUNT
3. RESTORE DATABASE
4. RECOVER DATABASE
5. RECOVER DATABASE UNTIL CANCEL
6. ALTER DATABASE OPEN
7. ALTER DATABASE OPEN RESETLOGS
Which commands are required to recover your database?
- A. 2, 3, 5, and 6
- B. 1, 3, and 4
- C. 1, 3, 5, and 6
- D. 2, 3, and 4
- E. 2, 3, 5, and 7
Answer: B
NEW QUESTION 86
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. Active Session History (ASH) report
- C. AWR Compare Period report
- D. Taking a new snapshot and comparing it with a preserved snapshot
Answer: C
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.
Incorrect Answers:
A: Compare Period ADDM is used to perform a high-level comparison of one workload replay to its capture or to another replay of the same capture. Only workload replays that contain at least 5 minutes of database time can be compared using this report.
NEW QUESTION 87
Which three statements are true about the SQL*Loader utility? (Choose three.)
- A. It can be used to generate unique sequential values in specified columns while loading data.
- B. It can be used to load data from multiple external files into multiple tables.
- C. It can be used to extract and reorganize data from external files, and then load it into a table.
- D. It can be used to create tables using data that is stored in external files.
- E. It can be used to load data from external files using direct path only.
Answer: A,B,C
NEW QUESTION 88
You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11-see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf' To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?
- A. The command performs the recovery and closes the failure.
- B. The command produces an error because RMAN is not connected to the target database pdb_1.
- C. The command executes successfully, performs recovery, and opens PDB_1.
- D. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILUER command.
Answer: C
NEW QUESTION 89
A database instance uses an SPFILE. Examine the parameter:
You plan to multiplex the control file to a new location, /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, /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. 2, 1, 4, 6
- B. 1, 5, 2, 4, 6
- C. 3, 1, 4, 6
- D. 3, 4
- E. 2, 6
Answer: C
Explanation:
Explanation/Reference:
Explanation:
You can create an additional control file copy for multiplexing by copying an existing control file to a new location and adding the file name to the list of control files.
Similarly, you rename an existing control file by copying the file to its new name or location, and changing the file name in the control file list. In both cases, to guarantee that control files do not change during the procedure, shut down the database before copying the control file.
To add a multiplexed copy of the current control file or to rename a control file:
1. Shut down the database.
2. Copy an existing control file to a new location, using operating system commands.
3. Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control file name, or to change the existing control filename.
4. Restart the database.
NEW QUESTION 90
For which two requirements would you use the Database Resource Manager?
- A. specifying the amount of private space a session can allocate in the shared pool of the SGA
- B. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
- C. specifying the maximum number of concurrent sessions allowed for a user
- D. limiting the CPU used per database call
- E. limiting the degree of parallelism of operations performed by a user or group of users
Answer: B,C
NEW QUESTION 91
You accidentally drop the CUSTOMERStable, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table?
- A. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
- B. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
- C. All the triggers associated with the table are flashed back but are disabled.
- D. Materialized views that use the CUSTOMERS table are flashed back.
- E. LOB segments associated with the CUSTOMERStable are flashed back.
Answer: A,E
Explanation:
Explanation/Reference:
B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.
Incorrect Answers:
A: Flashback Table restores tables while automatically maintaining associated attributes such as current indexes, triggers, and constraints, and in this way enabling you to avoid finding and restoring database- specific properties.
Furthermore. indexes on table that exist currently are reverted and reflect the state of the table at the Flashback point.
C: By default, the database disables triggers on the affected table before performing a FLASHBACK TABLE operation. After the operation, the database returns the triggers to the state they were in before the operation (enabled or disabled). To keep triggers enabled during the flashback of the table, add an ENABLE TRIGGERS clause to the FLASHBACK TABLE
D: Flashback Table operations are not valid for the following type objects: tables that are part of a cluster, materialized views, Advanced Queuing (AQ) tables, static data dictionary tables, system tables, remote tables, object tables, nested tables, or individual table partitions or subpartitions.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page
18-11
NEW QUESTION 92
You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
- A. Flashback must be enabled for the PROD database.
- B. A most recent backup set of the PROD database must exist.
- C. The target database must be in MOUNT state.
- D. RMAN must be connected to the target database instance and the auxiliary instance.
Answer: D
Explanation:
Explanation
Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2.
You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1'
SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 26-7
NEW QUESTION 93
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 94
......
Get Latest 1z0-063 Dumps Exam Questions in here: https://www.exams4collection.com/1z0-063-latest-braindumps.html
