1z0-062 Practice Dumps - Verified By ExamTorrent Updated 380 Questions
Updated 1z0-062 Exam Dumps - PDF Questions and Testing Engine
Conclusion
In summary, it should be recalled that Oracle Database 12c designations accentuate the full set of skills required to work with the DBMS for daily operational management and maintenance. Currently, in the competitive market, it is common practice to validate your skills and experience through certification by nailing the corresponding exam. So, successfully passing the Oracle Database 12c Administration 1Z0-062 test will not only be a shining point on your CV but will also open new doors for you on your path to mastering the Oracle Database environment. All you have to do is make a firm decision, register for the actual exam, and start preparing. You have all the power here!
Oracle 1z0-062 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
Oracle 1Z0-062 Dumps
Oracle 12c Dumps are tests created to demonstrate all the features of our Oracle 12c Questions Web Simulator. You will be able to access to many questions and will have the ability to test your knowledge on-line.
There are several components you can interact with when you take our practice tests:
- if you want to take a look at the correct answers for a question, just click the “Solution” button. In the solution section you will be able to check your answers as well as find a full explanation.
- Once the test is submitted, the result section will expand. Here, you will be able to review all the questions of the test. From here, you can also navigate directly to each question.
- Read the question and select only the answer(s) you think are correct by checking the corresponding check box.
- Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
- Mark the Oracle 12c Certification Questions you wish to review later. All the questions you have marked will be listed in the right section “marked questions”. You will be able to jump directly to the question from this list.
- Keep an eye on the countdown. This will tell you how much time is left. When the countdown expires, the test will be automatically submitted.
NEW QUESTION 224
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted?
- A. SCOTT sessions, only if the MGR role is set in the session
- B. SCOTT sessions, because he is the owner of the table
- C. SYSTEM session, only if the MGR role is set in the session
- D. SYS sessions, regardless of the roles that are set in the session
- E. SCOTT sessions, only if the MGR role is granted to SCOTT
- F. SYSTEM sessions, regardless of the roles that are set in the session
Answer: C,D,E
Explanation:
Explanation/Reference:
Explanation:
* SYS_CONTEXT
This is a twist on the SYS_CONTEXT function as it does not use USERENV. With this usage SYS_CONTEXT queries the list of the user's current default roles and returns TRUE if the role is granted.
Example:
SYS_CONTEXT('SYS_SESSION_ROLES', 'SUPERVISOR')
conn scott/tiger@pdborcl
SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE')
FROM dual;
SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR')
---------------------------------------------
FALSE
conn sys@pdborcl as sysdba
GRANT resource TO scott;
conn scott/tiger@pdborcl
SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE')
FROM dual;
SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR')
---------------------------------------------
TRUE
NEW QUESTION 225
Which four actions are possible during an Online Data file Move operation? (Choose four.)
- A. Querying tables in the data file being moved
- B. Performing Block Media Recovery for a data block in the data file being moved
- C. Performing file shrink of the data file being moved
- D. Executing DML statements on objects stored in the data file being moved
- E. Flashing back the database
- F. Creating and dropping tables in the data file being moved
Answer: A,D,E,F
Explanation:
Explanation/Reference:
Explanation:
- You can now move On line Datafile without hove to stop Monoged Recovery and manually copy and rename Files. This can even be used to move Datafiles from or to ASM.
- New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active Data Guard Mode (opened READ ONLY and Managed Recovery is running):
It is now possible to online move a Datafile while Managed Recovery is running, ie. the Physical Standby Database is in Active Data Guard Mode. You can use this Command to move the Datafile
- A flashback operation does not relocate a moved data file to its previous location. If you move a data file online from one location to another and later flash back the database to a point in time before the move, then the Data file remains in the new location, but the contents of the Data file ore changed to the contents at the time specified in the flashback. Oracle0 Database Administrator's Guide 12c Release 1 (12.1)
NEW QUESTION 226
The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?
- A. The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.
- B. The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.
- C. Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.
- D. The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
Answer: A
NEW QUESTION 227
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:
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 are not populated by the Oracle Server automatically.
- B. 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.
- C. The valid time columns employee_time_start and employee_time_end are automatically created.
- D. The valid time columns are visible by default when the table is described.
- E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
Answer: A,C,E
NEW QUESTION 228
Which two statements correctly describe the relationship between data files and logical database structures?
- A. The size of an Oracle data block in a data file should be the same as the size of an OS block.
- B. A data file can belong to only one tablespace.
- C. A segment cannot span data files.
- D. An extent cannot span data files.
Answer: B,D
NEW QUESTION 229
Identify two prerequisites for configuring Enterprise Manager Database Express (EM
Express).
- A. Use theDBMS_XDB_CONFIG.SETHTTPPORTprocedure to configure a portnumber for
Oracle HTTP Server. - B. Grant theAPEX_PUBLIC_USERrole to theSYSMANuser.
- C. Configure at least one dispatcher for the TCP/IP protocol.
- D. Install Oracle HTTP Server.
- E. Create aSYSMANuser with theSYSDBAprivilege as an administrator for EM Express.
Answer: C,E
NEW QUESTION 230
The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE
OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.
Identify the correct sequence of steps:
- A. 2, 1, 4, 3, 5
- B. 2, 4, 5
- C. 1, 2, 4, 5
- D. 1, 2, 3, 4, 5
Answer: A
Explanation:
Explanation/Reference:
Explanation:
* Evolving SQL Plan Baselines
* 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description.
1. Set the evolve task parameters.
SET_EVOLVE_TASK_PARAMETER
This function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.
3: IMPLEMENT_EVOLVE_TASK
This function implements all recommendations for an evolve task. Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input parameters include task name, plan name, owner name, and execution name.
5. Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function.
This function displays the results of an evolve task as a CLOB. Input parameters include the task name and section of the report to include.
References:
NEW QUESTION 231
Which three statements are true concerning the multitenant architecture? (Choose three.)
- A. A PDB can have a private temp tablespace.
- B. Each pluggable database (PDB) has its own set of background processes.
- C. Different PDBs can have different default block sizes.
- D. Log switches occur only at the multitenant container database (CDB) level.
- E. Instance recovery is always performed at the CDB level.
- F. PDBs share a common system tablespace.
- G. PDBs can share the sysaux tablespace.
Answer: A,D,E
Explanation:
Explanation
B:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces. It can also contains other user created tablespaces in it.
* There is one default temporary tablespace for the entire CDB. However, you can create additional temporary tablespaces in individual PDBs.
D:
* There is a single redo log and a single control file for an entire CDB
* A log switch is the point at which the database stops writing to one redo log file and begins writing to another. Normally, a log switch occurs when the current redo log file is completely filled and writing must continue to the next redo log file.
G: instance recovery
The automatic application of redo log records to uncommitted data blocks when an database instance is restarted after a failure.
Incorrect:
Not A:
* There is one set of background processes shared by the root and all PDBs.
* High consolidation density. The many pluggable databases in a single container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture.
Not C: There is a separate SYSAUX tablespace for the root and for each PDB.
Not F: There is a separate SYSTEM tablespace for the root and for each PDB.
NEW QUESTION 232
Which are three of the input sources for the SQL Tuning Advisor? (Choose three.)
- A. the Automatic Workload Repository (AWR)
- B. the shared SQL area
- C. the AWR Compare Periods Report
- D. the private SQL area
- E. the SQL Access Advisor
- F. the Automatic Database Diagnostic Monitor (ADDM)
Answer: A,E,F
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/sql_tune.htm#i34782
NEW QUESTION 233
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 falls and reports an error because there can be only one undo tablespace in a CD
- B. It executes successfully and creates an UNDO tablespace in HR_PDB.
- C. It executes successfully but neither tablespace nor the data file is created.
- D. It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
- E. It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
Answer: C
Explanation:
Interesting behavior in 12.1.0.1 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 234
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? (Choose two.)
- A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- B. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- C. Setting the target tablespace to read-only
- D. Setting the target tablespace offline
- E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
Answer: B,C
Explanation:
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.
NEW QUESTION 235
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. EXAMPLE
- B. SYSTEM
- C. UNDO
- D. TEMP
- E. SYSAUX
- F. USERS
Answer: B,D,E
Explanation:
Explanation/Reference:
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.
* tablespace_datafile_clauses
Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX tablespaces
in the seed PDB.
Incorrect:
Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the
CDB.
Note:
* Example:
CONN pdb_admin@pdb1
SELECT tablespace_name FROM dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
TEMP
USERS
SQL>
NEW QUESTION 236
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)
- A. The size of an Oracle data block in a data file should be the same as the size of an OS block.
- B. A data file can belong to only one tablespace.
- C. A segment cannot span data files.
- D. An extent cannot span data files.
Answer: B,D
Explanation:
A single extent can never span data files.
https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1095
NEW QUESTION 237
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts
you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?
- A. The installation is being performed by the root user.
- B. The ORACLE_BASE base parameter is not set.
- C. The operating system group that is specified must have permission to write to the inventory directory.
- D. The operating system group that is specified should have the root user as its member.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of
the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle
software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.
NEW QUESTION 238
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
- A. SCOTT sessions, only if the MGR role is set in the session
- B. SYSTEM sessions, regardless of the roles that are set in the session
- C. SCOTT sessions, because he is the owner of the table
- D. SYS sessions, regardless of the roles that are set in the session
- E. SCOTT sessions, only if the MGR role is granted to SCOTT
- F. SYSTEM session, only if the MGR role is set in the session
Answer: B,D,E
NEW QUESTION 239
Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday
Which three statements are true about the strategy? (Choose three.)
- A. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
- B. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
- C. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
- D. Level 0 backup on Sunday contains all the blocks that have been formatted.
- E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.
Answer: A,B,D
NEW QUESTION 240
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?
- A. The database must be opened in restricted mode for the flashback to succeed.
- B. The database must have multiplexed redo logs for the flashback to succeed.
- C. The database must be MOUNTED for the flashback to succeed.
- D. The database must use block change tracking for the flashback to succeed.
- E. The database must be opened with the RESETLOGS option after the flashback is complete.
- F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
Answer: C,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 241
Which two statements correctly describe the relationship between data files and logical database structures?
(Choose two.)
- A. The size of an Oracle data block in a data file should be the same as the size of an OS block.
- B. A data file can belong to only one tablespace.
- C. A segment cannot span data files.
- D. An extent cannot span data files.
Answer: B,D
Explanation:
Explanation
A single extent can never span data files.
https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1095
NEW QUESTION 242
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
- A. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
- B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
- C. Online Table Redefinition.
- D. Oracle Data Pump.
- E. Edition-Based Table Redefinition.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
* Oracle Database provides a mechanism to make table structure modifications without significantly affecting the availability of the table. The mechanism is called online table redefinition. Redefining tables online provides a substantial increase in availability compared to traditional methods of redefining tables.
* To redefine a table online:
Choose the redefinition method: by key or by rowid
* By key—Select a primary key or pseudo-primary key to use for the redefinition. Pseudo-primary keys are unique keys with all component columns having NOT NULL constraints. For this method, the versions of the tables before and after redefinition should have the same primary key columns. This is the preferred and default method of redefinition.
* By rowid—Use this method if no key is available. In this method, a hidden column named M_ROW$$ is added to the post-redefined version of the table. It is recommended that this column be dropped or marked as unused after the redefinition is complete. If COMPATIBLE is set to 10.2.0 or higher, the final phase of redefinition automatically sets this column unused. You can then use the ALTER TABLE ... DROP UNUSED COLUMNS statement to drop it.
You cannot use this method on index-organized tables.
Note:
* When you rebuild an index, you use an existing index as the data source. Creating an index in this manner enables you to change storage characteristics or move to a new tablespace. Rebuilding an index based on an existing data source removes intra-block fragmentation. Compared to dropping the index and using the CREATE INDEX statement, re-creating an existing index offers better performance.
Incorrect:
Not E: Edition-based redefinition enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time.
NEW QUESTION 243
Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?
- A. System privileges with the with grant option container all clause must be granted to a common user beforethe common user can grant privileges to other users.
- B. Local users cannot use local system privileges on the schema of a common user.
- C. The granter of system privileges must possess the set container privilege.
- D. Common users connected to a PDB can exercise privileges across other PDBs.
- E. System privileges apply only to the PDB in which they are used.
Answer: A,C,E
Explanation:
A, Not D: In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to
PUBLIC enable all local and common users to exercise these privileges in this PDB only.
C: A user can only perform common operations on a common role, for example, granting privileges commonly to the role, when the following criteria are met:
The user is a common user whose current container is root.
The user has the SET CONTAINER privilegegranted commonly, which means that the privilege applies in all containers.
The user has privilege controlling the ability to perform the specified operation, and this privilege has been granted commonly
Incorrect:
Note:
* Every privilege and rolegranted to Oracle-supplied users and roles is granted commonly except for system privileges granted to PUBLIC, which are granted locally.
NEW QUESTION 244
Which component resides in the System Global Area (SGA) of a database instance only in shared server connections?
- A. User Global Area
- B. PL/SQL Function Result Cache
- C. Program Global Area
- D. SQL Query Result Cache
Answer: A
NEW QUESTION 245
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?
- A. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
- B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
- C. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
- D. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
Answer: B
Explanation:
Explanation
About Startup Dependencies
Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first.
Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.
http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710
NEW QUESTION 246
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. It can be configured to automatically restart a database in case of normal shutdown of the database
instance. - C. While starting any components, it automatically attempts to start all dependencies first and in proper
order. - D. It runs periodic check operations to monitor the health of Oracle components.
- E. It can be used to only start Oracle components.
Answer: C,D,E
NEW QUESTION 247
......
New (2021) Oracle 1z0-062 Exam Dumps: https://www.examtorrent.com/1z0-062-valid-vce-dumps.html
Best Way To Study For Oracle 1z0-062 Exam Brilliant 1z0-062 Exam Questions PDF: https://drive.google.com/open?id=17cx6ExZ-y_2tpMSza0G5wGhA_SkbH-Yt
