We offers oracle database 12c installation and administration 1z0 062 pdf. "Oracle Database 12c: Installation and Administration", also known as 1Z0-062 exam, is a Oracle Certification. This set of posts, Passing the 1Z0-062 exam with 1z0 062 pdf, will help you answer those questions. The 1z0 062 dumps covers all the knowledge points of the real exam. 100% real 1z0 062 dumps and revised by experts!
Oracle 1Z0-062 Free Dumps Questions Online, Read and Test Now.
NEW QUESTION 1
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:
Which two statements are true? (Choose two.)
- A. The C # # ROLE1 role is created in the root database and all the PDBs.
- B. The C # # ROLE1 role is created only in the root database because the container clause is not used.
- C. Privileges are granted to the C##A_ADMIN user only in the root database.
- D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
- E. The statement for granting a role to a user fails because the CONTAINER clause is not used.
Explanation: * You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.
* * CREATE ROLE with CONTAINER (optional) clause
/ CONTAINER = ALL Creates a common role.
/ CONTAINER = CURRENT
Creates a local role in the current PDB.
NEW QUESTION 2
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)
- A. SYSTEM
- B. SYSAUX
- C. EXAMPLE
- D. UNDO
- E. TEMP
- F. USERS
Explanation: * A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it.
* Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database.
Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX tablespaces in the seed PDB.
Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the CDB. Note:
SELECT tablespace_name FROM dba_tablespaces; TABLESPACE_NAME
SYSAUX TEMP USERS SQL>
NEW QUESTION 3
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
- A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.
- B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
- C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
- D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.
Explanation: * You can take an online tablespace offline so that it is temporarily unavailable for general use. The rest of the database remains open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users. The database must be open to alter the availability of a tablespace.
NEW QUESTION 4
Which three factors influence the optimizer's choice of an execution plan? (Choose three.)
- A. the optimizer_mode initialization parameter
- B. operating system (OS) statistics
- C. cardinality estimates
- D. object statistics in the data dictionary
- E. fixed baselines
NEW QUESTION 5
You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy? (Choose two.)
- A. Archived redo log files that have multiple copies in a different archive location
- B. user-managed backups of data files and control files
- C. RMAN backups that are obsolete
- D. flashback logs
NEW QUESTION 6
Which statement is true regarding the startup of a database instance?
- A. The instance does not start up normally and requires manual media recovery after a shutdown using the ABORT option.
- B. Uncommitted transactions are rolled back during the startup of the database instance after a shutdown using the immediate option.
- C. There is no difference in the underlying mechanics of the startup whether the database is shut down by using the IMMEDIATE option or the ABORT option.
- D. Media recovery is required when the database is shut down by using either the IMMEDIATE option or the ABORT option.
- E. Instance recovery is not required if the database instance was shut down by using SHUTDOWN IMMEDIATE.
NEW QUESTION 7
Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup.
In which three scenarios do you need media recovery? (Choose three.)
- A. loss of all the copies of the control file
- B. loss of all the inactive online redo log group members
- C. loss of a data file that belongs to the active undo tablespace
- D. loss of data files that belong to the SYSTEM tablespace
- E. logical corruption of data that is caused by a wrong transaction
- F. abnormal termination of the database instance
NEW QUESTION 8
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?
- A. The CDB must be open.
- B. The CDB must be in the mount stage.
- C. The CDB must be in the nomount stage.
- D. Alt existing PDBs must be closed.
Explanation: * Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.
NEW QUESTION 9
Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)
- A. All data definition language (DDL) statements are written to the control file
- B. Some DDL statements are written to an XML file in the ADR home
- C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
- D. Some data definition language (DDL) statements are written to the control file
- E. Some DDL statements are written to a text file in the ADR home
- F. The Alert Log still contains some DDL statements
NEW QUESTION 10
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
What are three possible causes for the latch-related wait events?
- A. The size of the shared pool is too small.
- B. Cursors are not being shared.
- C. A large number COMMITS are being performed.
- D. There are frequent logons and logoffs.
- E. The buffers are being read into the buffer cache, but some other session is changing the buffer
NEW QUESTION 11
Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)
- A. The PDB must be open in read only mode.
- B. The PDB must be dosed.
- C. The unplugged PDB becomes a non-CDB.
- D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
- E. The unplugged PDB can be plugged into another CDB.
- F. The PDB data files are automatically removed from disk.
Explanation: B, not A: The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB’s datafiles can remain in place.
NEW QUESTION 12
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs.
You execute the following command from the root container: SQL > REVOKE create table FROM C # # A_ADMIN; What is the result?
- A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
- B. It fails and reports an error because the CONTAINER=ALL clause is not used.
- C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
- D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
- E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
Explanation: REVOKE ..FROM
If the current container is the root:
/ Specify CONTAINER = CURRENT to revoke a locally granted system privilege, object privilege, or role from a common user or common role. The privilege or role is revoked from the user or role only in the root. This clause does not revoke privileges granted with CONTAINER = ALL.
/ Specify CONTAINER = ALL to revoke a commonly granted system privilege, object privilege on a common object, or role from a common user or common role. The privilege or role is revoked from the user or role across the entire CDB. This clause can revoke only a privilege or role granted with CONTAINER = ALL from the specified common user or common role. This clause does not revoke privileges granted locally with CONTAINER = CURRENT. However, any locally granted privileges that depend on the commonly granted privilege being revoked are also revoked.
If you omit this clause, then CONTAINER = CURRENT is the default. References:
NEW QUESTION 13
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?
- A. shutting down the database instance that is being upgraded
- B. executing the catctl.pl script to run the upgrade processes in parallel
- C. running the Pre-Upgrade Information Tool
- D. copying the listener.ora file to the new ORACLE_HOME
NEW QUESTION 14
You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure for a Standalone Server is already installed on the server.
Which three statements must be true for successful installation of the Oracle Database 12c software? (Choose three.)
- A. The OSBACKUPDBA, OSDGDBA, and OSKMDBA OS groups must be created.
- B. An operating system OSDBA group must be created for users with the SYSDBA system privilege.
- C. The Oracle Database 12c software owner and the Oracle Grid Infrastructure owner must belong to the same Oracle Inventory Group.
- D. The Oracle Database 12c installation must have a separate Oracle inventory directory.
- E. An operating system OSOPER group be created for users with the SYSOPER system privileg
NEW QUESTION 15
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new default value for numeric full redaction?
- A. Re-enable redaction policies that use FULL data redaction.
- B. Re-create redaction policies that use FULL data redaction.
- C. Re-connect the sessions that access objects with redaction policies defined on them.
- D. Flush the shared pool.
- E. Restart the database instance.
Explanation: About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* UPDATE_FULL_REDACTION_VALUES Procedure
This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
* After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
* Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by
low-privileged users or applications. You can redact column data by using one of the following methods:
/ Full redaction.
/ Partial redaction.
/ Regular expressions.
/ Random redaction.
/ No redaction.
NEW QUESTION 16
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command:
SQL > CREATE UNDO TABLESPACE undotb01
DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?
- A. It executes successfully and creates an UNDO tablespace in HR_PDB.
- B. It falls and reports an error because there can be only one undo tablespace in a CDB.
- C. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
- D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
- E. It executes successfully but neither tablespace nor the data file is created.
Explanation: Interesting behavior in 184.108.40.206 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.
When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.
NEW QUESTION 17
Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES
hr_admin, oe_admin; Which statement is true?
- A. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role.
- B. It fails because system privileges cannot be granted with roles in the same audit policy.
- C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
- D. It fails because the command does not specify when the unified audit policy should be enforce
100% Valid and Newest Version 1Z0-062 Questions & Answers shared by 2passeasy, Get Full Dumps HERE: https://www.2passeasy.com/dumps/1Z0-062/ (New 362 Q&As)