[Nov 28, 2021] Free 12c 1z0-063 Exam Question
1z0-063 dumps & 12c sure practice dumps
Conclusion
Now that you are clearly familiar with all the intricacies of the Oracle Database 12c: Advanced Administration 1Z0-063 exam, namely its objectives, process, and revision materials, you can see how having this certification can affect your future and career development. Even if you are already an Oracle Database 12c Administrator Certified Professional, don't be satisfied with what has been achieved. Set a new goal for yourself in the form of another prestigious certificate, start preparing for the related test with only credible sources, and continue on your career ladder, which will help you see new opportunities and/or stand out from other applicants for your desired position. Take the first step. After all, it is up to you!
NEW QUESTION 86
Which two are true about data dictionary views and contents and output in a CDB? (Choose two.)
- A. Data dictionary metadata for user-created objects is contained in PDB system tablespaces.
- B. Oracle-supplied data dictionary tables metadata is stored only in CDB$ROOT.
- C. The data dictionary in CDB$ROOTstores only metadata for objects common to all its PDBs.
- D. CDB_viewscan be queried only from CDB$ROOT.
- E. DBA_viewsare a superset of CDB_views.
Answer: B,D
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89248
NEW QUESTION 87
As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?
- A. Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.
- B. Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
- C. Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
- D. Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
Answer: A
NEW QUESTION 88
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
Which statement is true about granting the SELECT privilege on the DBA_USERS view to the c##ROLE1 role?
- A. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view in CDB$ROOT and all the PDBs.
- B. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view only in CDB$ROOT.
- C. The command fails because CONTAINER is not set to CURRENT.
- D. The command fails and gives an error because object privileges cannot be granted to a common user.
- E. The command succeeds and the common user C##ADMIN can create a session in CDB$ROOT and all the PDBs, but can only query the DBA_USERS view in CDB$ROOT.
Answer: A
NEW QUESTION 89
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
What is the outcome of the import?
- A. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
- B. It fails because RMAN is not connected to the target database with DBID=1423241.
- C. It fails because the target database and recovery catalog database are of different versions.
- D. It succeeds but the database is not automatically registered in the RC12c catalog.
Answer: C
NEW QUESTION 90
Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.
What must you do to make the database operational in OUSERVER1?
- A. Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location.
- B. Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files.
- C. Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files.
- D. Restore the control file from the backup by using the CATALOG option, restore the data files by using the SET NEWNAME command, and recover the data files.
Answer: D
Explanation:
Explanation
Catalog any backups not recorded in the repository with the CATALOG command.
Restore the data files to their original locations. If volume names have changed, then run SET NEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the data files, as shown in the following example.
Note: One way to name duplicate data files is to use the SET NEWNAME command before executing the DUPLICATE command. RMAN supports the following commands, listed in order of precedence:
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm
NEW QUESTION 91
Which two statements are true regarding Oracle Data Pump? (Choose two.)
- A. EXPDP and IMPDP are the client components of Oracle Data Pump.
- B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
- C. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
- D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
- E. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
Answer: A,B
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm
NEW QUESTION 92
The CATDB12Cdatabase contains an Oracle Database 12c catalog schema owned by the RC12Cuser.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:
What is the outcome of the import?
- A. It succeeds and all global scripts in the RC11catalog that have the same name as existing global scripts in the RC12Ccatalog are automatically renamed.
- B. It succeeds but the database is not automatically registered in the RC12ccatalog.
- C. It fails because RMAN is not connected to the target database with DBID=1423241.
- D. It fails because the target database and recovery catalog database are of different versions.
Answer: D
NEW QUESTION 93
In your database, there are tablespaces that were read-only when thelast 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 anincomplete recovery?
- A. All the read-only tablespaces should be restored separately.
- B. All the read-only tablespacesshould be made online with logging disabled.
- C. All the read-only tablespaces should be taken offline.
- D. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
Answer: A
NEW QUESTION 94
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back
up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to
remain open during the duplicate process. You restore the database backups to a new host with the same
directory structure as the production database and want to use the recovery catalog for future backups
after the database is successfully restored to the new host.
How would you achieve this?
- A. by using the RMAN SWITCHcommand to set the new location for the data files
- B. by using the RMAN DUPLICATEcommand with DBIDand SET NEWNAME FOR TABLESPACEto
recover the database to the new host - C. by using the RMAN DUPLICATEcommand with NOFILENAMECHECKto recover the database to the
new host - D. by creating a new database in the new host, and then using the RMAN RECOVERcommand
Answer: C
NEW QUESTION 95
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?
- A. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
- B. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
- C. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
- D. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
Answer: A
NEW QUESTION 96
You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?
- A. Enable Memory Access Mode, which reads performance data from SG
- B. Run ADDM in diagnostic mode.
- C. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
- D. Use emergency monitoring to fetch data directly from SGA for analysis.
- E. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
Answer: E
Explanation:
* In most cases, ADDM output should be the first placethat a DBA looks when notified of a performance problem.
* Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.
Reference: Resolving Performance Degradation Over Time
NEW QUESTION 97
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).
- A. to automatically delete obsolete backups after a specified period of time
- B. to store backup information of multiple databases in one place
- C. to restrict the amount of space that is used by backups
- D. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog
- E. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
Answer: B,D,E
NEW QUESTION 98
Which two are benefits of unified auditing in full mode? (Choose two.)
- A. The audit trail is in a single format.
- B. All audit data is written to both the traditional locations and to the unified location.
- C. The audit trail uses less space.
- D. The audit trail is read-only.
- E. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.
Answer: A,D
NEW QUESTION 99
You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation? (Choose two.)
- A. You must have full or level-0 backups to restore blocks.
- B. You must use an incremental level-1 backup to restore blocks.
- C. You must configure a block change tracking file.
- D. You must take the tools01.dbf data file offline.
- E. You must ensure that the database is mounted or open.
Answer: A,E
Explanation:
Explanation
The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be proxy copies or incremental backups.
Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 19-4
NEW QUESTION 100
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
- A. By default, EM express is available for a database after database creation.
- B. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- C. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
- D. You can use EM express to manage multiple databases running on the same server.
- E. You can create and configure pluggable databases by using EM express.
Answer: A
Explanation:
EM Express is built inside the database.
Note: Oracle Enterprise Manager Database Express (EM Express) is a web-based database management tool that is built inside the Oracle Database. It supports key performance management and basicdatabase administration functions. From an architectural perspective, EM Express has no mid-tier or middleware components, ensuring that its overhead on the database server is negligible.
NEW QUESTION 101
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?
- A. RMAN always performs this type of backup in parallel.
- B. The backup set size is limited to 300 MB.
- C. The resulting backupset has backup pieces that cannot exceed 300 MB.
- D. RMAN uses multiplexing to perform the backup.
- E. The backup succeeds only if the USERS tablespace is locally managed.
Answer: C
NEW QUESTION 102
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
Which statement is true about the execution of the last command?
- A. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
- B. It fails and returns an error because a connection is not made by using the sysdba privilege.
- C. It succeeds and displays all the tablespaces that belong to the root database.
- D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
Answer: A
NEW QUESTION 103
......
Oracle 1z0-063 Actual Questions and Braindumps: https://www.examsreviews.com/1z0-063-pass4sure-exam-review.html