1z0-062 PDF Pass Leader, 1z0-062 Latest Real Test
Valid 1z0-062 Test Answers & 1z0-062 Exam PDF
Oracle 1z0-062 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION 14
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. AWR contains system wide tracing and logging information.
- B. The AWR data is stored in memory and in the database.
- C. The snapshots collected by AWR are used by the self-tuning components in the database
- D. All AWR tables belong to the SYSTEM schema.
- E. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
Answer: B,C,E
NEW QUESTION 15
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
- A. Create the CREATE_TEST procedure with definer's rights.
- B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
- C. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
- D. Create the CREATE_TEST procedure with invoker's rights.
Answer: D
Explanation:
Explanation/Reference:
Explanation:
If a program unit does not need to be executed with the escalated privileges of the definer, you should specify that the program unit executes with the privileges of the caller, also known as the invoker. Invoker's rights can mitigate the risk of SQL injection.
Incorrect:
Not A: By default, stored procedures and SQL methods execute with the privileges of their owner, not their current user. Such definer-rights subprograms are bound to the schema in which they reside.
not B: Using the GRANT option, a user can grant an Object privilege to another user or to PUBLIC.
NEW QUESTION 16
You find this query being used in your Oracle 12c database:
Which method a used by the optimizer to limit the rows being returned?
- A. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
- B. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
- C. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows
- D. A TOP-N query is created to limit the rows to 20 percent of the total rows
Answer: A
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 17
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)
- A. You cannot have multiple SQL *Loader data files.
- B. You can selectively load rows into a table based on a filter.
- C. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
- D. You can have multiple bad files created when loading in parallel.
- E. If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory and uses it.
Answer: C,E
Explanation:
References: https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-
8BF3-2312893A67D7.htm#SUTIL3951
NEW QUESTION 18
A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:
What happens when the FAILGRP1failure group is corrupted?
- A. Transactions that are using the diskgroup fail.
- B. Data in the FAILGRP1failure group is moved to the FAILGRP2failure group and rebalancing is started.
- C. ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2failure group.
- D. Mirroring of allocation units occurs within the FAILGRP2failure group.
Answer: B
NEW QUESTION 19
- A. Ensure that HR_PDB is open.
- B. Take the user data tablespace offline.
- C. Place the root container in ARHCHIVELOG mode.
- D. Place the root container in the nomount stage.
- E. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?
Answer: C,E
NEW QUESTION 20
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
- A. It will create a multitenant container database (CDB) with only the root opened.
- B. It will create a CDB that must be plugged into an existing CDB.
- C. It will create a CDB with root opened and seed mounted.
- D. It will create a CDB with root opened and seed read only.
- E. It will create a CDB with root and seed opened and one PDB mounted.
Answer: D
Explanation:
* The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify
the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain
PDBs.
Along with the root (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). The following
graphic shows a newly created CDB:
* 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.
NEW QUESTION 21
For which three requirements would you use the Database Resource Manager? (Choose three.)
- A. limiting the degree of parallelism of operations performed by user sessions in a consumer group
- B. specifying the amount of private space a session can allocate in the shared pool of the SGA.
- C. limiting the CPU used per database call
- D. specifying the maximum number of concurrent sessions allowed for a user
- E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
Answer: A,D,E
Explanation:
Explanation/Reference:
References: http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm
NEW QUESTION 22
Which task is performed by a background process in a database instance?
- A. Copying online redo log files to offline storage
- B. Connecting between a client process and a dispatcher
- C. Executing PL/SQL code
- D. Creating dedicated server connections
Answer: A
NEW QUESTION 23
Your database is configured in ARCHIVELOGmode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)
- A. server parameter le (SPFILE)
- B. active online redo log le group
- C. inactive online redo log file group
- D. all the control flies
- E. a data file belonging to the default temporary tablespace
- F. a data file belonging to the SYSAUXtablespace
Answer: B,C,D
NEW QUESTION 24
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?
- A. Setting the session valid time using
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets thevisibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session. - B. The valid time columns employee_time_start and employee_time_end are automatically created.
- C. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
- D. The valid time columns are visible by default when the table is described.
- E. The valid time columns are not populated by the Oracle Server automatically.
Answer: A,B,C
Explanation:
A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which ishaving 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.
E: ENABLE_AT_VALID_TIME Procedure
This procedure enables session level valid time flashback.
NEW QUESTION 25
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 granted to SCOTT
- B. SYSTEM session, only if the MGR role is set in the session
- C. SCOTT sessions, only if the MGR role is set in the session
- D. SYSTEM sessions, regardless of the roles that are set in the session
- E. SCOTT sessions, because he is the owner of the table
- F. SYS sessions, regardless of the roles that are set in the session
Answer: A,D,F
NEW QUESTION 26
You Execute the Following command to create a password file in the database server:
$ orapwd file = '+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12'
Which two statements are true about the password file? (Choose two.)
- A. It records the usernames and passwords of users when granted the DBA role.
- B. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
- C. Is used by Oracle to authenticate users for remote database administration.
- D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
- E. It contains the usernames and passwords of users for whom auditing is enabled.
Answer: B,C
NEW QUESTION 27
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character Set: AL32UTF8
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
- A. RMAN
- B. Data Pump full export/import
- C. Transportable tablespace
- D. Transportable database
- E. The DBMS_PDB package
Answer: C
Explanation:
* Overview, example:
- Log into ncdb12c as sys
- Get the database in a consistent state by shutting it down cleanly.
- Open the database in read only mode
- Run DBMS_PDB.DESCRIBE to create an XML file describing the database.
- Shut down ncdb12c
- Connect to target CDB (CDB2)
- Check whether non-cdb (NCDB12c) can be plugged into CDB(CDB2)
- Plug-in Non-CDB (NCDB12c) as PDB(NCDB12c) into target CDB(CDB2).
- Access the PDB and run the noncdb_to_pdb.sql script.
- Open the new PDB in read/write mode.
* You can easily plug an Oracle Database 12c non-CDB into a CDB. Just create a PDB manifest file for the non-CDB, and then use the manifest file to create a cloned PDB in the CDB.
* Note that to plug in a non-CDB database into a CDB, the non-CDB database needs to be of version 12c as well. So existing 11g databases will need to be upgraded to 12c before they can be part of a 12c CDB.
NEW QUESTION 28
Which two can be recommendations given by SQL Access Advisor? (Choose two.)
- A. creation of SQL profiles
- B. creation of materialized views
- C. creation of SQL plan baselines
- D. creation of indexes
- E. rewriting of SQL statements
Answer: B,D
Explanation:
Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14211/advisor.htm#i1008370
NEW QUESTION 29
Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database?
- A. You cannot have multiple SQL *Loader data files.
- B. You can selectively load rows into a table based on a filer.
- C. TheDEGREE_OF_PARALLELISMparameter is set toAUTO.
- D. You can have multiple bad files created when loading in parallel.
- E. If no data file is specified, it assumes the data file to be<table-name>.datin the current directory and uses it.
Answer: C,E
Explanation:
References:https://docs.oracle.com/database/121/SUTIL/GUID-0F35B551-861B-450D-
8 BF3-2312893A67D7.htm#SUTIL3951
NEW QUESTION 30
You want to prevent a group of users in your database from performing long-running transactions that
consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during
execution of a data manipulation language (DML) statement, the operation should abort and return an
error. However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?
- A. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users
perform transactions. - B. Implement a Database Resource Manager plan.
- C. Implement a profile for these users.
- D. Specify the maximum amount of quota a user can be allocated in the undo tablespace.
Answer: B
NEW QUESTION 31
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 statement for granting a role to a user fails because the CONTAINER clause is not used.
- B. Privileges are granted to the C##A_ADMIN user only in the root database.
- C. The C # # ROLE1 role is created in the root database and all the PDBs.
- D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
- E. The C # # ROLE1 role is created only in the root database because the container clause is not used.
Answer: B,C
Explanation:
Explanation/Reference:
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 32
Which two statements are true about resumable space allocation? (Choose two.)
- A. A database-level LOGONtrigger can be used to automatically configure resumable statement settings
for individual sessions. - B. Free space in a segment is automatically reclaimed when a resumable statement is suspended
because of an out-of-space condition. - C. Resumable space allocation does not apply when users exceed their assigned space quota in a
tablespace. - D. A resumable statement can be suspended and resumed only once during a session.
- E. Resumable space allocation does not apply when a database instance uses asynchronous commit.
- F. SELECTstatements that run out of temporary space for sort areas are candidates for resumable
execution.
Answer: A,F
NEW QUESTION 33
......
1z0-062 Dumps Ensure Your Passing: https://topexamcollection.pdfvce.com/Oracle/1z0-062-exam-pdf-dumps.html